Skip to content

Registered aircraft · 1,193

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

N666TJSimeon Jim · Ogallala, NEBuilt 2000 · S/N 2588 N667DFMorgan Cheryl A · Vass, NCBuilt 2006 · S/N C-88 N672RLLamb J Richard · Newport, PABuilt 2013 · S/N GCU067 N67608Letteer Glenn J · Ogden, UTBuilt 2007 · S/N 1092 N681TTRamaker Joseph J · Boise, IDBuilt 2007 · S/N 1243D N6862KSchroder Jerry W · Rainier, WAS/N ER012 N688FSStarved Rock Flying Club Inc · Peru, ILBuilt 2016 · S/N 0316 N68902Boyle Joseph E · Hagerstown, MDBuilt 2010 · S/N JB111 N690LPWenman James T · Bellville, TXBuilt 2007 · S/N SPORT 2S-0197 N6951TWilliams Keith · Jacksboro, TXS/N 3C0475 N696RRSchmidt James P · Aurora, COBuilt 2007 · S/N T98001 N697TCLovertich Alex A Jr · Brandon, MSBuilt 2004 · S/N 16421 N698PJopp Mike J · Shakopee, MNBuilt 2007 · S/N IPP2-035 N69NPHodgson Peter C · Dansville, MIBuilt 2007 · S/N A057SCI N7000DQuinton Bryan E · Lacey, WABuilt 2000 · S/N T00041 N7008GMitchell Kevin W · Bieber, CABuilt 1996 · S/N 3524 N7008QRegistered aircraftS/N 16471 N7009UWagner Robert John · Trumbull, CTBuilt 1997 · S/N T97103 N70135Bellavance David · Cumming, GABuilt 2007 · S/N 0059 N7014NPeterson Jerry E · St Petersburg, FLBuilt 2007 · S/N 0431100 N7014XZillig Tyler · Goliad, TXBuilt 2002 · S/N A323POW N7017JWillson Wade · Wellington, COBuilt 2002 · S/N A028PEG N7020PDyke Byron · Locust Grove, VABuilt 2005 · S/N 368 N7027NBryant Bruce E · Joplin, MOBuilt 2003 · S/N A-106 PEG N7028VAlfreno Jason O · Grove City, PABuilt 2003 · S/N 2868 N702TJGorman Jeremy J · Chapman, KSBuilt 2002 · S/N IPP2-061 N7043YMarble Lawrence J · Halifax, MABuilt 2006 · S/N T06052 N7046AKedrowski Adam P · Little Falls, MNBuilt 1998 · S/N 1202D N7046UDupuis Joseph A · Morganton, NCFirst renewal noticeBuilt 2001 · S/N 662 N7055JGarber Micah Z · Shippensburg, PABuilt 2007 · S/N 99-2187-SR7-1 N7055YDuty William · Wayside, WVBuilt 2002 · S/N 2802 N7056FAdam Tim E · Dewitt, MIBuilt 2007 · S/N 4C0583 N7056KJohnson Dale F · Marion, INS/N 6019 N7056YCollins John F · Coronado, CABuilt 2004 · S/N H 20022 N7059BHeath Caleb Michael · Knoxville, TNFirst renewal noticeBuilt 2006 · S/N A 420 PEG N7059LThiel Douglas P · Hilbert, WIBuilt 2007 · S/N 3123 N7059QHoward Steven M · Choteau, MTBuilt 2001 · S/N EDGE X-582-617 N7059XMcclure Mike J · Bloomfield, IABuilt 2007 · S/N A 441 PEG N705MDFawcett William D · Monroeville, PABuilt 1988 · S/N 0288002 N7060PHohenstein Shane E · Brazil, INS/N A145PEG N7061EDuvall Daniel Scott · Grand Rapids, MIBuilt 2001 · S/N T2070501 N7064YHilton William J · Wasilla, AKBuilt 2000 · S/N 582-573 N7068VKness Richard P · Casa Grande, AZBuilt 2003 · S/N 11141964 N70726Hicks Kenneth D · Jamestown, TNBuilt 2001 · S/N 2638 N70750Romero Richard W · Lake Stevens, WAFirst renewal noticeBuilt 2000 · S/N 2521 N7076LWilks Donald Leon · Flat Rock, ALBuilt 2006 · S/N 4433582 N707MEMesser Matt B · Moses Lake, WABuilt 2004 · S/N 2983 N707TTDees James R · Coolidge, GABuilt 1996 · S/N 3449 N7082VProfessional Pilots Inc · Lowell, INBuilt 2007 · S/N 4C0588 N7085VBowman Dennis R · Brazil, INBuilt 2007 · S/N A104 POW

Back to Rotax 582SER