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.

States - ch-aviation

States

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	Package required	Key	Data Set	Join On
ID	int(11)	Unique ch-aviation created state ID	Airports	Primary
Country ISO	char(2)	ISO 3166-1 Alpha-2 country code	Airports	Unique/Foreign	Countries	Country ISO
Country Name	varchar(255)	Country name	Airports
State ISO	char(2)	ISO 3166-2 Alpha-2 subdivision code (used for states)	Airports	Unique
State Name	varchar(255)	State name	Airports