Skip to content

Registered aircraft · 23

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

N1042Estell William S · Wilmington, OHBuilt 1999 · S/N 042 N116RRGross Gary O · Beaverton, ORBuilt 1995 · S/N 016 N126LJHudson Peter O · Ridgecrest, CABuilt 1999 · S/N 046 N126THPark Forest South Aviation Group · Mount Prospect, ILS/N 014 N12GVJorgensen David · Laconia, NHBuilt 1995 · S/N 17 N139TRHuntsville Soaring Association · Brownsboro, ALBuilt 1999 · S/N 39 N1809Barrett Bruce S · Sebastian, FLBuilt 1999 · S/N 048 N213JNemake Jason C · Victorville, CABuilt 1998 · S/N 037 N2255FLoensloe Aviation Inc · Evans, COBuilt 1995 · S/N 12 N226CCCollins Dennis L · Richland, WABuilt 1996 · S/N 20 N24VFEly Osvaldo Bins · Cedar Park, TXBuilt 1996 · S/N 024 N287ESteinkamp Thomas F · Brentwood, TNBuilt 1997 · S/N 028 N292DHHillary Dennis S · Machesney Park, ILBuilt 1999 · S/N 40 N29HSCocatre-Zilgien Jan H · Urbana, ILBuilt 1996 · S/N 022 N3021Lee Gary O · Post Falls, IDS/N 023 N435ACLeonard Steven E · Wichita, KSBuilt 1998 · S/N 035 N545ACConner Walter L · Los Lunas, NMBuilt 1999 · S/N 045 N619KMSpinetta Lawrence J · Austin, TXS/N 019 N68PRDyer Robert A · Papillion, NEBuilt 1999 · S/N 044 N749RDavids Daniel D · Woodinville, WAS/N 043 N797ESpinetta Lawrence J · Austin, TXBuilt 1995 · S/N 009 N80750Smith John A · La Mirada, CAS/N 034 N82DDFun Country Soaring · Valley City, OHBuilt 1999 · S/N 38

Back to AS+ AC 4