USA Banner

Official US Government Icon

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure Site Icon

Secure .gov websites use HTTPS
A lock ( ) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

Site Notification

Site Notification

U.S. Department of TransportationU.S. Department of Transportation IconUnited States Department of TransportationUnited States Department of Transportation
BTS> TranStats
transtats logo
 
Advanced Search
Resources
Data Tools
: Reporting Carrier On-Time Performance (1987-present)
   Database Profile   Data Tables   Table Profile
Latest Available Data: December 2023<<Prev   Rows : 1 - 100 of 111   Next>>
Field NameDescription
Summaries
*OntimeArrivalPctPercent of flights that arrive on time. For percent of on time arrivals at specific airports, click Analysis. Note: If you select Origin as a category, you get percent of flights that depart from those airports and arrive on time.Analysis
*OntimeDeparturePctPercent of flights that depart on time. For percent of on time departures at specific airports, click Analysis. Note: If you select Dest as a category, you get percent of flights that depart on time and arrive at those airports.Analysis
Time Period
YearYear 
QuarterQuarter (1-4)Analysis
MonthMonthAnalysis
DayofMonthDay of Month 
DayOfWeekDay of WeekAnalysis
FlightDateFlight Date (yyyymmdd) 
Airline
Reporting_AirlineUnique 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.Analysis
DOT_ID_Reporting_AirlineAn 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.Analysis
IATA_CODE_Reporting_AirlineCode 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. 
Tail_NumberTail Number 
Flight_Number_Reporting_AirlineFlight Number 
Origin
OriginAirportIDOrigin 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.Analysis
OriginAirportSeqIDOrigin 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. 
OriginCityMarketIDOrigin 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.Analysis
OriginOrigin AirportAnalysis
OriginCityNameOrigin Airport, City Name 
OriginStateOrigin Airport, State CodeAnalysis
OriginStateFipsOrigin Airport, State FipsAnalysis
OriginStateNameOrigin Airport, State Name 
OriginWacOrigin Airport, World Area CodeAnalysis
Destination
DestAirportIDDestination 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.Analysis
DestAirportSeqIDDestination 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. 
DestCityMarketIDDestination 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.Analysis
DestDestination AirportAnalysis
DestCityNameDestination Airport, City Name 
DestStateDestination Airport, State CodeAnalysis
DestStateFipsDestination Airport, State FipsAnalysis
DestStateNameDestination Airport, State Name 
DestWacDestination Airport, World Area CodeAnalysis
Departure Performance
CRSDepTimeCRS Departure Time (local time: hhmm) 
DepTimeActual Departure Time (local time: hhmm) 
DepDelayDifference in minutes between scheduled and actual departure time. Early departures show negative numbers.Analysis
DepDelayMinutesDifference in minutes between scheduled and actual departure time. Early departures set to 0.Analysis
DepDel15Departure Delay Indicator, 15 Minutes or More (1=Yes)Analysis
DepartureDelayGroupsDeparture Delay intervals, every (15 minutes from <-15 to >180)Analysis
DepTimeBlkCRS Departure Time Block, Hourly IntervalsAnalysis
TaxiOutTaxi Out Time, in MinutesAnalysis
WheelsOffWheels Off Time (local time: hhmm) 
Arrival Performance
WheelsOnWheels On Time (local time: hhmm) 
TaxiInTaxi In Time, in MinutesAnalysis
CRSArrTimeCRS Arrival Time (local time: hhmm) 
ArrTimeActual Arrival Time (local time: hhmm) 
ArrDelayDifference in minutes between scheduled and actual arrival time. Early arrivals show negative numbers.Analysis
ArrDelayMinutesDifference in minutes between scheduled and actual arrival time. Early arrivals set to 0.Analysis
ArrDel15Arrival Delay Indicator, 15 Minutes or More (1=Yes)Analysis
ArrivalDelayGroupsArrival Delay intervals, every (15-minutes from <-15 to >180)Analysis
ArrTimeBlkCRS Arrival Time Block, Hourly IntervalsAnalysis
Cancellations and Diversions
CancelledCancelled Flight Indicator (1=Yes)Analysis
CancellationCodeSpecifies The Reason For CancellationAnalysis
DivertedDiverted Flight Indicator (1=Yes)Analysis
Flight Summaries
CRSElapsedTimeCRS Elapsed Time of Flight, in MinutesAnalysis
ActualElapsedTimeElapsed Time of Flight, in MinutesAnalysis
AirTimeFlight Time, in MinutesAnalysis
FlightsNumber of FlightsAnalysis
DistanceDistance between airports (miles)Analysis
DistanceGroupDistance Intervals, every 250 Miles, for Flight SegmentAnalysis
Cause of Delay (Data starts 6/2003)
CarrierDelayCarrier Delay, in MinutesAnalysis
WeatherDelayWeather Delay, in MinutesAnalysis
NASDelayNational Air System Delay, in MinutesAnalysis
SecurityDelaySecurity Delay, in MinutesAnalysis
LateAircraftDelayLate Aircraft Delay, in MinutesAnalysis
Gate Return Information at Origin Airport (Data starts 10/2008)
FirstDepTimeFirst Gate Departure Time at Origin Airport 
TotalAddGTimeTotal Ground Time Away from Gate for Gate Return or Cancelled FlightAnalysis
LongestAddGTimeLongest Time Away from Gate for Gate Return or Cancelled FlightAnalysis
Diverted Airport Information (Data starts 10/2008)
DivAirportLandingsNumber of Diverted Airport LandingsAnalysis
DivReachedDestDiverted Flight Reaching Scheduled Destination Indicator (1=Yes)Analysis
DivActualElapsedTimeElapsed Time of Diverted Flight Reaching Scheduled Destination, in Minutes. The ActualElapsedTime column remains NULL for all diverted flights.Analysis
DivArrDelayDifference in minutes between scheduled and actual arrival time for a diverted flight reaching scheduled destination. The ArrDelay column remains NULL for all diverted flights.Analysis
DivDistanceDistance between scheduled destination and final diverted airport (miles). Value will be 0 for diverted flight reaching scheduled destination.Analysis
Div1AirportDiverted Airport Code1 
Div1AirportIDAirport ID of Diverted Airport 1. Airport ID is a Unique Key for an Airport 
Div1AirportSeqIDAirport Sequence ID of Diverted Airport 1. Unique Key for Time Specific Information for an Airport 
Div1WheelsOnWheels On Time (local time: hhmm) at Diverted Airport Code1 
Div1TotalGTimeTotal Ground Time Away from Gate at Diverted Airport Code1 
Div1LongestGTimeLongest Ground Time Away from Gate at Diverted Airport Code1 
Div1WheelsOffWheels Off Time (local time: hhmm) at Diverted Airport Code1 
Div1TailNumAircraft Tail Number for Diverted Airport Code1 
Div2AirportDiverted Airport Code2 
Div2AirportIDAirport ID of Diverted Airport 2. Airport ID is a Unique Key for an Airport 
Div2AirportSeqIDAirport Sequence ID of Diverted Airport 2. Unique Key for Time Specific Information for an Airport 
Div2WheelsOnWheels On Time (local time: hhmm) at Diverted Airport Code2 
Div2TotalGTimeTotal Ground Time Away from Gate at Diverted Airport Code2 
Div2LongestGTimeLongest Ground Time Away from Gate at Diverted Airport Code2 
Div2WheelsOffWheels Off Time (local time: hhmm) at Diverted Airport Code2 
Div2TailNumAircraft Tail Number for Diverted Airport Code2 
Div3AirportDiverted Airport Code3 
Div3AirportIDAirport ID of Diverted Airport 3. Airport ID is a Unique Key for an Airport 
Div3AirportSeqIDAirport Sequence ID of Diverted Airport 3. Unique Key for Time Specific Information for an Airport 
Div3WheelsOnWheels On Time (local time: hhmm) at Diverted Airport Code3 
Div3TotalGTimeTotal Ground Time Away from Gate at Diverted Airport Code3 
Div3LongestGTimeLongest Ground Time Away from Gate at Diverted Airport Code3 
Div3WheelsOffWheels Off Time (local time: hhmm) at Diverted Airport Code3 
Div3TailNumAircraft Tail Number for Diverted Airport Code3 
Div4AirportDiverted Airport Code4 
Div4AirportIDAirport ID of Diverted Airport 4. Airport ID is a Unique Key for an Airport 
Div4AirportSeqIDAirport Sequence ID of Diverted Airport 4. Unique Key for Time Specific Information for an Airport 
Div4WheelsOnWheels On Time (local time: hhmm) at Diverted Airport Code4 
Div4TotalGTimeTotal Ground Time Away from Gate at Diverted Airport Code4 
<<Prev   Rows : 1 - 100 of 111   Next>>