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)

To access the full sample data set on Amazon Web Services manually or programmatically, the S3 bucket URLs are provided here.

To get user name and password for manual access or access key and secret key for programmatic access, contact sales@ch-aviation.com.

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)	Foreign	Aircraft Variants	variant_text
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.