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

Home
Summary Airline On-Time Performance Query

Contains summary on-time performance data for all airlines having one percent or more of the domestic scheduled passenger revenues. There are over 100 million individual flight records from October 1, 1987 to May 2008 that may be selected and grouped by flight date, carrier, origin, destination, and flight distance.

This query will return summary Comet information for each grouping consisting of "Total Flights", "% Flights On Time", "% Flights Late", "% Flights Canceled", "% Flights Diverted", "Average Departure Delay", and "Average Arrival Delay". For more information about the query's results, see the definitions of the summary fields. General query help is available. In addition, detailed help is provided for a data item when it is displayed as a link.

Depending on the query selection criteria, grouping, and other activity on the system, it could take up to 2 minutes to return the results. A maximum of one years's data can be selected for each request.

Detailed airline on-time performance data can be found at the Airline On-time Performance - Detail query. Quick Airline On-Time Performance by Segment, Airline On-time Performance By Destination Report, and Airline On-time Performance By Carrier Report reports are also available.

Should you require custom reports or queries using this data on a one time or periodic basis or would like to integrate this database into your application, please contact us.


Data Item Group By Criteria Value(s)
Starting Year/Month of Report
Number of Months on Report
Carrier
Origin
Destination
Flight Number
Total Number of Flights
% Flights On Time

Output Type: HTML Spreadsheet Text
   
E-Mail address is required if not previously registered

General Help

The fields can be used to group the data items to be returned, restrict the number of results to be returned, choose the output format, select the number of results to return, 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 select or unselect items to group the results by.

Criteria
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.
Between
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.
Contains
Matches all items that contain this value. One and only value may be entered.

Value(s)
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).

Output format
The output can be formatted as HTML (default), text, or spreadsheet.
If the spreadsheet option is selected and MS Excel is identified to your browser, Excel will automatically open with the results of the query. If your browser does not know about Excel, a prompt to save the data will be displayed.

Data Item Help


Starting Year/Month of Report
The starting year and month of flights desired.

Number of Months on Report
The number of months on the report.

Carrier
Airline name.
If selected, output is sorted by this field.

Origin
Origin airport name.
If selected, output is sorted by this field.

Destination
Destination airport name.
If selected, output is sorted by this field.

Flight Number
Carrier's flight number.
Note that selecting and/or grouping by by flight number without also selecting carrier will probably not return a valid result.
If selected, output is sorted by this field.


Summary Output Column Definitions
Item Definition
Total Flights Total number of flights.
% Flights On Time Percentage of flights that arrived within "Minutes to Qualify as Late" of their scheduled arrival time. Does not include diverted or cancelled flights
% Flights Late Percentage of flights that arrived 15 minutes after their scheduled arrival time. Note that this is the BTS default.
% Flights Canceled Percentage of flights that were cancelled.
% Flights Diverted Percentage of flights that were diverted.
Average Departure Delay Average minutes a departure was delayed for all flights.
Average Arrival Delay Average minutes a flight arrived after the scheduled arrival time for flights that were late.
Legal Copyright 2001 - 2008 AviationDB.com Corp. All Rights Reserved Contact Us