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.

N1521Stevenson Malcolm D · Cedar Crest, NMBuilt 1967 · S/N 49 N1521AFerguson Kenneth A · Albuquerque, NMBuilt 2008 · S/N F8-2024 N1521GDekoevend Enterprises · Fort Garland, COBuilt 2003 · S/N F8B-2029 N1521WMcnabb Donald I · St Louis, MOBuilt 1981 · S/N 11055 N1521YTimko Steven O · Califon, NJBuilt 2006 · S/N 5321 N1522HFleck Jonathan · Whitehouse Station, NJBuilt 2002 · S/N F8B-2015 N1522PParmley Tina · Sun City, AZBuilt 1981 · S/N 11064 N1522UGarrison Susan K · San Marcos, TXBuilt 2002 · S/N F7-2012 N1523DDonahue Kathryn · Grove, OKS/N F7B-2006 N1523GSale Reported · Marlton, NJSale reportedBuilt 2003 · S/N GLX-1777 N1523HCearley Jamey · New Durham, NHBuilt 2002 · S/N F7-2021 N1523KBrady Neal L · Centralia, MOBuilt 2002 · S/N F8B-2028 N1523LLeonard Ian Q · Burlington, NCBuilt 2002 · S/N F8-2005 N1524ARe/Max Marketing Fund LLC · Denver, COBuilt 2007 · S/N 5375 N1524RCity Of Riverton · Riverton, WYBuilt 2002 · S/N F8B-2030 N1524TYoung Dennis N · Glen Mills, PABuilt 1970 · S/N 41 N1524UGoodman Travis W · Amarillo, TXS/N 10311 N1524VHooper Kirk M · Albuquerque, NMBuilt 1981 · S/N 10319 N1525ADraughn Ken · Burlington, NCS/N 5365 N1525GWagner Cameron B · Casper, WYBuilt 2002 · S/N F8B-2018 N1525LStar Ballooning LLC · Bridgewater, VABuilt 2003 · S/N F9B-2003 N1525REmerald Shazam Inc · Pittsburgh, PABuilt 2003 · S/N F7-2028 N1525XSutter Denis M · Hallsville, MOBuilt 2002 · S/N F8B-2019 N1525YAeronautical Adventures Inc · Eagle, IDS/N F7-016 N1526LKolb David B · Monticello, ILBuilt 2003 · S/N F8-2006 N1526RGallant Michael T · Columbus, INBuilt 2002 · S/N F8B-2033 N1526UPayne Ralph J · Hastings, MIBuilt 1981 · S/N 11103 N1526ZHannigan Jerome W · Mounument, COBuilt 1981 · S/N 11085 N15276Mezey Robert E · Parrish, FLBuilt 2009 · S/N 5425 N1527EDunavent Duncan · Statesville, NCBuilt 2003 · S/N F8B-2037 N1527JSale Reported · Rochester, NYSale reportedBuilt 1981 · S/N 10996 N1527LReich Edwin B · Meridian, IDS/N F8B-2047 N1527QSewell Robert M · Reno, NVS/N 10195 N1527TJackson Dwayne K · Rio Rancho, NMBuilt 2002 · S/N F8B-2022 N1527UHill Michael E · Conifer, COBuilt 2003 · S/N F8B-2045 N1527ZPierre Peter A · Fresno, CABuilt 2003 · S/N F8B-2044 N1528CEscape Adventures Inc · Temecula, CABuilt 2006 · S/N 5344 N1528MChilds Cary J · Wellsville, NYBuilt 2002 · S/N F7-2020 N1528UReinert Michael P · Alta, IABuilt 2003 · S/N F7-2030 N1528ZNext Generation · Roswell, NMBuilt 2003 · S/N F8B-2009 N1529GGrandinetti Robert L · Fayetteville, NYBuilt 2003 · S/N F8B-2039 N152ASAdirondack Soaring Association Inc · Ballston Spa, NYBuilt 1980 · S/N 3545 N152FLevas Timothy J · Cardiff By The Sea, CABuilt 1966 · S/N 30 N152LPWooge Glen S · Swisher, IAS/N 189 N152PWSerota Andrew · Media, PABuilt 1993 · S/N U-15 N152SSSwayze Henry S · Tunbridge, VTBuilt 1977 · S/N 1502 N15332Forney Gary R · Ennis, MTBuilt 1980 · S/N 10207 N1533FMcgrath John H III · Cary, ILBuilt 1980 · S/N 10200 N1533GAlbertson James M · Westville, FLS/N 10203 N15357Mcgrath Patrick K · Yucaipa, CABuilt 2013 · S/N 5495