Skip to content

Registered aircraft · 82

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

N105ABDawson Stephen A · Rio Vista, TXBuilt 2002 · S/N A-033 PEG N107SCBerndell Albair · Loudon, NHS/N 3148 N108KMJessop Edson L · Corvallis, MTS/N A146POW N1114PDuvall Farren J · Victoria, VAS/N 6025175-P N113DCChaney David H · Baton Rouge, LABuilt 2000 · S/N A56POW N1141TBailey Roger L · Milton, FLS/N 6140347-P N139ABEngel Joseph R · Fenton, MOBuilt 2002 · S/N 3C0471 N147SCShields Michael A · Tucson, AZBuilt 2008 · S/N 3094 N149SCBiagioli Mark L · Fort Ogden, FLBuilt 2011 · S/N 3041 N153SCShinn Larry · Stanwood, WABuilt 2008 · S/N 3087 N153STGracy Christopher R · Melissa, TXBuilt 2010 · S/N P582E40200 N154STMckesson Robert M · St George, UTBuilt 2011 · S/N P582E40515 N159SCVisker Jeremy L · Lehi, UTBuilt 2009 · S/N 3103 N161STSkytrails Lsa · St George, UTBuilt 2013 · S/N P582E40520 N167STPomraning Donald C · Prineville, ORS/N P582E40550 N178SCLunsford Warren C · Jasper, TXBuilt 2014 · S/N 3147 N187SCDenny Steven P · Pine Grove, CABuilt 2014 · S/N 3151 N201SCFowler Russell E · Wilsall, MTBuilt 2013 · S/N 3129 N2053HCowart Ron W · Bay City, TXBuilt 2007 · S/N P040553WA N2116KDoolin James J · Carrollton, TXBuilt 2002 · S/N POW276A N218SCDiver Brian · Everett, WABuilt 2010 · S/N 3108 N232ABBurch Martin C · Marana, AZS/N 1005 N2338CLennon Donald · Pequea, PAS/N 1B0139 N239JJJones John M · Wadsworth, OHBuilt 2002 · S/N 200330 N247RPPratt Randy J · Waynesville, MOBuilt 2006 · S/N A-211-PEG N2480ARegistration Pending · Eagle Mountain, UTRegistration pendingBuilt 2004 · S/N 3000 N2499JLinker Robert A · Clio, MIBuilt 2003 · S/N UCB070204 N2509MHoneycutt Kevin C · Pottsboro, TXBuilt 2002 · S/N A-089 PEG N2628MTipton William · Atoka, OKS/N A437PEG N2638APonthieux James J · Marksville, LABuilt 2002 · S/N 2C0356 N2993AGrady Michael Shane · Newport, ARBuilt 2004 · S/N 4C0543 N3135THejtmanek Donald L · Kindred, NDBuilt 1999 · S/N 99-2305 N3171KLayden John M · Moyock, NCBuilt 2003 · S/N 001 N31740Bergeron Jon M · Hooksett, NHBuilt 2005 · S/N 3009 N327FBPartlow Eric J · Tampa, FLBuilt 2002 · S/N 0431112 N32872Bronson David L · Kirkwood, NYBuilt 2007 · S/N HD98003355 N333KDChristopherson Kevin B · Casper, WYBuilt 2013 · S/N 002 N3544DPatel Mehul · Antelope, CABuilt 2006 · S/N 3027 N363MJNolan Robert · Brownington, VTBuilt 2008 · S/N 1B0137 N3798LYoung Boyce L · Black Creek, GABuilt 2007 · S/N PVIN 0528 (8/05)N396SCMay Mark S · Sandy, UTBuilt 2018 · S/N 3190 N39MCMohney James W · Arcadia, FLBuilt 2008 · S/N PC08195EP4S N462SCHlucny Douglas R · Greenbush, MNBuilt 2014 · S/N 3155 N47756Johnson Steven R · Salina, OKS/N A-039 PEG N477WHHutts Walter G · The Villages, FLBuilt 2003 · S/N 001 N5007DBewyer Ronnal L · Hernando, FLBuilt 2007 · S/N 6205 N5070MGeise Todd J · Milton, PABuilt 2002 · S/N A-330POW N507PSBeaman Brice S · Alger, OHBuilt 2003 · S/N 16358 N5083GStauth Ted B · Wichita, KSBuilt 2002 · S/N A-065 PEG N528TSGregory Coy Lyn · Mansfield, TXS/N A-171 POW

Back to Rotax 582E