Skip to content

Registered aircraft · 475

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.

N176KPGresham Kenneth D · Licking, MOBuilt 2008 · S/N A268 N188DMMcgloon David P · Grants Pass, ORBuilt 2017 · S/N 0739 N197RWCasto Donald E · Point Pleasant, WVBuilt 2008 · S/N 75 N200BEErtz Mark G · Burlington, IABuilt 2007 · S/N 6-6494 N203WTLapille Jr Joseph Arthur · El Paso, TXBuilt 2007 · S/N 456 N204SBMoondog Investments LLC · Scottsdale, AZBuilt 2008 · S/N SB-01 N208VBButner Mark D · Marshall, MOBuilt 2008 · S/N 6-6879 N211BKKincaid Janet L · Johnson City, TNBuilt 2006 · S/N 024S N211HLTaylor Jeffrey S · Sisters, ORBuilt 2011 · S/N JA229-02-11 N211NMEiland James D · Flower Mound, TXBuilt 2008 · S/N 0811D0323 N211NYSaunders George A · Powhatan, VABuilt 2007 · S/N 0704D0293 N211RPPattisapu Ram · Justin, TXS/N 0902D0333 N211TXWalker Michael L · Fredericksburg, TXBuilt 2010 · S/N 139 N211USCarpenter John D · Richland, WABuilt 2006 · S/N 007S N211WCRebmann Jeremy David O · Stillwater, OKBuilt 2010 · S/N 757818 N213DCFedorenko Vladimir Y · Estacada, ORS/N O/C 5 KE 04 N213RCCoyner Philip C · Belpre, OHBuilt 2007 · S/N 42 N214DGLondono Maximiliano · Tucson, AZS/N 113 N214RMTreusch Christopher J · Saint Clair Shores, MIBuilt 2006 · S/N 249 N218PJr Aviation LLC · Tulsa, OKBuilt 2011 · S/N JA198-02-10 N21VLLinger Virgil S · North Canton, OHBuilt 2008 · S/N 66823 N223SXClark Ian R · Watertown, MABuilt 2003 · S/N 223 N226WBAylor Gary D · Oklahoma City, OKBuilt 2010 · S/N 104 N2300XStafford Wesley Shane · Smithville, TNBuilt 2017 · S/N 52 N230HBDaily James E · Snohomish, WABuilt 2016 · S/N 030 N230WMMuehlberg Stephen E · Newcastle, OKBuilt 2007 · S/N 6-6477 N234AZYoder Fred T · Fountain Hills, AZBuilt 2004 · S/N 16 N23661Chickasha Wings Inc · Chickasha, OKS/N 080900077 N23GBWitt Michael A · Springboro, OHBuilt 2010 · S/N 6-6422 N2409GHeiner Miles C · Ophir, COS/N 6-6842 N24291Spencer Elmer C · Ludington, MIBuilt 2010 · S/N 100800039 N246RMBroadmoor Consulting LLC · Benton, LABuilt 2007 · S/N AL-1099 N246SSitter Layne E · Sussex, WIBuilt 2009 · S/N 169 N247DTThurston Dana H · Stratham, NHBuilt 2009 · S/N 123 N2483XPerry Randy J · Kingman, AZBuilt 2007 · S/N 6-5934 N249WPSale Reported · Spanaway, WASale reported, canceledBuilt 2008 · S/N 6-6721 N250MRRegistered aircraftBuilt 2006 · S/N 348 N260SXGriffin Tommy N · Jackson, TNBuilt 2008 · S/N 260 N2699THadley Robert A · Dayton, NVBuilt 2007 · S/N 314159A N269NBBihm Paul · Frostproof, FLBuilt 2011 · S/N 124 N270JDawson Thomas K · Littleton, NCS/N 00101 N282ASElliott James Richard · Florence, ALBuilt 2011 · S/N 126 N283JLMoreland William L · Bedford, PABuilt 2011 · S/N A283 N283RSWay Robert Louis · Morristown, AZBuilt 2008 · S/N 05071811 N28CDTheos George · Melbourne, FLBuilt 2024 · S/N 1719 N28LRStevens Harold D Jr · Gautier, MSBuilt 2008 · S/N 0902 N2930SMills Kirk A · Elbridge, NYBuilt 2009 · S/N 1206 N297RBBens Russell T · Gardnerville, NVBuilt 2007 · S/N 6-6841 N29DNDooley David C · Erie, COBuilt 2011 · S/N X0029 N301ASmith Scott William · Lincoln, NEBuilt 2011 · S/N 795

Back to Jabiru 3300