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

Home
Airline On-Time Performance Query - Detail

Contains detailed on-time performance data for all airlines having one percent or more of the domestic scheduled passenger revenues. There are over 150 million individual flight records available from October 1, 1987 to November 2011 . X31

Statistical analysis of the airline on-time performance data can be found at the Summary Airline On-time Performance query. Quick reports Airline On-time Performance By Destination Report, and Airline On-time Performance By Carrier Report are also available.

A maximum of one month's data can be selected for each request. 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.

Should you require custom reports or queries using this data (or any other of our Aviation databases) on a one time or periodic basis or would like to integrate an AviationDB database into your application, please contact us.


Data Item Display Criteria Value(s)
Date of Flight checked From
To
Carrier checked
Origin checked
Destination checked
Scheduled Departure Time (format is HH:MM) checked
Flight Number checked
Tail Number
Departure Delay (in minutes)
Scheduled Arrival Time (format is HH:MM)
Arrival Delay (in minutes)
Air Time (in minutes)
Flight Distance (in miles)
Taxi In Time (in minutes)
Taxi Out Time (in minutes)
Flight Cancelled
Cancellation Reason
Flight Diverted
Carrier Delay (in minutes)
Weather Delay (in minutes)
National Airspace Delay (in minutes)
Security Delay (in minutes)
Late Aircraft Delay (in minutes)

   

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.

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).

Data Item Help


Flight Date
The date of the flight.
Always displayed and cannot be deselected.
Must be a range (between dates) and less that a month.
Output is sorted by this field.

Carrier
Airline name.
Always displayed and cannot be deselected.
Output is sorted by this field.

Origin
Origin airport name.
Always displayed and cannot be deselected.
Output is sorted by this field.

Destination
Destination airport name.
Always displayed and cannot be deselected.
Output is sorted by this field.

Flight Number
Airlines's flight number.
Always displayed and cannot be deselected.
Output is sorted by this field.
Legal Copyright 2001 - 2011 AviationDB.com Corp. All Rights Reserved Contact Us