Skip to content

Registered aircraft · 7,860

Aircraft with this engine 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 engine_model_code IN ('00000')
  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 engine_model_code IN ('00000')
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.

N95KGBilyeu Jeffrey E · Reno, NVBuilt 1983 · S/N 101A0095 N95USCampbell Jerry L · Corpus Christi, TXBuilt 1974 · S/N 695 N960CBBlaser Swisslube Inc · Goshen, NYBuilt 2007 · S/N 101 N961JHGacki William L · Mendota Heights, MNBuilt 1997 · S/N 17.07.018 N962KBBarrett Dennis F · Temecula, CABuilt 2012 · S/N 959 N963CGGillespie Charles P · Superior, COBuilt 2014 · S/N 1C-074 N963TRSouthern California Soaring Academy Inc · Valencia, CABuilt 1999 · S/N 5E198X42 N9641PDe La Tova Jason J · Mojave, CAS/N 18-104 N964CSSmith Craig W · Horton, MIBuilt 1978 · S/N 75 N965GSSwinton Robert A · Queensbury, NYBuilt 1997 · S/N S60A-3235 N965MFUsda Forest Service Fepp · Old Town, MES/N 66-16070 N9668Faber Keenan · Holland, MIBuilt 2022 · S/N 6966 N9678ZFlight Data Inc · Roanoke, TXS/N 154769 N968N968 LLC · Pensacola, FLS/N 1705 N969ETRise James D · Lake Oswego, ORBuilt 2002 · S/N 139 N96CALavoie Michael T · West Ossipee, NHBuilt 2009 · S/N 003 N96CGGlasford John T · Rapid City, SDBuilt 1981 · S/N 30 N96JHAliante LLC · Longmont, COBuilt 1977 · S/N 3050 N96LNSanta Fe Balloons LLC · Hutto, TXBuilt 1996 · S/N 5001 N9700Williams Scott M · Gales Ferry, CTS/N S57A-3100 N9701ZMaslen Holbrook · Caldwell, IDS/N 5114849 N9704Liberti Chris M · Castle Rock, COBuilt 2019 · S/N 468 N970CBBlaser Swisslube Inc · Goshen, NYBuilt 2005 · S/N 101 N970HQRe/Max Marketing Fund LLC · Denver, COBuilt 2026 · S/N 2674 N9713BLapoint Amy L · South Glens Falls, NYBuilt 1997 · S/N 101 N9713NBlaser Swisslube Inc · Goshen, NYBuilt 2002 · S/N 102 N9713TGrant Russell J · Deland, FLS/N S-004 N9714ZMartin Ronald P · Tehachapi, CABuilt 1942 · S/N 40 N971EEEcheverry Gonzalo Jr · Austin, TXBuilt 1977 · S/N B790 N971LBWyoming Balloon Co · Jackson, WYS/N 5489 N971USColumbine Animal Hospital Inc · Littleton, COBuilt 2017 · S/N 1362 N9728ZKnerr Joshua D · Shafter, CABuilt 1962 · S/N 2 N972AFCivil Air Patrol · Maxwell Afb, ALBuilt 1986 · S/N 21320 N972CGFisher Douglas W · Holton, KSBuilt 1972 · S/N 398 N972PTUplifting Adventures LLC · Wylie, TXBuilt 2016 · S/N 6781 N974CQStanfield Mark A · Hood River, ORBuilt 2001 · S/N 43-17 N9754Bank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 271CS N975AFCivil Air Patrol · Maxwell Afb, ALBuilt 1984 · S/N 21237 N9769CRudolf Thomas L · Middletown, OHBuilt 1964 · S/N 12004 N976REKrieg Fred W · Independence, ORBuilt 1976 · S/N S55A-279 N9773Gianforte Joseph D · Canastota, NYBuilt 1971 · S/N 98 N9775Gammons Leslie K · Broken Arrow, OKBuilt 1971 · S/N 106 N979JAAbel Jeffrey J · Fort Worth, TXBuilt 1996 · S/N 6061 N97ASHinckley David D · Belton, TXBuilt 1978 · S/N 027019 N97DGLoeffler Herbert M Jr · Saratoga Springs, NYBuilt 1986 · S/N 108 N97GSWillamette Valley Soaring Club · Cornelius, ORBuilt 1977 · S/N 19140 N97JGHoiness Stuart E · Southern Pines, NCBuilt 1998 · S/N 61 N97KGNasadowski Martin · Portland, ORBuilt 1998 · S/N 13 N97MHRonat Ethan W · Monterey, CABuilt 1995 · S/N 22 N97MTRudloff Uwe K Trustee · Lake Village, INBuilt 1992 · S/N 14-042M