Skip to content
  • ch-aviation Data Feeds
    • Data Feeds
    • Preferred and Supported Data formats
    • Data Delivery Options
    • Data Dictionary
  • Blog
Contact Us
  • ch-aviation Data Feeds
    • Data Feeds
    • Preferred and Supported Data formats
    • Data Delivery Options
    • Data Dictionary
  • Blog
Last Aircraft LocationMarija Verovic2025-07-07T10:30:00+00:00
  • Data Feeds
    • Aircraft Data Feeds
    • Operator Data Feeds
    • Operator Commercial IT Data Feeds
    • Airport Data Feeds
  • Data Dictionary
    • Accidents and Incidents
    • ACMI Tracking
    • Aircraft
    • Aircraft Codes
    • Aircraft Data
    • Aircraft Histories
    • Aircraft Histories Multiple Operators
    • Aircraft Multiple Operators
    • Aircraft Orders
    • Aircraft Owner Contacts
    • Aircraft Utilisation – Daily (ADS-B based)
    • Aircraft Utilisation – Monthly (OEM based)
    • Aircraft Utilisation – Monthly (OEM/ADS-B based)
    • Aircraft Variants
    • Airframe MRO Events
    • Airframe MRO Providers and Customers
    • Airports
    • Alliances
    • Capacities – Scheduled
    • Countries
    • Currencies
    • Entities
    • Exchange Rates
    • Fleets Summary
    • Flights
    • Flight Number Decoding
    • Flight Number Range Decoding
    • Frequencies – Flown (ADS-B based)
    • Last Aircraft Location
    • Metro Groups
    • Operators
    • Operator Bases
    • Operator Contacts
    • Operator Financial Figures
    • Operator Passenger Figures
    • PSS
    • Regional Carriers
    • Regional Subsidiaries
    • Spire-ch-aviation Mapping
    • Start-Ups
    • States
  • Preferred and Supported Data formats
  • Data Delivery Options

Last Aircraft Location

ColumnData TypeData descriptionKeyData SetJoin On
aircraft idint(11)Unique ch-aviation created aircraft ID, remains stable throughout an aircraft's life (assigned by ch-aviation)ForeignAircraftAircraft ID
operatorvarchar(255)Operator name
opr. ch-a 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
registrationvarchar(16)Aircraft registration
aircraft variantvarchar(255)Aircraft Variant designation (i.e. A321-200N)ForeignAircraft Variantsvariant_text
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)
last flight datedateThe date when the aircraft arrived at current location. In UTC
locationvarchar(255)Airport Display Name (combination of City Name and Airport Name)
location ch-a 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
location country iso codechar(2)ISO 3166-1 Alpha-2 country codeForeignCountriesCountry ISO
location countryvarchar(255)Country name
Learn more about ch-aviation

@ Copyright ch-aviation, 2025

All rights reserved

Page load link
Go to Top