Skip to content

Registered aircraft · 7,853

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.

N19BSHigher Reach LLC · Meridian, IDBuilt 2015 · S/N MAB 2015150 N19DTAgnew Alfred P · West Palm Beach, FLBuilt 1978 · S/N 19193 N19EEPinky Swear LLC · Kalispell, MTBuilt 1989 · S/N 19 N19EFPalmer Mark F · Greenwood Village, COBuilt 1985 · S/N 3E64 N19ELEdwards Charles R · Fort Myers, FLBuilt 2007 · S/N 357 N19FZTagliani James M · Dewey, AZBuilt 1976 · S/N 19020 N19HGSoaring Science Inc · Wilmington, DES/N 19255 N19JDCline Jo Ann · Greensboro, NCBuilt 1975 · S/N 709 N19JEKozlik Wiktor · Ramsey, NJBuilt 1978 · S/N 19214 N19JSCowie Leland K · Jonesburg, MOBuilt 1959 · S/N XN252 N19KAPfeiffer Neal J · Wichita, KSS/N 38 N19KLRuskauff David J · Geneseo, NYS/N 19058 N19LKCanty Jeremiah D · Burke, VABuilt 1981 · S/N 19353 N19MLEyler Stuart L · Oceanside, CABuilt 1982 · S/N 19373 N19MROpitz Martin H · Seymour, CTBuilt 1978 · S/N 19191 N19PLGarbacz Christina B · Chicago, ILBuilt 1977 · S/N 19138 N19RTEagleville Soaring Inc · Eagleville, TNBuilt 1985 · S/N 23022 N19SPNew York State Police · Albany, NYS/N 64-13666 N19TGMckenzie Dawn R · Birmingham, MIBuilt 1998 · S/N 001 N1BTCarneal Jeffrey T · Nashville, TNBuilt 1978 · S/N 20072 N1LGEnglish Aero G · Amory, MSS/N 4-139 N1PMFlying L Aircraft Inc · Fort Denaud, FLBuilt 1992 · S/N P-06 N1UDSpontak James S · Etters, PABuilt 1970 · S/N 34 N2000DMcallister Samuel M · Grand Blanc, MIBuilt 1977 · S/N 84 N2001EZamora Loretta · Albuquerque, NMBuilt 2007 · S/N F8B-2094 N2002David Lee Bradley Productions Inc · Temecula, CABuilt 2021 · S/N 250/109 N2002HSusquehanna Valley Balloon Co · Lititz, PABuilt 1987 · S/N 5322 N20035Sky Adventures Inc · Oxford, MIBuilt 2005 · S/N F9B-2014 N2003HAlbin David H · Rio Rancho, NMBuilt 2000 · S/N 135 N2004CNutting Rob H · Ackworth, IABuilt 2000 · S/N 136 N2004JKelly Robert M · Albuquerque, NMS/N 6510 N2006YHastie Todd B · Fleming Island, FLBuilt 2000 · S/N 134 N2007FKirby Adam R · Scotts, MIBuilt 1996 · S/N F7-890 N2007SBassett William C · Sultan, WAS/N 436 N20081Hartson Jason R · Pella, IABuilt 2001 · S/N 139 N20086Funkhouser Daryl · Toms Brook, VAS/N 416 N2008NNollen Ronald Cjr · Hartland, WIBuilt 2001 · S/N 138 N2009JSmith Kathleen G · Albuquerque, NMBuilt 2008 · S/N 6514 N200DGVan Noy Terry W · Henderson, NVBuilt 1977 · S/N 2-13 N200DXOpitz Michael R · Freehold, NYBuilt 1999 · S/N 50 N200HBaker Donald W · China Spring, TXBuilt 1964 · S/N 52 N200PAMiss Bell Foundation Inc · Meridian, IDBuilt 1987 · S/N XP-3001 N200PEMason Jasper · Houston, TXBuilt 1978 · S/N 2-3 N200TVPotts Camilla N · Palmer, AKBuilt 1999 · S/N 5090 N200UTBroker William · Wylie, TXBuilt 1998 · S/N 5085 N200UYAppleby Peter B · Richmond, VABuilt 1979 · S/N 2-69 N200WFReid Robert W IV · Independence, ORBuilt 1960 · S/N 97/60 N200XCTvpx Ars Inc Trustee · North Salt Lake, UTS/N BB-1061 N200YZHi Ballooning LLC · Hamilton, NJBuilt 1995 · S/N 180 N2010HChelgren David W · Colorado Springs, COBuilt 2020 · S/N 1713