The Wayback Machine - https://web.archive.org/web/20180615032027/https://www.transtats.bts.gov/DL_SelectFields.asp?Table_ID=260
d o t logoUnited States Department of Transportation
  OST-R > BTS
transtats logo
 
Advanced Search
Resources
Data Tools
: T-100 International Market (All Carriers)
   Data Tables   Table Contents
Download Instructions   
Latest Available Data: December 2017
Select all fields   % Missing in table Documentation Terms
Field Name   Description   Support Table 
Summaries
Passengers On-Flight Market Passengers Enplaned  
Freight On-Flight Market Freight Enplaned (pounds)  
Mail On-Flight Market Mail Enplaned (pounds)  
Distance Distance between airports (miles)  
Carrier
UniqueCarrier 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
AirlineID 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
UniqueCarrierName Unique 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).  
UniqCarrierEntity Unique Entity for a Carrier's Operation Region. Get Lookup Table
CarrierRegion Carrier's Operation Region. Carriers Report Data by Operation Region Get Lookup Table
Carrier 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
CarrierName Carrier Name  
CarrierGroup Carrier Group Code. Used in Legacy Analysis Get Lookup Table
CarrierGroupNew Carrier Group New Get Lookup Table
Origin
OriginAirportID 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
OriginAirportSeqID 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
OriginCityMarketID 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 Origin Airport Get Lookup Table
OriginCityName Origin Airport, City Name  
OriginCountry Origin Airport, Country Get Lookup Table
OriginCountryName Origin Airport, Country Name  
OriginWac Origin Airport, World Area Code Get Lookup Table
Destination
DestAirportID 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
DestAirportSeqID 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
DestCityMarketID 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
Dest Destination Airport Get Lookup Table
DestCityName Dest Airport, City Name  
DestCountry Destination Airport, Country Get Lookup Table
DestCountryName Destination Airport, Country Name  
DestWac Destination Airport, World Area Code Get Lookup Table
Time Period
Year Year  
Quarter Quarter Get Lookup Table
Month Month Get Lookup Table
Other
DistanceGroup Distance Intervals, every 500 Miles, for Flight Segment Get Lookup Table
Class Service Class Get Lookup Table