Airports, Airlines & Flight Routes Scraper

The complete open aviation reference dataset in one Actor — ~85,000 airports, ~6,000 airlines and ~67,000 flight routes with IATA/ICAO codes, coordinates, elevation and timezones. No API key, no login, no proxy.

Every travel product eventually needs the same boring-but-critical lookup table: what is the IATA code of that airport, where exactly is it, which timezone is it in, who flies there and from where. Commercial aviation APIs charge per request for this static data. This Actor gives you the whole thing as a clean, structured dataset you can export to JSON, CSV or Excel in a single run.

What you get

Mode	Records	Source
airports	~85,000 airports, heliports, seaplane bases and closed fields	OurAirports, enriched with OpenFlights city + timezone
airlines	~6,000 carriers with IATA/ICAO codes and radio callsigns	OpenFlights
routes	~67,000 airline route pairs with equipment types	OpenFlights

Features

• Three datasets, one Actor — switch with a single mode input.
• IATA join enrichment — airports carry OurAirports geodata and the OpenFlights city, UTC offset, IANA timezone name and DST rule, joined on the IATA code.
• Real filters — by country (DE, US, FR…), airport type (large_airport, heliport…) or a list of IATA codes.
• Streaming — multi-MB source files are parsed row by row and the run stops the moment maxItems is reached, so a 100-row test run finishes in seconds.
• Clean nulls — every empty upstream cell becomes null. Missing coordinates are never silently turned into 0.0 (Null Island), and the OpenFlights \N NULL token never leaks into your data.
• No credentials — both sources are public files. Nothing to sign up for, no proxy needed.

Input

Field	Type	Default	Description
mode	select	airports	airports, airlines or routes
countryFilter	string	–	ISO 2-letter country code, e.g. DE. Ignored in routes mode
airportTypeFilter	string	–	large_airport, medium_airport, small_airport, heliport, seaplane_base, closed
iataFilter	array	–	Keep only these codes, e.g. ["FRA","JFK"]
activeOnly	boolean	false	Airlines mode: skip defunct carriers
maxItems	integer	1000	Hard cap, max 50000

{
  "mode": "airports",
  "countryFilter": "DE",
  "airportTypeFilter": "large_airport",
  "maxItems": 500
}

Output

Airport record:

{
  "type": "airport",
  "ident": "EDDF",
  "airport_type": "large_airport",
  "name": "Frankfurt Airport",
  "iata_code": "FRA",
  "icao_code": "EDDF",
  "gps_code": "EDDF",
  "local_code": null,
  "latitude": 50.033333,
  "longitude": 8.570556,
  "elevation_ft": 364,
  "continent": "EU",
  "iso_country": "DE",
  "iso_region": "DE-HE",
  "municipality": "Frankfurt am Main",
  "city": "Frankfurt",
  "timezone_offset": 1.0,
  "timezone_name": "Europe/Berlin",
  "dst": "E",
  "has_scheduled_service": true,
  "home_link": "https://www.frankfurt-airport.com",
  "wikipedia_link": "https://en.wikipedia.org/wiki/Frankfurt_Airport",
  "keywords": ["Frankfurt", "Rhein-Main"],
  "source": "ourairports+openflights",
  "scraped_at": "2026-07-28T18:07:07Z"
}

Airline record: airline_id, name, alias, iata, icao, callsign, country, is_active. Route record: airline_iata, airline_id, source_airport, source_airport_id, dest_airport, dest_airport_id, is_codeshare, stops, equipment.

Use cases

• Travel apps — power airport autocomplete, code-to-name lookups and map pins without paying per query.
• Route planning — build a network graph of who flies where, find connections and hub structures from the 67k route pairs.
• Logistics & freight — resolve airport codes to coordinates and countries for shipment tracking and ETA models.
• Aviation datasets — a clean base table to join with live flight data, on-time statistics or emissions models.
• Data enrichment — turn a column of IATA codes in your CRM or booking system into full geodata.

Pricing

Roughly $0.5 per 1,000 items. The whole 85k-airport dataset costs a few dollars to pull once; most users run it once a month and cache the result.

Data sources & licence

Both upstream datasets are open:

• OurAirports — released into the public domain by its contributors.
• OpenFlights — the airport, airline and route databases are made available under the Open Database License (ODbL); attribution to OpenFlights is required when you redistribute the data.

This Actor only downloads and reshapes those public files. Keep the attribution when you republish.

Related Actors

• ADS-B Flights Scraper — live aircraft positions from the ADS-B network
• Flight Status Scraper — departures, arrivals and delays
• Public Transit Scraper — GTFS stops, lines and schedules
• Country Profiles Scraper — country codes, currencies and demographics

FAQ

Do I need an API key? No. Both sources are public files.

How fresh is the data? OurAirports is community-maintained and updated daily; OpenFlights routes are a 2014 snapshot and are best treated as a structural network, not a live timetable.

Why is latitude sometimes null? Because the upstream row has no coordinate. Returning null instead of 0.0 keeps bad points off your map.

Can I get all 85k airports? Yes — set maxItems to 50000 and run twice with different filters, or filter by continent/country.