Airline Data Tables

Airline Analysis

by Robert G Herbst

Airline Mainline Data

November 13, 2008 .. (last update to this page)

***NEW FEATURE***

Click here for interactive charts which provide recently filed SEC and BTS data for each of the 8 airlines covered on this website. Charts will be updated regularly. (Last update was Nov 17, 2008).

Charts provide the option to make -what if- changes to recently filed SEC and BTS data to project estimates for the next quarter or/and year 2008. (Note: Changes made to the Q4 data will automatically transfer to year 2008.)

Changes you make will auto calculate future projections for: Operating Income and Expense categories, cash flows, fare increase/decrease to break-even, days to a minimum cash position etc.

If you want to see the -bottom line- financial impact to each airline from changes like a large increase or decrease in fuel expense or and labor, it will be easy to find with these charts. (Interactive charts require an Excel reader to use.)

Charts now include a summary table that automatically recalculates your operational and financial changes to project the net profit/loss estimates for Q4 and year 2008.

Charts are currently defaulted to estimates from AirlineFinancials.com with EPS comparisons to First Call and Zacks.

For a PDF read only file of the charts, click here.

For a free Excel reader from Microsoft, click here.

********************************************************************************************************************

For historical data see below:

Clicking on each link below for the airline you want data for, will bring up a two page table in PDF format.

There are two ways to view the airline data.

1. Each airline can be viewed and printed separately with historical data back to include year 2002.

2. Years 2006 and 2007 will provide side-by side comparisons for all 8 airlines.

The first page for each report shows primarily SEC and BTS data. The second page provides ratios and calculations for numerous financial, operational, labor and passenger metrics.

The data from these tables is linked to the graphs provided on the [Airline-to-Airline] page where you will find over 70 easy to interpret graphs.

This page provides mainline data except where noted. Each airlines regional affiliate data and information can be found on the [Mainline Affiliate] page.

Labor contract information summaries are provided below.

*******************************************************************************************************************

Click on each airline below for a quick link to information and analysis.

American Airlines

United Airlines

Delta Airlines

Continental Airlines

Northwest Airlines

USAirways/America West

Southwest Airlines

JetBlue Airlines

*******************************************************************************************************************

(Click here for a PDF file of the notes and glossary to tables and data.)

Click on the year to pull up side by side airline comparisons.

2007

2006

*******************************************************************************************************************

Labor contract information on the airlines covered by this website-

A majority of American Airline employees are members of a union. Nearly all American labor contracts are amendable in May of 2008.

Approximately 81% of United Airline employees are members of a union. Nearly all labor contracts for United are amendable in January 2010.

Approximately 17% of the Delta Airline employees are members of a union. The Delta contracts are amendable in December of 2009.

Approximately 44% of Continental Airline employees are members of a union. Nearly all Continental labor contracts are amendable between now and December 2009.

Approximately 85% of Northwest Airline employees are members of a union. Nearly all Northwest contracts are amendable in December of 2011.

A majority of USAirway employees are members of a union. Nearly all USAirway labor contracts are amendable in December of 2011. As of this date, USAirway and America West pilots have not been approved for "single carrier" by the National Mediation Board.

Approximately 82% of Southwest Airline employees are members of a union. The majority of Southwest contracts are amendable by November 2008.

****************************************************************************