Skip to content

Registered aircraft · 54

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 ('01400')
  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 ('01400')
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.

N101MPBedwell Stephen R · Grant Valkaria, FLBuilt 2008 · S/N 0858 N1020XPainter George L · Park City, UTBuilt 2009 · S/N 1020 N102TYRisjan Randy D · Westfield, NYBuilt 2012 · S/N 1160 N111NXSonex Ltd · Oshkosh, WIS/N 0001 N119BMFournet Emile M · Charlotte, NCBuilt 2012 · S/N 0056 N129SXRobbins William T · Lake Havasu City, AZBuilt 2009 · S/N 475 N1452JLeupp John R · Taylors, SCBuilt 2012 · S/N 1001 N1529Goodyear Robert J · Newton, ALBuilt 2012 · S/N 1227 N1534SBaker Dana R · Acton, CABuilt 2015 · S/N 1534 N164SXKarnes Mason A · Channelview, TXBuilt 2010 · S/N 164 N176WSLack Christopher K · Milan, INBuilt 2013 · S/N W0176 N178KTJarrett Thomas A · Luthvle Timon, MDBuilt 2008 · S/N 0178 N184LFulton Ronald A · Mount Pleasant, TNBuilt 2006 · S/N 928 N214KERhode Keith E · Prior Lake, MNBuilt 2010 · S/N 1009 N220CXDeckard Leroy Jr · Waller, TXBuilt 2010 · S/N 5982 N23092Todd Robert S · Chandler, AZBuilt 2020 · S/N ONX0017 N239KPPerkins Edward A · Appleton, WIBuilt 2012 · S/N 0371 N256CMMadsen Christopher J · Huntsville, ALBuilt 2014 · S/N 1485 N30BLO'Mara Michael P · Saint Peters, MOBuilt 2012 · S/N 1412 N31PDArmstrong Paul W · Hornbrook, CABuilt 2023 · S/N XNB0014 N34SXLanie Louis K · Ihlen, MNS/N 1053 N362DTCrowl William D · Wilton, CABuilt 2012 · S/N 0049 N40198Wilson Clayton A · Kirkville, NYS/N 0666 N414SXHunt Glenn A · Winchendon, MABuilt 2009 · S/N 639 N427YScaglione Joseph A · Jupiter, FLBuilt 2011 · S/N 0475 N464GBRussell Charles N · Palestine, TXBuilt 2012 · S/N 231 N488ADSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2013 · S/N 020213S1 N514JWWarrington John A · Elkton, MDBuilt 2007 · S/N 0748 N535PDPoland Matthew K · Butler, MOBuilt 2006 · S/N 535 N5560Rocca John C · Box Elder, SDBuilt 2007 · S/N 888 N568SXTiller Arthur R · Kansas City, MOBuilt 2012 · S/N 0568 N585SXSocia Jared R · Roscommon, MIBuilt 2007 · S/N 0585 N610DJSchroepfer Andrew M · Holly Ridge, NCBuilt 2010 · S/N 0959 N613DTFrede William G · Lees Summit, MOBuilt 2011 · S/N 1427 N629SXCap Venture Group Inc · Louisville, KYBuilt 2016 · S/N 1629 N645SXShearer Ronald L · Quincy, INBuilt 2018 · S/N 645 N67YXMig Aviaiton LLC · Sandy, UTBuilt 2008 · S/N 67 N702YHHummel Jeffery L · Demotte, INBuilt 2016 · S/N 1715 N7234RJohnston Richard A · Canton, GABuilt 2007 · S/N 0942 N748DSVogt Thomas Spears · Wimberley, TXBuilt 2007 · S/N 0867 N76EQVanlandingham Russell R · Salem, ORS/N 316 N77131Utsler Charles · Winona, MNBuilt 2008 · S/N 1007 N77YXShell James R · Bremen, INBuilt 2010 · S/N W0077 N814FJGervez Pierre-Yves · Plymouth, NHBuilt 2012 · S/N 1100 N820SXHarbaugh Dennis Marvin · Keizer, ORBuilt 2014 · S/N 1001 N861SXLarson William E · Dunlap, ILBuilt 2011 · S/N 0861 N882YXScott City Aviation LLC · Kingman, KSBuilt 2012 · S/N W0172 N9006WMuncheberg Jens · Valley Center, KSBuilt 2007 · S/N 0526 N908BWPerez Miguel A III · Vineyard, UTBuilt 2007 · S/N 0775 N915SXMurray Dayton E · Eureka, CABuilt 2021 · S/N 0915

Back to Aerovee 2180