Air Carrier Profit and Loss Query - Full

Contains detailed profit and loss statistics for major, national, and regional air carriers. The data comes from the Bureau of Transportation Statistics (BTS), Form 41 Financial Schedule, form P-12. There are records available from January 1990 through September 2023 . Constellation

For more queries and reports from the Profit and Loss database try: General query help is available. In addition, detailed help is provided for a data item when it is displayed as a link.

See the Overview of all of the reports and queries available for Airline Industry statistics, including on-time performance, capacity and utilization, fuel usage, profit and loss, and expenses.

In addition to the free reports and queries, we provide Custom Reporting Solutions using the AviationDB database, including one time and periodic report generation. See for more information.

General help and hints are available if you are not getting the results you wanted on the this report. Help is also provided for a Data Item when it is displayed as a link.

Data Item Display Criteria Value(s)
Start Year/Quarter    
End Year/Quarter    
Transport Revenue Passenger
Total Property
Property Freight
Property Excess Bag
Total Charter
Charter Passenger
Charter Property
Total Misc Revenue
Reservation Cancel Fees
Misc Operating Revenue
Public Service Revenue
Transport Revenue
Operating Revenues
Flying Operations
Passenger Service
Aircraft Services
Promotion Sales
General Admin
General Services
Deprecation Amortization
Transport Expenses
Operating Expenses
Operating Profit Loss
Interest Long Debt
Interest Expense Other
Foreign Exchange Gains
Capitol Gains Property
Capitol Gains Other
Other Income Net
Non Operating Income
Income Pre Tax
Income Tax
Income Before Other Accounts
Discontinued Operations
Extra Items
Income Tax Extra
Income Tax Credits
Accounting Changes
Net Income


General Help

The fields can be used to select and group the data items to be returned, select the data to return, choose the output format, and to reset the fields to their default values. For best results, start with the fewest values and broadest criteria ( for instance "contains" instead of "equals"). If there are too many results, use more values and narrower criteria. Depending on the criteria used, it could take as much as 2 minutes to return the results of the query.

Group By
Click on the boxes to display and group the data items to be returned.

One and only one may be chosen per data item and take effect if any entries are made into the "value(s)" column. Comparisons are not case sensitive and the data item need not be selected for display to be used as criteria. The selections are:
Equal (default)
Exactly matches the specified value. Multiple values, separated by a comma, may be entered.
Not Equal
Does not match the specified value. One and only value may be entered.
Equal or Less
Matches the specified value and any values less than that entered. One and only value may be entered.
Equal or More
Matches the specified value and any values more than that entered. One and only value may be entered.
Equal to or greater than and equal to or less than the specified values (two are required).
Starts With
Matches all items that start with this value. One and only value may be entered.
Matches all items that contain this value. One and only value may be entered.

Dates can be entered in many formats including "YYYY-MM-DD" or "MM/DD/YYYY".
Are not case sensitive.
Can be drop down list boxes or entered values.
Multiple values can be selected in drop down list boxes using the "control" or "shift" keys.
Values in drop down list boxes can be de-selected by click on the value while pressing the "control" key.
If more than one value is entered, separated them with a comma (stuff,more stuff).

Data Item Help

Custom Reports Copyright 2001 - 2024 AviationDB.com Corp. All Rights Reserved Legal Contact Us