Skip to content

Registered aircraft · 7,857

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.

N3020VDiageo North America Inc · New York, NYS/N 6907 N3021AHardin John M · Terrell, TXBuilt 1998 · S/N 5077 N3021NNinomiya John K · Sedona, AZBuilt 1998 · S/N 5080 N30220Watkins Jon P · Albuquerque, NMBuilt 1999 · S/N 5104 N30228Donahue Mark A · Queensbury, NYBuilt 1998 · S/N 5083 N3022LLavigna William F · Gates Mills, OHBuilt 1998 · S/N 5070 N30237Cooper Gary R · Rio Rancho, NMBuilt 2021 · S/N 6943 N3024RRe/Max Marketing Fund LLC · Denver, COBuilt 2017 · S/N 6824 N3025AGalena On The Fly Inc · Galena, ILBuilt 1999 · S/N 5111 N3025BEscape Adventures Inc · Temecula, CABuilt 1996 · S/N 6041 N3026KClark J Stanley · Pewee Valley, KYBuilt 1999 · S/N 5093 N3026UHeaton Ryan · Arvada, COBuilt 1996 · S/N 6060 N3027U84 Lumber Company · Eighty Four, PABuilt 2020 · S/N 6918 N3028SRegistration Pending · Prairie Grove, ARRegistration pendingBuilt 1998 · S/N 5073 N3028TSpirit Ballooning LLC · Canaan, CTBuilt 1999 · S/N 5098 N302PMDittes Paul R · Ballston Spa, NYBuilt 1985 · S/N 3E62 N302SWinbow Alexander G · Portland, ORBuilt 1977 · S/N 32 N3030RKiehle Erik A · Meridian, MSS/N 6039 N30310Heinrich Cynthia G · Reno, NVBuilt 1996 · S/N 6032 N30356Herbst John H · Lexington, KYBuilt 1996 · S/N 6064 N3038KPfeiffer Neal J · Wichita, KSBuilt 1966 · S/N 6554 N3039UCampbell Brittany Rose · Los Lunas, NMBuilt 1996 · S/N 6065 N303AMMaier Thomas M · Littleton, COBuilt 1999 · S/N 3E486A27 N303AZGoodner Brian C · Brookston, INBuilt 1999 · S/N 3E485 N303BAPost Mills Soaring Club · Lyme, NHBuilt 1996 · S/N 968216 N303BRThrottle Back Inc · Wilmington, DEBuilt 1987 · S/N 3E222 N303CUHarwell James P · Keithville, LAS/N 5355 N303DGSchwab Keith C · South Pasadena, CABuilt 1996 · S/N 3E473 N303HQRe/Max Marketing Fund LLC · Denver, COBuilt 2019 · S/N 6867 N303KKKimble Christopher J · Pine Island, MNBuilt 2001 · S/N 3E490A32 N303MDDemeyer Michael F · Danville, CABuilt 1983 · S/N 3E-4 N303MQWelch Irvin J · Concrete, WABuilt 1977 · S/N 48 N303MRWillis Christopher E · Heber City, UTBuilt 1998 · S/N 3E480A23 N303NCMerrill Kenneth R · Cheney, WABuilt 2002 · S/N 73 N303PSStumpf Paul S · Andover, VTBuilt 2021 · S/N 2021-54C-1 N303QQGourley Brent H · Dothan, ALBuilt 1979 · S/N 177 N303SSLeonard Steven E · Wichita, KSBuilt 1978 · S/N 92 N303TMNorth Florida Soaring Society Inc · Jacksonville, FLBuilt 1977 · S/N 273 N303VPAaron Charles E · Portland, ORBuilt 1977 · S/N 50 N3049WWyoming Balloon Co · Jackson, WYBuilt 2016 · S/N 5607 N3049YPhilkill Steven · Milford, NJBuilt 2005 · S/N 154 N304ABWallis Ronald M · Lago Vista, TXBuilt 2008 · S/N 004-S N304AMWillamette Valley Soaring Club Inc · Cornelius, ORS/N 22 N304AZVihlen Ryan S · Smyrna, GABuilt 1999 · S/N 14 N304BAKonle Hans P · Seminole, FLS/N 960410 N304BBFirewalker Balloon Adventures LLC · Battle Creek, MIBuilt 1997 · S/N F71012 N304BLRinell Eric S · San Luis Obispo, CABuilt 2000 · S/N 17 N304BUChow Timothy · Norwich, VTBuilt 2001 · S/N 41-17 N304CBMurray Lee J · Appleton, WIBuilt 2004 · S/N 68-C N304CLMurphy John R · Rapid City, SDBuilt 2002 · S/N 50-17