Skip to content

Registered aircraft · 473

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 ('34801', '34802')
  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 ('34801', '34802')
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.

N100VYScott David W · Bridgeport, MIBuilt 2011 · S/N W0100 N103DFButner Mark D · Marshall, MOBuilt 2015 · S/N 75-7609 N104KJKrizman Kent J · Danville, CABuilt 2009 · S/N 79 N105SXGuluzza Barbara L · Santa Clarita, CABuilt 2012 · S/N 1105 N106ALMurphy Peter · Santa Fe, NMBuilt 2011 · S/N 111 N106DBittinger Darren C · Hagerstown, MDBuilt 2006 · S/N 0899 N107BMThompson James R · Warren, OHS/N 6-6345 N107JFBas Part Sales LLC · Greeley, COBuilt 2007 · S/N 0705D0303 N109LDavis Danny L · Tulsa, OKBuilt 2024 · S/N 758723 N111YXLaurie Kip D · Atlanta, GABuilt 2010 · S/N W0082 N11225Hancock Bobby Earl Jr · Norton, OHS/N 248 N115ARBurkhart William · Warrensburg, MOBuilt 2009 · S/N 6-6803 N116LCRonnies Aircraft Sales Llp · Pittsfield, MABuilt 2007 · S/N AL-1097 N11NSMccoig Roger A · Clarks Hill, SCBuilt 2007 · S/N 271 N120CCMueller James F · Garden Ridge, TXBuilt 2007 · S/N 402 N121LWheeler Philip G · Grand Prairie, TXBuilt 2010 · S/N 45 N121YXEngert Larry R · Coeur D Alene, IDBuilt 2011 · S/N W0121 N1222CMilitante Michael J · Vallejo, CABuilt 2016 · S/N 1662 N122ETCaruso Frank T · Port Saint Lucie, FLBuilt 2007 · S/N JAESC0109 N123WLAxefoot LLC · Kalispell, MTBuilt 2008 · S/N 63 N125GDLino Lopez Pa · Eustis, FLBuilt 2010 · S/N 105 N125JLYoder Dallas K · Mechanicsburg, OHS/N 552 N125YSShinas Jim M · Los Alamos, NMBuilt 2011 · S/N 0907 N126PDFox David J · Anchorage, AKBuilt 2008 · S/N 001 N127KLTaylor Lane S · Oscoda, MIBuilt 2010 · S/N 97 N127ZPSky West Aviation Inc Trustee · Albuquerque, NMS/N A012 N1299PStark Glenn M · Nampa, IDS/N W0057 N1304SKingman Mark R · Berryton, KSBuilt 2011 · S/N 1304 N134SJefferies Vincent · Rock Springs, WYBuilt 2010 · S/N SS07XXXC0HK0520 N135YXGazia Adel R · New Smyrna Beach, FLBuilt 2011 · S/N W0135 N136YXBlackstone John W · Arlington, TXBuilt 2010 · S/N W0136 N139XWeston Peter A · Fort Atkinson, WIBuilt 2008 · S/N 1066 N13LNHargis Jeffry · Cleveland, MOBuilt 2012 · S/N 141 N142ALKt Resources Inc · Glendora, CABuilt 2011 · S/N 137 N143ERTappen Holdings · Cadiz, OHBuilt 2012 · S/N 75-8300 N143NMRadtke Norman H · Fond Du Lac, WIBuilt 2014 · S/N W0143 N146MPEshuis Hermannus A · Lake City, FLBuilt 2010 · S/N 1198 N148YXGerhardt Paul H · Centreville, MDBuilt 2011 · S/N 148 N154MKWorthington Galen A · Tubac, AZS/N 1284 N155JMBequette Eugene · Rolla, MOBuilt 2007 · S/N 74 N155LTStirkins Troyce · Jamestown, TNBuilt 2007 · S/N 14 N156WTMccurdy Michael · Blanchard, OKBuilt 2007 · S/N 001 N157SXBarber Robert E · Bryan, TXBuilt 2009 · S/N 0271 N159BTGaffaney Michael L · Lompoc, CABuilt 2014 · S/N 1185 N159MFFletcher Jerry D · Yukon, OKBuilt 2018 · S/N 6-4996 N161LSSmallsreed Lee J III · Prescott, AZBuilt 2013 · S/N 138 N165TJSimmon Timothy A · Jefferson City, MOBuilt 2011 · S/N 6-7060 N167JTTimm James D Trustee · Tempe, AZBuilt 2007 · S/N 6-6183 N16PZKnapp Frank E · Palmer, AKBuilt 2008 · S/N AL-1129 N176DFFenton Alan C · Interlachen, FLBuilt 2008 · S/N 76

Back to Jabiru 3300