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.

Capacities – Scheduled

Column	Data Type	Data description	Package	Key	Data Set	Join On
Operator Name	varchar(255)	Operator name	Commercial Aviation Operator Capacity Data
Origin	varchar(255)	Origin airport Display Name (combination of City Name and Origin airport Name)	Commercial Aviation Operator Capacity Data
Origin IATA Code	char(3)	Origin airport three character IATA code	Commercial Aviation Operator Capacity Data
Origin Airport ID	int(11)	Numeric stable airport ID	Commercial Aviation Operator Capacity Data	Foreign	Airports	Airport ID
Origin Continent	varchar(6)	Origin airport ch-aviation code (not a stable ID, IATA code if available, otherwise ICAO, otherwise alternative code)	Commercial Aviation Operator Capacity Data
Origin Subdivision	varchar(255)	Origin State name	Commercial Aviation Operator Capacity Data
Origin Subdivision ISO Code	char(2)	Origin ISO 3166-2 Alpha-2 subdivision code (used for states)	Commercial Aviation Operator Capacity Data	Foreign	States	State ISO
Origin Metro Group	varchar(255)	Origin Metro Group name	Commercial Aviation Operator Capacity Data
Origin Metro Group Code	char(3)	Origin Metro Group three character IATA code	Commercial Aviation Operator Capacity Data	Foreign	Metro Groups	Metro_Group
Origin Country	varchar(255)	Origin Country name	Commercial Aviation Operator Capacity Data
Origin Country ISO	char(2)	Origin ISO 3166-1 Alpha-2 country code	Commercial Aviation Operator Capacity Data	Foreign	Countries	Country ISO
Destination	varchar(255)	Destination airport Display Name (combination of City Name and Destination airport Name)	Commercial Aviation Operator Capacity Data
Destination IATA Code	char(3)	Destination airport three character IATA code	Commercial Aviation Operator Capacity Data
Destination Airport ID	char(4)	Destination airport four character ICAO code	Commercial Aviation Operator Capacity Data	Foreign	Airports	Airport ID
Destination Continent	varchar(6)	Destination airport ch-aviation code (not a stable ID, IATA code if available, otherwise ICAO, otherwise alternative code)	Commercial Aviation Operator Capacity Data
Destination Subdivision	varchar(255)	Destination State name	Commercial Aviation Operator Capacity Data
Destination Subdivision ISO Code	char(2)	Destination ISO 3166-2 Alpha-2 subdivision code (used for states)	Commercial Aviation Operator Capacity Data	Foreign	States	State ISO
Destination Metro Group	varchar(255)	Destination Metro Group name	Commercial Aviation Operator Capacity Data
Destination Metro Group Code	char(3)	Destination Metro Group three character IATA code	Commercial Aviation Operator Capacity Data	Foreign	Metro Groups	Metro_Group
Destination Country	varchar(255)	Destination Country name	Commercial Aviation Operator Capacity Data
Destination Country ISO	char(2)	Destination ISO 3166-1 Alpha-2 country code	Commercial Aviation Operator Capacity Data	Foreign	Countries	Country ISO
Capacity	int(11)	Sum of total seats for the route and week	Commercial Aviation Operator Capacity Data