Bureau of Transportation Statistics
leftDeco
spacer
spacer
spacer
spacer
spacer spacer spacer
spacer
transtats logo
 
Advanced Search
Resources
Data Tools
: T-100 Market (All Carriers)
Databases     Data Tables   Table Contents
Download Instructions  
Latest Available Data: July 2009
Select all fields   % Missing in table Documentation Terms
Field Name  Description  Support Table 
Summaries
PassengersOn-Flight Market Passengers Enplaned 
FreightOn-Flight Market Freight Enplaned (pounds) 
MailOn-Flight Market Mail Enplaned (pounds) 
DistanceDistance between airports (miles) 
Carrier
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.Get Lookup Table
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.Get Lookup Table
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.Get Lookup Table
CarrierRegionCarrier's Operation Region. Carriers Report Data by Operation RegionGet Lookup Table
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.Get Lookup Table
CarrierNameCarrier Name 
CarrierGroupCarrier Group Code. Used in Legacy AnalysisGet Lookup Table
CarrierGroupNewCarrier Group NewGet Lookup Table
Origin
OriginOrigin Airport CodeGet Lookup Table
OriginCityNameOrigin Airport, City Name 
OriginCityNumOrigin Airport, City Code 
OriginStateOrigin Airport, StateGet Lookup Table
OriginStateFipsOrigin Airport, State FIPS Code (U.S. Federal Information Processing Standard Codes)Get Lookup Table
OriginStateNameOrigin Airport, State Name 
OriginCountryOrigin Airport, CountryGet Lookup Table
OriginCountryNameOrigin Airport, Country Name 
OriginWacOrigin Airport, World Area CodeGet Lookup Table
Destination
DestDestination Airport CodeGet Lookup Table
DestCityNameDest Airport, City Name 
DestCityNumDestination Airport, City Code 
DestStateDestination Airport, StateGet Lookup Table
DestStateFipsDestination Airport, State FIPS Code (U.S. Federal Information Processing Standard Codes)Get Lookup Table
DestStateNameDestination Airport, State Name 
DestCountryDestination Airport, CountryGet Lookup Table
DestCountryNameDestination Airport, Country Name 
DestWacDestination Airport, World Area CodeGet Lookup Table
Time Period
YearYear 
QuarterQuarter (1-4)Get Lookup Table
MonthMonthGet Lookup Table
Other
DistanceGroupDistance Intervals, every 500 Miles, for Flight SegmentGet Lookup Table
ClassService ClassGet Lookup Table
DataSourceSource of Data (D=Domestic ,I=International)Get Lookup Table
spacer
spacer spacer spacer

spacer