Skip to content

Registered aircraft · 12

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('5460108')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('5460108')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N4604TWeitemier Stanley G · Wadena, MNBuilt 1965 · S/N 1017 N4607TPbk Aviation LLC · Jefferson, GABuilt 1965 · S/N 1020 N4609TLamoureux Nicholas J · Moab, UTBuilt 1965 · S/N 1024 N4613TSullivan William R II · Sierra Vista, AZBuilt 1965 · S/N 1028 N4621TIrby Donald K · Cushing, TXBuilt 1965 · S/N 1033 N4624TEisel Adam A · Copenhagen, NYBuilt 1965 · S/N 1026 N4740TGerdes Douglas R · Macon, GAS/N 1004 N4743TWeaver Matthew B · Kasilof, AKBuilt 1964 · S/N 1008 N4744TKolp Mark H · Andrews, TXBuilt 1964 · S/N 1010 N4745TLee Andrew L · Anchorage, AKBuilt 1965 · S/N 1015 N7602AAlbers Julie H · Burlington Flats, NYS/N 1023 N9808MGerling Matthew Karl · Eagle River, AKS/N 1041

Back to Maule M-4-210