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.

N5234Cone John M · Marfa, TXBuilt 2007 · S/N X0024 N524RSNeuzil Keith G · Oxford, IAS/N 001 N525SEColt Don · Wilder, IDS/N KA08312115 N525XRBrinton Clark F · Portland, ORBuilt 2006 · S/N 190 N526FLRegistered aircraftBuilt 2006 · S/N 325 N526MDunn Quentin L · Midwest City, OKBuilt 2009 · S/N 6-6169 N527XSupan Alan J · San Jose, CABuilt 2010 · S/N 1123 N528RJRegistered aircraftBuilt 2015 · S/N 1325 N52EBBeckman Erwin · Buckner, MOBuilt 2011 · S/N 6-4450 N531SMDrews Michael L · Clover, SCFirst renewal noticeBuilt 2018 · S/N 75-7662 N531TMCowboy Air LLC · Buffalo, WYS/N TM 31 N539DBResen David E · Ripon, WIBuilt 2005 · S/N 61 N542DRReinholm Donald B · Oxford, MIBuilt 2018 · S/N 111500132 N543TFMcdonald William Arthur · Lincoln, NEBuilt 2009 · S/N 6950 N54FWBrandvik Jim R · Prescott, AZBuilt 2013 · S/N 1143 N553GWWagner Conrad L · Glenwood Springs, COBuilt 2008 · S/N JAE5C0106 N554SGGallagher David M · Pleasant Plain, OHS/N 6-6588 N555SXBendel James H Jr · Louisville, KYBuilt 2003 · S/N 0523 N556SXSchroeder James M · Le Mars, IAS/N 0118 N5577RBrehm Richard W · Lanesboro, MNBuilt 2012 · S/N JA201-03-10 N55WXAtkinson Brian D · Lancaster, PABuilt 2009 · S/N W0055 N55ZNNichols Jerry · Boonville, MOBuilt 2011 · S/N 75-7873 N564SRock Gordon L · Mercer Island, WABuilt 2008 · S/N JAESC 0086 N570BLFinkelstein Mark · Southport, NCBuilt 2023 · S/N 983 N570JJPrice John DBA · Bennington, KSS/N 6485 N576TLLecheng Tong · Los Angeles, CABuilt 2005 · S/N 0622 N577DSSingleton Dennis A · Monrovia, INBuilt 2007 · S/N 16 N57CETexas Pilots Academy And Club LLC · Willow Park, TXBuilt 2007 · S/N 380 N581JLoos Gary · Columbia, ILBuilt 2006 · S/N 326 N585JAllred James · South Charleston, WVS/N 362 N586JGet Inspired Flight Inc · Alpharetta, GABuilt 2007 · S/N 378 N586RKWren Alex D · Clovis, NMBuilt 2008 · S/N 0895 N587JSmoak T F · Crystal River, FLBuilt 2007 · S/N 390 N588CMZerull Robert · Waukesha, WIBuilt 2009 · S/N 1004 N589JCefalo Richard · Calabash, NCBuilt 2007 · S/N 392 N591JPruitte George · Borrego Springs, CABuilt 2007 · S/N 411 N594JPalermo Robert · Lecompte, LABuilt 2007 · S/N 414 N595MMLux James H · Paisley, FLBuilt 2006 · S/N M5002 N596JHancock Jeff · Jacksonville, TXBuilt 2007 · S/N 424 N596SXNienhouse Donald R · Downers Grove, ILBuilt 2007 · S/N 0596 N597JWach Jared L · Ogallala, NEBuilt 2007 · S/N 425 N598JLindholm Jeffery L · Dexter, MIBuilt 2007 · S/N 426 N599KMFischer Wendall · Weston, IDBuilt 2007 · S/N 5297 N59PQMcgavock Randall J · Camp Verde, AZBuilt 2012 · S/N 1449 N601BKOne Bravo Kilo LLC · Salt Lake City, UTBuilt 2010 · S/N 6-4881 N601BXLewanski Richard B · Sheridan, ILBuilt 2012 · S/N 6-6195 N601DKTarkowski Jonothan T · Jefferson, MDBuilt 2012 · S/N 6048 N601DXHonabach Don · Tempe, AZBuilt 2008 · S/N 6-3770 N601EBMcwethy Erik W · Asbury, IABuilt 2008 · S/N 6-6845 N601EEErickson Robert C · Cal-Nev-Ari, NVBuilt 2007 · S/N 6-5622

Back to Jabiru 3300