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.

N1536CRadowski Johnathan P · Phoenix, AZBuilt 2007 · S/N 5356 N1536MTuttle Ronald A · College Grove, TNBuilt 1942 · S/N 93 N1537BCondon Anthony B · Wichita, KSBuilt 1964 · S/N 50 N1538LMartel Robert P · Sterling, MABuilt 2006 · S/N 5346 N1538QPaulin Jerry · Yuma, AZBuilt 2009 · S/N 5439 N153LBBarnhill Rachel E · Albuquerque, NMBuilt 2001 · S/N 5159 N153MMWinker Gregory J · Denver, COBuilt 1971 · S/N S40A-121 N153MWCzaban John D · Moriarty, NMBuilt 1978 · S/N 3227 N153PWCzarnocha Bronislaw · New York, NYBuilt 2006 · S/N 05.002.03 N153VFlynn Thomas J · Madison, VABuilt 1978 · S/N 20605 N1543ENelson Gregory C · Minden, NVBuilt 1981 · S/N 10979 N1543MNicol Scott M · Mesa, AZBuilt 2020 · S/N 90/199 N1544UBouton Vern H · Fairbanks, AKBuilt 1981 · S/N 10270 N1544YTannehill Theodore J · Howard, OHBuilt 1981 · S/N 10268 N154ASFlint River Soaring LLC · Bainbridge, GABuilt 1967 · S/N 13007 N154CBHall Russell V · Billings, MTBuilt 1978 · S/N 347 N154LHPaul John R · Hamilton, MTS/N LH154 N154MUMueller James J · Washington, DCBuilt 2008 · S/N 2008-54 N154PMGonyaw Gene · Palm Bay, FLBuilt 1981 · S/N E66G41 N15540Feher Ernest V · Lake Forest, CAS/N 115 N155DWLafountain Donald A · Florence, MABuilt 1997 · S/N F71023 N155JSNeil Charles M · Livermore, CABuilt 1958 · S/N 641 N155KSproul Keith A · North Brunswick, NJBuilt 1994 · S/N S57A-3161 N155SSTampa Bay Soaring Society Inc · Zephyrhills, FLBuilt 1978 · S/N 1722 N155TCCarlson Tracy · Henderson, NVBuilt 1986 · S/N 20698 N156RSBreeze Air LLC · Henderson, TXBuilt 2006 · S/N 5327 N157AJPuget Sound Soaring Association · Enumclaw, WABuilt 1998 · S/N 17.10.018 N157KShelton Steven D · Washington, DCBuilt 1998 · S/N 15 N157LBWatson-Meinke Peggy L · Santa Paula, CABuilt 2001 · S/N 5152 N157MCBarnum Andrew R · Ottawa Hills, OHBuilt 2005 · S/N 5294 N1582Leonard Ronald A · Peculiar, MOBuilt 1966 · S/N 24 N1587RRiehl Maria C · Brighton, COS/N 6569 N158LBAnderson Eric · Oshkosh, WIBuilt 2001 · S/N 5175 N158MWWoodard Mark · Hookstown, PABuilt 2018 · S/N 1403 N158NMLamont Mona · Albuquerque, NMS/N 6692 N158SSCounter Aviation Services LLC · Omaha, NEBuilt 1978 · S/N 3142 N158VGl Leonard Aviation LLC · Anacortes, WAS/N 1397 N1595MUniversity Of Central Missouri · Warrensburg, MOBuilt 2008 · S/N F7-2068 N1596Critelli Brian · Webster, TXBuilt 2025 · S/N 001 N1599Willamett Valley Soaring Club · Cornelius, ORBuilt 1968 · S/N 24 N159CALeroy Philippe G · Willcox, AZBuilt 1985 · S/N 101505 N159PBBryant Philip M · Richmond, TXBuilt 2006 · S/N 5333 N159SZMichaels Neal N · Santa Barbara, CABuilt 1980 · S/N B-1053 N159TDBluff City Balloons LLC · Cordova, TNBuilt 2015 · S/N 105/209 N15BLLeonard Steven E · Wichita, KSBuilt 1983 · S/N 15-32 N15BQBalloon Quest Inc · Fenton, MIBuilt 2014 · S/N 6721 N15BTZobell Edward A · California, MDBuilt 1972 · S/N 15236 N15FJDesert Aerospace LLC · Moriarty, NMBuilt 2022 · S/N 256 N15KSCichy Roger D · North Scituate, RIBuilt 1972 · S/N 15232 N15LBHarbison Michael J · Minden, NVBuilt 1975 · S/N 94