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.

N646MTielking Randall L · Creve Coeur, MOBuilt 1985 · S/N 6046 N64775Adams Bob L · Eagle River, AKBuilt 1977 · S/N 254 N64779Sweeny Bryan · Silverdale, WABuilt 1987 · S/N RX7-3091 N6478XDevery Thomas E · West Palm Beach, FLBuilt 1987 · S/N RX7-3092 N647CBAirtime Equipment LLC · Mesa, AZS/N 647 N647HJBennett James Stephen · Louisville, KYBuilt 2008 · S/N 90/99 N6483Mrozinski Eric · Westford, MABuilt 1971 · S/N 124 N6484Gray Thomas M · Magnetic Springs, OHBuilt 1971 · S/N 125 N6484ELight Flight Balloons Inc · Bel Air, MDS/N RX7-3100 N6485Atkinson Gary R · Pine Grove, PABuilt 1971 · S/N 127 N6486Rippy Robert · Wichita, KSBuilt 1971 · S/N 129 N6486YReeder Kylee · Smartsville, CABuilt 1988 · S/N RX7-3076 N6487MSommers Christopher · Slatington, PABuilt 1987 · S/N S60A-3057 N64904Stasyshyn Robert W · Clinton, NJBuilt 1987 · S/N S55A-3027 N64ATGoulette Bryan · Fort Worth, TXBuilt 1975 · S/N 1 N64DPGottshall Daniel M · Rock Stream, NYS/N 781 N64GWille Chad C · Corning, IABuilt 1962 · S/N 33 N64HRChew Lindsey J · Lafayette, NJBuilt 1978 · S/N 19189 N64JCLakser Lawrence J · Labelle, FLS/N 6-14 N64PGGaisford Phillip A · Billerica, MABuilt 2002 · S/N 134 N64QThurmond Clark · Georgetown, TXBuilt 1975 · S/N 19 N64RCCarlton Robert D · Polk City, FLBuilt 1986 · S/N RC8 N64TEStodolski Mark D · Sterling, MABuilt 2015 · S/N 5574 N64UHFerrell Harold C · Franklin, TNBuilt 1978 · S/N 3314 N64XRA&L Professional Services Inc · Minden, NVBuilt 2023 · S/N 2115 N65005Embraceable Blue LLC · Santa Fe, NMBuilt 2010 · S/N 6577 N6501DLeonard Steven E · Wichita, KSBuilt 1959 · S/N 652 N6501GAirtime Equipment LLC · Mesa, AZBuilt 2011 · S/N 6616 N6501NCohrs Rodney S · Rochester, NYBuilt 2012 · S/N 6656 N6503KDailey Patrick J · Bardstown, KYBuilt 2009 · S/N 6573 N65066Monahan Todd J · Queensbury, NYBuilt 2011 · S/N 6637 N6508SEscape Adventures Inc · Temecula, CABuilt 2011 · S/N 6598 N650BHTrieber Steven M · Eastport, MEBuilt 2000 · S/N 002 N650SASouthern California Soaring Academy Inc · Valencia, CABuilt 2011 · S/N 21888 N650TECoop Balloons LLC · Swisher, IABuilt 2014 · S/N 5553 N6510NBalloons Above The Valley · Napa, CABuilt 2011 · S/N 6614 N65113Jacobs Steven L · Lakeland, MNBuilt 2015 · S/N 6648 N6511NBalloons Above The Valley · Napa, CABuilt 2011 · S/N 6615 N6512Badal Gerardo A · Eastsound, WABuilt 1969 · S/N 63 N6513PStangeland David · Cedar Falls, IAS/N S60A-3060 N6514MColton Daniel R · San Carlos, CABuilt 1985 · S/N 20801 N65157Mars Leasing · Phoenix, AZBuilt 2012 · S/N 6647 N6517XAdventure With Altitude Ballooning LLC · Poughkeepsie, NYBuilt 1987 · S/N S60A-3062 N6519QFox Thomas B · Steamboat Springs, COBuilt 1966 · S/N RX7-3066 N651ASStyker Andrew J · Xenia, OHBuilt 1979 · S/N 19289 N651DPTimpson Lawrence · Pound Ridge, NYS/N 62 N651VJJohnson Victor T · Prosser, WABuilt 2017 · S/N 001 N6524VJaramillo Amy R · Rio Rancho, NMBuilt 2011 · S/N 6608 N65256Wingfield John R · Charlottesville, VABuilt 2014 · S/N 6685 N6525SStarr William · Buckeye, AZBuilt 2011 · S/N 6622