Find the latest Coronavirus-related transportation statistics on the BTS Covid-19 landing page

General

BTS> TranStats
transtats logo
 
Advanced Search
Resources
Data Finder
By Mode
By Subject
On-Time : Reporting Carrier On-Time Performance (1987-present)
Latest Available Data: March 2022 Databases    Data Tables    Table Contents
Download Instructions
Filter Geography
Filter Year
Filter Period
      Prezipped File      % Missing in table         Documentation      Term     
Field NameDescriptionSupport Table
Time Period
Year
Quarter (1-4)Get Lookup Table
MonthGet Lookup Table
Day of Month
Day of WeekGet Lookup Table
Flight Date (yyyymmdd)
Airline
Unique Carrier Code. When the same code has been used by multiple carriers, a numeric suffix is used for earlier users, for example, PA, PA(1), PA(2). Use this field for analysis across a range of years.Get Lookup Table
An identification number assigned by US DOT to identify a unique airline (carrier). A unique airline (carrier) is defined as one holding and reporting under the same DOT certificate regardless of its Code, Name, or holding company/corporation.Get Lookup Table
Code assigned by IATA and commonly used to identify a carrier. As the same code may have been assigned to different carriers over time, the code is not always unique. For analysis, use the Unique Carrier Code.Get Lookup Table
Tail Number
Flight Number
Origin
Origin Airport, Airport ID. An identification number assigned by US DOT to identify a unique airport. Use this field for airport analysis across a range of years because an airport can change its airport code and airport codes can be reused.Get Lookup Table
Origin Airport, Airport Sequence ID. An identification number assigned by US DOT to identify a unique airport at a given point of time. Airport attributes, such as airport name or coordinates, may change over time.Get Lookup Table
Origin Airport, City Market ID. City Market ID is an identification number assigned by US DOT to identify a city market. Use this field to consolidate airports serving the same city market.Get Lookup Table
Origin AirportGet Lookup Table
Origin Airport, City Name
Origin Airport, State CodeGet Lookup Table
Origin Airport, State FipsGet Lookup Table
Origin Airport, State Name
Origin Airport, World Area CodeGet Lookup Table
Destination
Destination Airport, Airport ID. An identification number assigned by US DOT to identify a unique airport. Use this field for airport analysis across a range of years because an airport can change its airport code and airport codes can be reused.Get Lookup Table
Destination Airport, Airport Sequence ID. An identification number assigned by US DOT to identify a unique airport at a given point of time. Airport attributes, such as airport name or coordinates, may change over time.Get Lookup Table
Destination Airport, City Market ID. City Market ID is an identification number assigned by US DOT to identify a city market. Use this field to consolidate airports serving the same city market.Get Lookup Table
Destination AirportGet Lookup Table
Destination Airport, City Name
Destination Airport, State CodeGet Lookup Table
Destination Airport, State FipsGet Lookup Table
Destination Airport, State Name
Destination Airport, World Area CodeGet Lookup Table
Departure Performance
CRS Departure Time (local time: hhmm)
Actual Departure Time (local time: hhmm)
Difference in minutes between scheduled and actual departure time. Early departures show negative numbers.
Difference in minutes between scheduled and actual departure time. Early departures set to 0.
Departure Delay Indicator, 15 Minutes or More (1=Yes)Get Lookup Table
Departure Delay intervals, every (15 minutes from <-15 to >180)Get Lookup Table
CRS Departure Time Block, Hourly IntervalsGet Lookup Table
Taxi Out Time, in Minutes
Wheels Off Time (local time: hhmm)
Arrival Performance
Wheels On Time (local time: hhmm)
Taxi In Time, in Minutes
CRS Arrival Time (local time: hhmm)
Actual Arrival Time (local time: hhmm)
Difference in minutes between scheduled and actual arrival time. Early arrivals show negative numbers.
Difference in minutes between scheduled and actual arrival time. Early arrivals set to 0.
Arrival Delay Indicator, 15 Minutes or More (1=Yes)Get Lookup Table
Arrival Delay intervals, every (15-minutes from <-15 to >180)Get Lookup Table
CRS Arrival Time Block, Hourly IntervalsGet Lookup Table
Cancellations and Diversions
Cancelled Flight Indicator (1=Yes)Get Lookup Table
Specifies The Reason For CancellationGet Lookup Table
Diverted Flight Indicator (1=Yes)Get Lookup Table
Flight Summaries
CRS Elapsed Time of Flight, in Minutes
Elapsed Time of Flight, in Minutes
Flight Time, in Minutes
Number of Flights
Distance between airports (miles)
Distance Intervals, every 250 Miles, for Flight SegmentGet Lookup Table
Cause of Delay (Data starts 6/2003)
Carrier Delay, in Minutes
Weather Delay, in Minutes
National Air System Delay, in Minutes
Security Delay, in Minutes
Late Aircraft Delay, in Minutes
Gate Return Information at Origin Airport (Data starts 10/2008)
First Gate Departure Time at Origin Airport
Total Ground Time Away from Gate for Gate Return or Cancelled Flight
Longest Time Away from Gate for Gate Return or Cancelled Flight
Diverted Airport Information (Data starts 10/2008)
Number of Diverted Airport LandingsGet Lookup Table
Diverted Flight Reaching Scheduled Destination Indicator (1=Yes)Get Lookup Table
Elapsed Time of Diverted Flight Reaching Scheduled Destination, in Minutes. The ActualElapsedTime column remains NULL for all diverted flights.
Difference in minutes between scheduled and actual arrival time for a diverted flight reaching scheduled destination. The ArrDelay column remains NULL for all diverted flights.
Distance between scheduled destination and final diverted airport (miles). Value will be 0 for diverted flight reaching scheduled destination.
Diverted Airport Code1
Airport ID of Diverted Airport 1. Airport ID is a Unique Key for an AirportGet Lookup Table
Airport Sequence ID of Diverted Airport 1. Unique Key for Time Specific Information for an AirportGet Lookup Table
Wheels On Time (local time: hhmm) at Diverted Airport Code1
Total Ground Time Away from Gate at Diverted Airport Code1
Longest Ground Time Away from Gate at Diverted Airport Code1
Wheels Off Time (local time: hhmm) at Diverted Airport Code1
Aircraft Tail Number for Diverted Airport Code1
Diverted Airport Code2
Airport ID of Diverted Airport 2. Airport ID is a Unique Key for an AirportGet Lookup Table
Airport Sequence ID of Diverted Airport 2. Unique Key for Time Specific Information for an AirportGet Lookup Table
Wheels On Time (local time: hhmm) at Diverted Airport Code2
Total Ground Time Away from Gate at Diverted Airport Code2
Longest Ground Time Away from Gate at Diverted Airport Code2
Wheels Off Time (local time: hhmm) at Diverted Airport Code2
Aircraft Tail Number for Diverted Airport Code2
Diverted Airport Code3
Airport ID of Diverted Airport 3. Airport ID is a Unique Key for an AirportGet Lookup Table
Airport Sequence ID of Diverted Airport 3. Unique Key for Time Specific Information for an AirportGet Lookup Table
Wheels On Time (local time: hhmm) at Diverted Airport Code3
Total Ground Time Away from Gate at Diverted Airport Code3
Longest Ground Time Away from Gate at Diverted Airport Code3
Wheels Off Time (local time: hhmm) at Diverted Airport Code3
Aircraft Tail Number for Diverted Airport Code3
Diverted Airport Code4
Airport ID of Diverted Airport 4. Airport ID is a Unique Key for an AirportGet Lookup Table
Airport Sequence ID of Diverted Airport 4. Unique Key for Time Specific Information for an AirportGet Lookup Table
Wheels On Time (local time: hhmm) at Diverted Airport Code4
Total Ground Time Away from Gate at Diverted Airport Code4
Longest Ground Time Away from Gate at Diverted Airport Code4
Wheels Off Time (local time: hhmm) at Diverted Airport Code4
Aircraft Tail Number for Diverted Airport Code4
Diverted Airport Code5
Airport ID of Diverted Airport 5. Airport ID is a Unique Key for an AirportGet Lookup Table
Airport Sequence ID of Diverted Airport 5. Unique Key for Time Specific Information for an AirportGet Lookup Table
Wheels On Time (local time: hhmm) at Diverted Airport Code5
Total Ground Time Away from Gate at Diverted Airport Code5
Longest Ground Time Away from Gate at Diverted Airport Code5
Wheels Off Time (local time: hhmm) at Diverted Airport Code5
Aircraft Tail Number for Diverted Airport Code5