AirLine Reports and Queries

Home	Aviation Reports and Queries AirLine Reports and Queries Fee Based Services Database Description
	Airline On-Time Performance Airline Traffic Air Carrier Profit/Loss Air Carrier Fuel Air Carrier Expenses

AirLine Reports and Queries

We are happy to provide these free reports and queries as a demonstration of the capabilities and data content of our database. Most of the queries provide a variety of selection criteria and allow tailored output either to the screen or as a download in text or spreadsheet format. If these reports and queries do not meet your needs, please contact us to inquire how AviationDB can generate and run custom reports and build custom interactive interfaces to meet your specific requirements.

A380

Most of these reports and queries require registration and need an email address in order to receive a password. No other information is requested. Unless legally required, we will not share this e-mail address outside of our organization.

The data is gathered from a variety of government agencies and stored in our relational database. See the Database Description for specific information.

Our free queries and reports are as follows:

Airline and Air Carrier On-Time, Capacity, and Financial Reports and Queries
- Airline and Air Carrier On Time Performance - These queries and reports use on-time performance data from the Bureau of Transportation Statistics (BTS). Contains scheduled and actual departure and arrival times reported by certified U.S. air carriers that account for at least one percent of domestic scheduled passenger revenues. There are over 110 million individual flight records available from October 1, 1987 to current.
  - Airline On-Time Performance Report - This query will generate a report showing flight delay information for non-stop domestic segments by major air carriers for the most current month available. Limited customization but no e-mail address is required.
  - Airline On-time Performance Query, Summary - Summarizes the data for statistical analysis. Can be used to determine trends over time by carrier, flight origin and destination, and length of flight.
  - Airline On-time Performance Query, Detail - Detailed on-time performance data for individual flights (non-stop segments).
- Airline Profit and Loss - Quarterly profit and loss statements for carriers with annual operating revenues of $20 million or more. The data include operating revenues, operating expenses, depreciation and amortization, operating profit, income tax, and net income and is available from January 2000 to current. Source is the Bureau of Transportation Statistics on form 41 P-12.
  - Air Carrier Profit/Loss - Brief - Easy to use query to generate fuel usage reports.
  - Air Carrier Profit/Loss - Full - Detailed query with over 40 fields to select and view.
- Airline Expenses - Quarterly operating expenses, by objective grouping, for carriers with annual operating revenues of $20 million or more, and include such items as salaries, benefits, materials purchased, services purchased, depreciation, amortization, food, and other operating expenses. Data is available from January 2000 to current. Source is the Bureau of Transportation Statistics on form 41 P-6.
  - Air Carrier Expenses - Brief - Easy to use query to generate fuel usage reports.
  - Air Carrier Expenses - Full - Detailed query with over 30 fields to select and view.
- Airline Fuel Usage and Costs - Monthly reported fuel costs, and gallons of fuel consumed, by air carrier and category of fuel use, including scheduled and non-scheduled service for domestic and international traffic regions. Data is available for major, national, and regional air carriers subject to reporting requirements and is available from January 2000 to current. Source is the Bureau of Transportation Statistics on form 41 P-12A.
  - Air Carrier Monthly Fuel Report - Brief - Easy to use query to generate fuel usage reports.
  - Air Carrier Monthly Fuel Report - Full - Detailed fuel usage query with over 40 fields to select and view.
- Airline Traffic Query - Monthly data as reported to the Bureau of Transportation Statistics on form 41 (T100 Segment) by certificated U.S. and foreign air carriers, for both scheduled and unscheduled flights, on passengers, freight, and mail transported. Air carrier statistics may be selected by carrier, origin, destination and other criteria. Data is available for each month from January 1990.

Legal