ACMI Tracking

ColumnData TypeData descriptionKeyData SetJoin On
flight_idvarchar(255)Spire internal unique flight ID. Random UUIDv4 sequencePrimary
datetimestampDate of flight in UTC
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
takeoff_timetimestampTake off time, UTC
landing_timetimestampLanding time, UTC
origin_airport_icaovarchar(6)Origin airport ICAO codeForeignAirportsAirport ICAO
origin_airport_iatavarchar(3)Origin airport IATA codeForeignAirportsAirport IATA
destination_airport_icaovarchar(6)Destination airport ICAO codeForeignAirportsAirport ICAO
destination_airport_iatavarchar(3)Destination airport IATA codeForeignAirportsAirport IATA
speed_startint4Speed at observation start in km/h
speed_endint4Speed at observation end in km/h
durationint4Flight duration formatted as hh:mm:ss, difference between landing time and take off time, NULL if one or both are not recorded
max_timetimestampMaximum of all time stamps for a flight, UTC
flight_typevarchar(20)Indicator of special flight types (ferry, technical, training)
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
callsign_icaovarchar(3)Callsign Operator ICAO three-character code
callsign_flight_numbervarchar(4)Callsign Operator flight number
callsign_suffixchar(1)Callsign Operator flight number suffix
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.ForeignOperatorsOperator ch-a Code
wet_lease_customer_namevarchar(255)Wet-lease customer name
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 setForeignAircraftAircraft ID
cnvarchar(16)Construction/Line Number
msnvarchar(16)Manufacturer Serial Number
aircraft_variantvarchar(255)Aircraft Variant designation (i.e. A321-200N)
ch_airline_codevarchar(5)Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters.ForeignOperatorsOperator ch-a Code
airline_namevarchar(255)Operator name
icaovarchar(3)Operator ICAO three-character code
regvarchar(16)Aircraft Registration, blank if unknown or no longer registered
hexcodechar(6)ICAO 24-bit address/Mode-S hexcode
seats_ysmallint(6)Seats in Economy
seats_ypsmallint(6)Seats in Economy Plus/Comfort, ch-aviation applies the following methodology for Economy Plus/Comfort vs. Premium Economy aircraft seat configurations/capacity calculations to ensure comparability across all carriers worldwide: ch-aviation only considers cabins to be Premium Economy if the maximum number of seats per row (Max Abreast) is at least 2 seats less than the maximum number of seats that could physically be fitted in Economy Class for the aircraft type (i.e. 10 for a B777) no matter what the actual maximum abreast configuration on that aircraft is.
seats_wsmallint(6)Seats in Premium Economy, ch-aviation applies the following methodology for Economy Plus/Comfort vs. Premium Economy aircraft seat configurations/capacity calculations to ensure comparability across all carriers worldwide: ch-aviation only considers cabins to be Premium Economy if the maximum number of seats per row (Max Abreast) is at least 2 seats less than the maximum number of seats that could physically be fitted in Economy Class for the aircraft type (i.e. 10 for a B777) no matter what the actual maximum abreast configuration on that aircraft is.
seats_csmallint(6)Seats in Business, ch-aviation applies the following methodology for Business vs. First aircraft seat configurations/capacity calculations to ensure comparability across all carriers worldwide: ch-aviation only considers narrowbody cabins to be First Class if the maximum number of seats per row (Max Abreast) is 2 and widebody cabins to be First Class if the maximum number of seats across per row is 4 (unless there is a Business and First Class cabin installed on the aircraft and the First Class cabin has more than 4 seats across per row in these exceptional cases).
seats_fsmallint(6)Seats in First, ch-aviation applies the following methodology for Business vs. First aircraft seat configurations/capacity calculations to ensure comparability across all carriers worldwide: ch-aviation only considers narrowbody cabins to be First Class if the maximum number of seats per row (Max Abreast) is 2 and widebody cabins to be First Class if the maximum number of seats across per row is 4 (unless there is a Business and First Class cabin installed on the aircraft and the First Class cabin has more than 4 seats across per row in these exceptional cases).
aircraft_rolechar(3)Aircraft's primary role (PAX = Passenger, CAR = Cargo, QUI = Quick Change)