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.

N357BSCarlson Johnathan J · Hernando, MSBuilt 2007 · S/N 1091 N369LKnight Larry W · Davis, WVBuilt 2011 · S/N 0110304106 N3903BJohnson Timothy W · Oshkosh, WIBuilt 2008 · S/N 07 N391CDPlatt Jerry R · Marysville, WABuilt 2010 · S/N DOOXXXCOHKOU812 N39XAPlane Safe LLC · Bend, ORS/N 1160 N4050KWatts Bryan E · Sandy, ORFirst renewal noticeBuilt 2009 · S/N GHQ002 N4070FTruken Douglas · Griswold, CTBuilt 2007 · S/N 97503COHK0263 N409SXSpringer Jason O · Celina, OHS/N 0409 N415SBMcdonald Thomas M · Fisher, MNBuilt 2008 · S/N M3X04-1-00052 N416WSHiatt Philip D · Marion, NCS/N 984 N421THHanchey Christopher Shane · West End, NCBuilt 2011 · S/N ACS095 N426LLRoe Kevin · Boise, IDBuilt 2011 · S/N 7-6164 N42784Green Alan B · Harrah, OKBuilt 1991 · S/N 0390073 N428WLLev Warren Jay · Fresno, CABuilt 2013 · S/N 0138 N4351MConnell Randy D · Arnold, NEBuilt 2007 · S/N 2000 N43675Ryla Inc · Niceville, FLBuilt 2007 · S/N 1547 N43676Falls Larry W · Morganton, NCS/N 854 N43PLTds Airpro LLC · Shreveport, LABuilt 1994 · S/N ECU 043 N444LDGreen Andrew J · Pahrump, NVBuilt 2011 · S/N SBG002 N4494GCarpenter Michael C · Arbovale, WVBuilt 2010 · S/N MC0107SR2 N45PXBurrow Tony · Texarkana, TXBuilt 2026 · S/N 005 N463YTNichols Tommy J · Cheney, WABuilt 2015 · S/N SRS 00908 N46XAMansfield Anthony L · Georgetown, TXBuilt 2008 · S/N XA850002 N488KMAmeny Christopher P · Snohomish, WABuilt 2011 · S/N 1139 N512WLLorier William W · Lincoln, WABuilt 2013 · S/N 7-7806 N519DVSzabo Frank E · Hermitage, PABuilt 2007 · S/N T06J2250HK0519 N5245TJones Byron W · Manhattan, KSBuilt 2007 · S/N 757 N5253BBoyd Robert W · Brookhaven, MSBuilt 2022 · S/N 101018 N5280VRust Barry L · Ryland Hght, KYBuilt 2009 · S/N 1915 N53BMPope John Franklin IV · Bradenton, FLBuilt 1994 · S/N 860325-200-070 N550SXSmith John S · Goldthwaite, TXBuilt 2006 · S/N 01 N5611BPeterson John W · Decatur, TXBuilt 2013 · S/N 7-7194 N561APPinnick Alan J · Woodstock, GABuilt 2010 · S/N 473 N56LCCub Fun LLC · Huntsville, ALS/N AL-1157 N583JHelens Humble Flyer Shop LLC · Aubrey, TXBuilt 2008 · S/N 38 N596NEBug Smashers LLC · Winfield, KSS/N 1118 N5984PMullins Daniel B · Tuscumbia, ALS/N 1142 N6063BRush Michael E · Burnside, KYS/N 001 N6150QCarlon Lyle E · Soudan, MNBuilt 2009 · S/N 1145 N625PTRyan Richard M · Canyon Country, CABuilt 2010 · S/N SKR0301270 N62MZMorris Jimmy G · Sparks, NVBuilt 2006 · S/N 76 N635LLLong Larry B Sr · Candor, NCBuilt 2012 · S/N 1077 N646SDecker Susanne R · Candler, NCBuilt 2010 · S/N 7-6431 N649MABaker Tillman D Jr · Seaford, DES/N 2622520M-2001 N65PBMurphy Kyle T · Foster, KYBuilt 2014 · S/N S04XXXS0HK0484 N662JRandall L Burks · Cheboygan, MIBuilt 2008 · S/N 185 N665DBBarkley Dale E · Paris, ILBuilt 2006 · S/N 0100 N670JN670j LLC · Montgomery, TXBuilt 2008 · S/N 186 N682JJpw Aviation Inc · Chaska, MNBuilt 2009 · S/N 206 N696GWWhite Gerald L · Morganton, NCBuilt 2011 · S/N 1244

Back to Jabiru 2200