Skip to content

Registered aircraft · 31

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 ('5470203')
  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 ('5470203')
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.

N10034Whyte Henry T Jr · West Ossipee, NHBuilt 1996 · S/N 19045C N10240Geiger Richard E · Cut Bank, MTBuilt 1996 · S/N 19046C N108HGKillam Galen Mark · Wautoma, WIBuilt 1994 · S/N 19015C N123VAKarinen Joel J · Anchorage, AKS/N 19041C N141DFNaumann Reuben D · Blackwell, MOS/N 19011C N1895KMcroberts Josiah R · Enterprise, FLS/N 19035C N200CWSkylake Adventures LLC · Geneva, OHBuilt 1994 · S/N 19017C N3033FConn Charles Phillip · Eustis, FLBuilt 1993 · S/N 19014C N3034VWdt LLC · Otis, ORBuilt 1994 · S/N 19023C N3076QLong Eric S · Assumption, ILBuilt 1994 · S/N 19025C N3077SIndustrial Fluid Solutions Inc · Hamburg, ARS/N 19022C N3113AN Maple LLC · Kalispell, MTBuilt 1994 · S/N 19021C N3134WDans Flying Service Inc · Crookston, MNS/N 19027C N31370Kolbaba David C · Carpentersville, ILS/N 19033C N3162QClevenger Matthew T · Williamsburg, VABuilt 1995 · S/N 19038C N3176UWilburn Michael R · Wagoner, OKS/N 19039C N31868Yarger Dylan C · Anchorage, AKBuilt 1995 · S/N 19040C N319ECRansom Robert W · Moorestown, NJBuilt 1994 · S/N 19032C N35TXBauries Brian W · Abilene, TXBuilt 1994 · S/N 19020C N41510Clemente Motor Inc · Wilmington, DEBuilt 1999 · S/N 34001C N6287PRegistered aircraftN-number assigned, not yet registeredS/N 19018C N760JMTibbetts Harrison J · Santa Rosa, CAS/N 19007C N9232GHarold H Bruner · Pinehurst, IDBuilt 1992 · S/N 19001C N9232RRogers Ricky R · Saint Francis, KSS/N 19003C N9232TSannella Joseph J · Missoula, MTS/N 19002C N92362Yeakley Gary G · Ontario, CABuilt 1993 · S/N 19006C N9236YSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 19008C N9238NBloomberg David C · Northampton, MABuilt 1993 · S/N 19012C N94KWHine Garrett Christopher · Panama City Beach, FLBuilt 1994 · S/N 19026C N94LBWhetzel Russell R · Milford, NJBuilt 1994 · S/N 19029C N999MEWindham Jack B · Elba, ALS/N 19042C

Back to Maule MX-7-160