AirLine Reports and Queries

Home	Aviation Reports and Queries, Fee Based Services, Database Description
	AirLine Industry Statistical Reports and Queries > 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

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 Airline and Air Carrier On-Time, Capacity, and Financial Reports and Queries are as follows:

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 150 million individual flight records available from October 1, 1987 to current.

Airline On-Time Performance By Destination Report - Flight delay information for all destinations with more that 1000 arrivals per month. Limited customization but no e-mail address is required.
Airline On-Time Performance By Carrier Report - Flight delay information by major air carriers. 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.
- Airline Net Profit by Carrier Report - Net profit for the major air carriers. Limited customization but no e-mail address is required.
- Air Carrier Profit/Loss Query - Brief - Easy to use query to generate a report of profit and loss statistics for major, national, and regional air carriers.
- Air Carrier Profit/Loss Query - 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.
- Fuel as a Percentage of Operating Expense by Carrier Report - Displays fuel cost, total operating expenses, and the percentage of the operating expense for fuel. Limited customization but no e-mail address is required.
- Air Carrier Expenses Query - Brief - Easy to use query to generate fuel usage reports.
- Air Carrier Expenses Query - Full - Detailed query with over 30 fields to select and view.
Airline Fuel Usage and Costs - Monthly reported fuel costs, and gallons of fuelconsumed, 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.
- Airline Fuel by Carrier Report - Monthly fuel costs and fuel used for the major air carriers. Limited customization but no e-mail address is required.
- Air Carrier Monthly Fuel Query - Summary - Easy to use query to generate fuel usage reports.
- Air Carrier Monthly Fuel Query - Detail - Detailed fuel usage query with over 40 fields to select and view.
Airline Traffic, Capacity, and Utilization - 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. Contains statistics for passengers, freight, and mail transported versus seat and freight capacity. Data is available for each month from January 1990.
- Airline Seat Capacity and Utilization by Carrier Report - Displays total seats, passengers, and capacity used by carrier for a given month for carriers that had at least 10,000 seats per month. Limited customization but no e-mail address is required.
- Airline Capacity and Utilization Query - Air carrier statistics may be selected by carrier, origin, destination and other criteria.

Legal