Flights

ColumnData TypeData descriptionKeyData SetJoin On
operatorvarchar(255)Operator name
operator_ch_codevarchar(5)Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters.ForeignAirlinesAirline ch-a Code
operator_iatavarchar(2)Airline IATA two-character code
operator_icaovarchar(3)Airline ICAO three-character code
callsign_operatorvarchar(255)Callsign operator name
callsign_ch_codevarchar(5)Callsign operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters.ForeignAirlinesAirline ch-a Code
callsign_iatavarchar(2)Callsign airline IATA two-character code
callsign_icaovarchar(3)Callsign airline ICAO three-character code
wet_lease_customervarchar(255)Wet-lease customer name
wet_lease_cha_codevarchar(5)Wet-lease customer ch-aviation code (assigned by ch-aviation). Same as Operator ch-aviation codes, can be 2, 3, or 5 characters.
wet_lease_customer_iatavarchar(2)Wet-lease customer IATA two-character code
wet_lease_customer_icaovarchar(3)Wet-lease customer ICAO three-character code
aircraft_idint4Unique ch-aviation created aircraft ID, remains stable throughout an aircraft's life (assigned by ch-aviation), the aircraft_id and date_from_full fields are the combined primary key of the Aircraft Histories data setForeign (Combined)Aircraft HistoriesAircraft ID
aircraft_variantvarchar(255)Aircraft Variant designation (i.e. A321-200N)
aircraft_rolevarchar(32)Aircraft's primary role (Passenger, Passenger-Freighter, Cargo, Combi, Quick Change, Ambulance, Hospital, Maritime Patrol, Military, Oil Spill Response, Parachuting, Police, Tanker, Testbed, Water Bomber, VIP)
cnvarchar(16)Construction/Line Number
msnvarchar(16)Manufacturer Serial Number
registrationvarchar(16)Aircraft Registration, blank if unknown or no longer registered
hexcodechar(6)ICAO 24-bit address/Mode-S hexcode
date_from_fulldateFrom date with operator, registration and variant, the aircraft_id and date_from_full fields are the combined primary key of the Aircraft Histories data setForeign (Combined)Aircraft HistoriesDate From Full
datetimestampDate of flight in UTC
flight_idvarchar(255)Spire internal unique flight ID. Random UUIDv4 sequencePrimary
observation_starttimestampMovement observation start time, UTC
observation_endtimestampMovement observation end time, UTC
altitude_startint4Altitude at observation start in feet
altitude_endint4Altitude at observation end in feet
callsignvarchar(255)Flight callsign
originvarchar(255)Origin airport display name (combination of City Name and Airport Name)
origin_cha_codevarchar(6)Origin primary airport code (in order of availability: 1) IATA, 2) ICAO, 3) FAA, 4) Alternative code (if aircraft is inactive)ForeignAirportsAirport ch-a Code
origin_iatavarchar(3)Origin airport IATA code
origin_icaovarchar(6)Origin airport ICAO code
origin_continentvarchar(255)Origin airport continent name
origin_subdivisionvarchar(255)Origin airport state name
origin_subdivision_cha_codechar(2)Origin airport ISO 3166-2 Alpha-2 subdivision code (used for states)ForeignStatesState ISO
origin_metro_groupvarchar(255)Origin airport Metro Group name
origin_metro_group_iatachar(3)Origin airport Metro Group three character IATA codeForeignMetro GroupsMetro_Group
origin_countryvarchar(255)Origin airport country name
origin_country_isochar(2)Origin airport ISO 3166-1 Alpha-2 country codeForeignCountriesCountry ISO
destinationvarchar(255)Destination airport display name (combination of City Name and Airport Name)
destination_cha_codevarchar(6)Destination primary airport code (in order of availability: 1) IATA, 2) ICAO, 3) FAA, 4) Alternative code (if aircraft is inactive)ForeignAirportsAirport ch-a Code
destination_iatavarchar(3)Destination airport IATA code
destination_icaovarchar(6)Destination airport ICAO code
destination_continentvarchar(255)Destination airport continent name
destination_subdivisionvarchar(255)Destination airport state name
destination_subdivision_cha_codechar(2)Destination airport ISO 3166-2 Alpha-2 subdivision code (used for states)ForeignStatesState ISO
destination_metro_groupvarchar(255)Destination airport Metro Group name
destination_metro_group_iatachar(3)Destination airport Metro Group three character IATA codeForeignMetro GroupsMetro_Group
destination_countryvarchar(255)Destination airport country name
destination_country_isochar(2)Destination airport ISO 3166-1 Alpha-2 country codeForeignCountriesCountry ISO
take_offtimestampTake off time, UTC
landingtimestampLanding time, UTC
take_off_latitudevarchar(255)Take off latitude in degrees, between -90 and 90 (both inclusive)
take_off_longitudevarchar(255)Take off longitude in degrees, between -180 (exclusive) and 180 (inclusive)
landing_latitudevarchar(255)Landing latitude in degrees, between -90 and 90 (both inclusive)
landing_longitudevarchar(255)Landing longitude in degrees, between -180 (exclusive) and 180 (inclusive)
start_latitudevarchar(255)Observation start latitude in degrees, between -90 and 90 (both inclusive)
start_longitudevarchar(255)Observation start longitude in degrees, between -180 (exclusive) and 180 (inclusive)
end_latitudevarchar(255)Observation end latitude in degrees, between -90 and 90 (both inclusive)
end_longitudevarchar(255)Observation end longitude in degrees, between -180 (exclusive) and 180 (inclusive)
durationint4Flight duration formatted as hh:mm:ss, difference between landing time and take off time, NULL if one or both are not recorded
regional_partnershipvarchar(255)Regional partnership name under which the flight is operatedForeignRegional SubsidiariesRel Subsidiary
cargo_customervarchar(255)Name of cargo customer for whom the flights is operated
cargo_cust_cha_codevarchar(5)Cargo customer ch-aviation code (assigned by ch-aviation). Can be 2, 3, 4, or 5 characters.ForeignEntitiesEntity ch-a Code
flight_typevarchar(20)Indicator of special flight types (ferry, technical, training)
notesvarchar(255)Additional free text notes related to the flight