U.S. Domestic

FieldTypeDescriptionExample
YYMMVARCHAR(4)Travel year and month2101
ORGVARCHAR(3)IATA airport code of the trip originJFK
DSTVARCHAR(3)IATA airport code of the trip destinationSLC
STATION2VARCHAR(3)IATA airport code of the first connecting point, if any. Otherwise, it’s the same as the DST field.SFO
STATION3VARCHAR(3)IATA airport code of the second connecting point, if any. Empty if there is no connection point or the same as the DST field if there is only one connection point.SLC
STATION4VARCHAR(3)Empty if there are one or fewer connection points. Otherwise, it’s the same as the DST field.
DOM_MKT_ALVARCHAR(3)Dominant marketing airline codeAA
MKT_AL1VARCHAR(3)IATA code of the marketing airline on the first segmentAA
MKT_AL2VARCHAR(3)IATA code of the marketing airline on the second segment, if anyAA
MKT_AL3VARCHAR(3)IATA code of the marketing airline on the third segment, if any
DOM_OPT_ALVARCHAR(3)Dominant operating airline codeAA
OPT_AL1VARCHAR(3)IATA code of the operating airline on the first segmentAA
OPT_AL2VARCHAR(3)IATA code of the operating airline on the second segment, if anyOO
OPT_AL3VARCHAR(3)IATA code of the operating airline on the third segment, if any
DOM_PARENT_ALVARCHAR(3)Parent carrier of the dominant operating carrierAA
PARENT_AL1VARCHAR(3)Parent carrier of the operating airline on the first segmentAA
PARENT_AL2VARCHAR(3)Parent carrier of the operating airline on the second segment, if anyAS
PARENT_AL3VARCHAR(3)Parent carrier of the operating airline on the third segment, if any
RPT_CARRIERVARCHAR(3)IATA code of the reported carrier in the DB1B raw data, if appliedAA
PAXDOUBLENumber of passengers30
PAX_PER_DAYDOUBLENumber of average passengers per day0.97
PAX_PER_DAY_RAWDOUBLENumber of passengers per day in the raw DB1B data0.91
FAREDOUBLENet fare in USD to airlines228.28
GROSS_FAREDOUBLEGross fare/Payment in USD, including taxes and fees251.11
LEGSNUMBERNumber of flight legs in the itinerary2
OWACNUMBERWAC code of the origin22
DWACNUMBERWAC code of the destination87
OD_MILESDOUBLEMiles between trip origin and trip destination1984
CIRCUITYDOUBLECircuity of the trip (total segment miles / direct OD miles)1.605
DIVARCHAR(1)Domestic or internationalD
POOVARCHAR(3)IATA airport code of the point of originJFK
SOURCEVARCHAR(8)Source of the dataDB1B_raw
LOAD_DATEDATEDate when the data is produced2021-07-10
TYPEVARCHAR(10)Data status: Interim, Near-Final, or FinalFinal

Global Market Size