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.

N207ASStegner Wallace P · Truckee, CABuilt 1977 · S/N B-786 N207LBSchraufnagel Andrew C · West Bend, WIBuilt 2004 · S/N 5285 N207TCGauthier Martin T · Waterford, MIBuilt 1991 · S/N 2012USA N2080AMullinax Thomas A · Greenville, SCBuilt 2005 · S/N 341 N2080CCaputo Joseph A · Pittston, MEBuilt 2006 · S/N F7B-2013 N20810Northern Light Balloon Expeditions Sedona Balloon · Sedona, AZS/N 209 N2081KSkylifter LLC · Naples, FLBuilt 2005 · S/N F8B2083 N2082AUrbanski Frank P · Dakota Dunes, SDS/N 5425 N2082YRegistration Pending · Hutchinson, KSRegistration pendingS/N 202 N2083KShute Steven D · Richmond, INBuilt 2004 · S/N 335 N2083UAustin Aeronauts Inc · Austin, TXBuilt 1988 · S/N 5445 N2085Clark Raymond C · Rapid City, SDBuilt 1972 · S/N RMKWTM1872 N2085EScheve Eric J · Spirit Lake, IABuilt 2006 · S/N F8B-2096 N2086DSuskin Dan · Atlanta, GABuilt 2007 · S/N F8B-2098 N2087JPerfect Flight LLC · Albuquerque, NMBuilt 2011 · S/N 6636 N2088FRogina James W · Anchorage, AKBuilt 1976 · S/N 801 N2089STxt Aviation LLC · Deland, FLS/N R18201299 N208ASHardy Sandra N · Monson, MEBuilt 1977 · S/N 272 N208CSKennedy Richard C · Providence, UTBuilt 1995 · S/N 208CS N208DDAer Blarney Balloons LLC · Bethlehem, CTBuilt 2014 · S/N 2014-54-1 N208GMRiddick John H Jr · Waller, TXBuilt 1994 · S/N 008 N208UVaughn Michael E · Johns Creek, GABuilt 2002 · S/N 127 N2091GWells Russell L · Seville, OHS/N 211 N2091TDougherty Donald A · Colorado Springs, COBuilt 2006 · S/N 346 N2096HPortland Rose Balloons LLC · Wilsonville, ORBuilt 2005 · S/N GLX-10710 N2097HChristensen Marjorie A · Albuquerque, NMBuilt 2007 · S/N 6505 N2097WMolnar Jacob W · Vacaville, CAS/N 6512 N209ATSkycab Balloon Promotions Inc · Louisville, KYBuilt 2007 · S/N 5379 N209SMMccourt Kimberly R · Winter Haven, FLS/N 5380 N209TCMarkert Timothy C · Edina, MNS/N 2010USA N20ABTanner Roger J · Rosamond, CABuilt 1980 · S/N 20338 N20BABeers Edward R Jr · Rancho Santa Fe, CABuilt 1976 · S/N N9 N20CXGaines Paul A · Kingman, AZBuilt 1983 · S/N 20702 N20DQBerry Wallace D · Lafayette, ALBuilt 1977 · S/N 20018 N20EDConrad Craig M · Hickory, NCBuilt 1977 · S/N 1503 N20EKCoucke David A · Nashville, INBuilt 1976 · S/N 20122C N20EXHirschauer Jeff · Spokane, WABuilt 1994 · S/N 020 N20HSCoffield Alan B · Canyon Lake, CABuilt 1984 · S/N 3860-K-106 N20LYGlobal Media Box LLC · Albuquerque, NMBuilt 2017 · S/N 6817 N20MGGeres Charles K · Casa Grande, AZBuilt 1982 · S/N 86 N20MMLedbetter Jason H · Ypsilanti, MIBuilt 1975 · S/N 20016 N20NTSanders Tyler G · Tehachapi, CABuilt 1979 · S/N 20275 N20PKJohnson Steven M · Waukesha, WIBuilt 1975 · S/N 20031 N20QSLoewenstein Paul N · Palo Alto, CABuilt 1983 · S/N 20705 N20SJReuter Gary G · Littleton, COBuilt 1975 · S/N 20064 N20TJLeonard Steven E · Wichita, KSBuilt 1981 · S/N 20 N20TSFlying Boyz Soaring LLC · Lakeland, FLBuilt 1981 · S/N 20483 N20UHHenry Raymond L Jr · Belton, TXBuilt 1985 · S/N 20809 N20UMBraden R Morgan · Rio Rancho, NMBuilt 2021 · S/N 210/154 N20UZEarles Craig P · Vail, AZBuilt 1978 · S/N 20016