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.

We can provide the sample files of any data sets you would like to test. Contact us directly to request your sample file. Data samples are also publicly available here: Console login link: https://ch-aviation.signin.aws.amazon.com/console S3 bucket location on console: https://s3.console.aws.amazon.com/s3/buckets/ch-aviation-demo-data Account ID: ch-aviation Username: DemoData Password: qJ9R*Fz1A1JK Access key ID: AKIAREJC5HDG7OINHRUX Secret access key: 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 More information about AWS S3 can be found here: https://aws.amazon.com/s3/getting-started/

Airports - ch-aviation

Airports

Column	Data Type	Data description	Package required	Key	Data Set	Join On
Airport ID	int(11)	Numeric stable airport ID	Airports	Primary
Airport ch-a Code	varchar(6)	airport ch-aviation code (not a stable ID, IATA code if available, otherwise ICAO, otherwise alternative code)	Airports	Unique
Airport Name	varchar(255)	Airport Name	Airports
Airport Display Name	varchar(255)	Airport Display Name (combination of City Name and Airport Name)	Airports	Unique
City	varchar(255)	City Name	Airports
Airport IATA	char(3)	Airport three character IATA code	Airports
Airport ICAO	char(4)	Airport four character ICAO code	Airports
FAA/Other Code	varchar(6)	Alternative airport code issued by other authorities (i.e. local civil aviation authorities)	Airports
Continent	varchar(255)	Continent name	Airports
Country	varchar(255)	Country name	Airports
Country ISO Code	char(2)	ISO 3166-1 Alpha-2 country code	Airports	Foreign	Countries	Country ISO
Subdivision	varchar(255)	State name	Airports
Subdivision ch-a Code	char(2)	ISO 3166-2 Alpha-2 subdivision code (used for states)	Airports	Foreign	States	State ISO
Metro Group	varchar(255)	Metro Group name	Airports
Metro Group IATA	char(3)	Metro Group three character IATA code	Airports	Foreign	Metro Groups	Metro_Group
Latitude	decimal(10,6)	Latitude	Airports
Longitude	decimal(10,6)	Longitude	Airports
Airport Type	varchar(255)	Airport Type Name	Airports
Airport Type Code	char(1)	Airport Type Code: A (Airport), H (Heliport), S (Sea Plane Base), M (Military Airport), C (Airport no longer in use), F (Future airport (not yet in use))	Airports
Runway In Metres	int(11)	Maximum runway length in metres	Airports
Elevation In Metres	int(11)	Elevation in metres above sea level	Airports
Runway In Feet	int(11)	Maximum runway length in feet	Airports
Elevation In Feet	int(11)	Elevation in feet above sea level	Airports
Comment	varchar(255)	Free text comments	Airports