d o t logoUnited States Department of Transportation
  OST-R > BTS
transtats logo
 
Advanced Search
Resources
Data Tools
: T3: U.S. Air Carrier Airport Activity Statistics
   Database Profile   Data Tables   Table Profile
Latest Available Data: September 2017All Rows Shown
Field NameDescription
YearYear 
QuarterQuarterAnalysis
AirlineIDAn 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
UniqueCarrierUnique 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
UniqueCarrierNameUnique Carrier Name. When the same name has been used by multiple carriers, a numeric suffix is used for earlier users, for example, Air Caribbean, Air Caribbean (1). 
UniqCarrierEntityUnique Entity for a Carrier's Operation Region. Not Available for Three Years When Data are Summarized only on the Carrier Level for Confidentiality.Analysis
CarrierRegionCarrier's Operation Region. Carriers Report Data by Operation Region. Not Available for Three Years When Data are Summarized only on the Carrier Level for Confidentiality. 
CarrierCode 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. 
CarrierNameCarrier Name 
CarrierGroupCarrier Group Code. Used in Legacy Analysis 
CarrierGroupNewCarrier Group New 
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
OriginAirport CodeAnalysis
OriginCityNameAirport City Name 
OriginCountryNameCountry Name 
OriginStateNameState Name 
OriginStateFipsOrigin State FIPSAnalysis
OriginStateOrigin State CodeAnalysis
OriginWacWorld Area CodeAnalysis
ServiceClassService Class (Scheduled, Non-Scheduled, etc.)Analysis
SchDeparturesScheduled DeparturesAnalysis
DepPerformedTotal Departures PerformedAnalysis
PassengersTotal PassengersAnalysis
FreightTotal Freight (Tons)Analysis
MailTotal Mail (Tons)Analysis
NumMonthsNumber of Months that the Carrier Reported in the Quarter (1, 2, or 3) 
All Rows Shown