Skip to content

Registered aircraft · 147

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

N1011VPetersen Michael E · Gypsum, KSBuilt 2007 · S/N 75288 N101ZPPexton Frank L · Douglas, WYBuilt 1999 · S/N DO96XXXCOHK0221 N102JBEdhlund Ian · Seneca, SCBuilt 2002 · S/N 04 N105GRSebold Gregory R · Minnetonka, MNBuilt 2013 · S/N 0379 N108GASelivanoff Paul G · Lincoln, NEBuilt 2002 · S/N MT00100023 N10XADrisko Duane A · Myrtle Beach, SCBuilt 2011 · S/N 1086 N112PKStange Karl P · Cotter, ARBuilt 2008 · S/N 5339 N11STChristensen Thomas C · San Ramon, CABuilt 2009 · S/N 702 N122LFSoignier Kenneth E · Breaux Bridge, LAS/N SKR0603698 N125CGDudley James H Sr · Cleveland, GABuilt 2007 · S/N 1074 N126LLUrban Joseph A · Shawano, WIBuilt 2009 · S/N SKR0802857 N129FRobinson Ernest W · Myrtle Beach, SCBuilt 2020 · S/N R1001 N143RTFillipi Russell J · Hermitage, MOBuilt 2008 · S/N 7-7276 N145LETorello Michael S · Port Huron, MIBuilt 2007 · S/N 974 N146RCEast Coast Aviation LLC · Sheridan, WYBuilt 2009 · S/N CH090 N153DWHarris Mathew R · Lebanon, TNBuilt 2017 · S/N 7-6926 N161AOsterhus Douglas · Dexter, MEBuilt 2010 · S/N 03011409 N162RABoot William M · Jeannette, PABuilt 2008 · S/N CH089 N16XAZerrusen Mark L · South Daytona, FLBuilt 2008 · S/N XA850003 N17XAFly Sky High LLC · York, PABuilt 2008 · S/N XA850004 N184SALumgair David R · Painter, VABuilt 2008 · S/N 05-03-51-379 N18XADreams Come True (Dct) Aviation LLC · Tipp City, OHS/N XA850005 N1952NSale Reported · Statesville, NCSale reportedBuilt 2007 · S/N 1560 N202TMMitchell William T · Griffin, GABuilt 2008 · S/N 010 N2073ZStewart Karl M · Salome, AZBuilt 1987 · S/N 7-1274 N211XTTdsm LLC · Jackson, MOBuilt 2008 · S/N 0804D0383 N211YYCapt Ty LLC · Miami, FLBuilt 2006 · S/N 021S N212SGGill Stephen · Fresno, CABuilt 2002 · S/N 2000 N2187JRegistration Pending · Ottawa, KSRegistration pendingS/N 7-6670 N21XAJones Marlin L · Petaluma, CABuilt 2010 · S/N XA850007 N234JTSarti Charles T · Elk Grove, CABuilt 2002 · S/N M3X01-3-00024 N2535MHoffer Kevin · Pittsboro, INBuilt 2007 · S/N SKR0606724 N2540JWestern Aircraft Leasing LLC · Tempe, AZS/N N0031 N2561PStoll Kerwyn P · Mattoon, ILBuilt 2007 · S/N SKR0701774 N2565YHigh-Country Aviation Workshop For Kids · Loma, COBuilt 2006 · S/N 1099 N2574QMaple Derek R · Jefferson, OHBuilt 2007 · S/N 1118 N2574SAllison Randy L · Woodward, OKS/N 1117 N25853Scully William J · Redondo Beach, CABuilt 2007 · S/N 1147 N2684EWinburn Larry A · Wichita Falls, TXBuilt 1996 · S/N T97503C0HK0278 N2822Durrer John R · Prescott, AZBuilt 2007 · S/N D97582COHK0261 N2828NChase William D · Albany, ORS/N 191 N3178SJohnson Kenneth R · Maiden, NCBuilt 2007 · S/N 1104 N3178UDaniels Andrew Scott · Glasgow, KYBuilt 2007 · S/N 1085 N320JWLee William L · Jonesborough, TNBuilt 2011 · S/N 12101941 N327CSHartman Michael A · Standish, MIBuilt 2003 · S/N M3X20012-0003 N344MBZechmann Casey M · Warrensburg, MOBuilt 2003 · S/N 794 N3505WRegistration Pending · New London, NCRegistration pending, canceledBuilt 2007 · S/N 1138 N3505ZWooten Timothy M · Grifton, NCBuilt 2007 · S/N 1144 N3506CCulpepper Benjamin C · Cleveland, TNBuilt 2007 · S/N 1148 N351CLVan Meter David E · Utopia, TXBuilt 2013 · S/N 7-8526

Back to Jabiru 2200