Skip to content

Registered aircraft · 27

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 ('5470205', '5460185')
  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 ('5470205', '5460185')
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.

N122WANagle Derek T · Ada, MIS/N 11075C N123SPMain Wesley Jake · Kenai, AKBuilt 1991 · S/N 11083C N148DPHenke Kristen C · Bettendorf, IAS/N 11015C N280SASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1990 · S/N 11070C N30592Kussmaul Richard · Clinton, MIBuilt 1994 · S/N 11093C N3171HKh Air LLC · New London, MNBuilt 2018 · S/N 22045C N561TPKerner Christine A · Yelm, WABuilt 1988 · S/N 11041C N5653RSchoenau Michael · Tulare, CAS/N 11001C N56557Mannering Robert D · Warrensburg, MOS/N 11002C N56587Bumpus James M · Lucas, OHS/N 11004C N5659HVarnold Paul M · Pilesgrove, NJBuilt 1985 · S/N 11003C N5661YBaumann Jon G · Midland, TXS/N 11010C N5662ZEdwards Ryan D · Columbus, GABuilt 1985 · S/N 11018C N5663NMeranda Andrew J · Morganton, NCBuilt 1986 · S/N 11021C N5669DMurphey Julian R · Knoxville, TNBuilt 1987 · S/N 11029C N5669NLynn Martin K · Brownsboro, ALBuilt 1987 · S/N 11032C N6114YFlies Warren E · Mesa, AZBuilt 1988 · S/N 11043C N6129CSumner Scott B · Catoosa, OKBuilt 1988 · S/N 11057C N61330Holman Ricardo Earl · Creswell, ORBuilt 1989 · S/N 11065C N6133AReinders Monte M · Port Townsend, WABuilt 1990 · S/N 14001C N773MCAlexy Kenneth J · Washington, MIS/N 11019C N830LMKq Aviation LLC · Old Town, FLBuilt 1988 · S/N 11048C N9076HBeachy Jonas D · Whittington, ILBuilt 1989 · S/N 11040C N9210MHahn David · Port Lavaca, TXBuilt 1991 · S/N 11067C N9227WMasterman Robert David · Chugiak, AKS/N 11097C N9230TProctor Richard P · Statesboro, GAS/N 11095C N988MSLong Mark A · Stanton, MIBuilt 1988 · S/N 11058C

Back to Maule MX-7-180