Do you also provide an API?

ch-aviation can provide the data feeds to you directly via file transfer protocol (FTP), safe file transfer protocol (SFTP) or a shared Amazon Web Services (AWS) S3 bucket.

Which delivery formats you support?

The data is provided as Comma-separated values (.csv) flat files. Optionally we can provide them as Microsoft Excel (.xlsx) or XML (.xml)

How often does data get updated?

The ch-aviation database is updated in batches to ensure all data flows through ch-aviation’s semi-automated quality assurance process built to maximise data integrity. As a result, the data set remains relatively static in the ch-aviation production database, for most data sets for a week or month at a time. Therefore, the most efficient integration option is the transfer of flat files provided for integration into your own applications in various formats.

Aircraft Utilisation – Daily (ADS-B based) - ch-aviation

Aircraft Utilisation – Daily (ADS-B based)

Column	Data Type	Data description	Key	Data Set	Join On
Natural ID	varchar(30)	Natural aircraft ID (combination of the ch-aviation production line code and either the line/construction or manufacturer serial number, changes for aircraft not yet delivered where l/n, c/n or msn are not yet known (assigned by ch-aviation)	Foreign	Aircraft	Natural ID
Aircraft ID	int(11)	Unique ch-aviation created aircraft ID, remains stable throughout an aircraft’s life (assigned by ch-aviation)	Foreign	Aircraft	Aircraft ID
Operator	varchar(255)	Operator name
Opr. ch-a Code	varchar(5)	Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters.	Foreign	Operators	Operator ch-a Code
Variant	varchar(255)	Aircraft Variant designation (i.e. A321-200N)
CN	varchar(16)	Construction/Line Number
MSN	varchar(16)	Manufacturer Serial Number
Registration	varchar(16)	Aircraft Registration, blank if unknown or no longer registered
Date	date	date (YYYY-MM-DD)
cycles	int(8)	number of daily cycles
hours	decimal(23,2)	number of daily hours (hhh.hh)
avg stage length	char(5)	average daily stage length in hours and minutes (hh:mm)
utilisation_data_type	varchar(255)	type of utilisation data
As of	date	As of date (date when utilisation data was last provided) (YYYY-MM-DD)
Source	varchar(255)	Source of utilisation data
data quality indicator	varchar(16)	An aircraft is whitelisted for an operator/MSN combination if it meets one of the following: Utilization Match: Spire ADS-B based cycles closely align with OEM data (within ±1–2 cycles or ±10%, depending on sample size) in the past two years. Flight Path Continuity: At least 95% of previous destinations match the next origin, with 10+ flights tracked in the past two years. Otherwise, it is blacklisted
data quality index	decimal(3,2)	A score from 0 to 1 indicating completeness of flight tracking for the day: 0 = takeoff and/or landing missing; 1 = both takeoff and landing are present; values in between reflect partial data completeness.