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.

N545KHMojica Roberto · Orocovis, PRBuilt 2006 · S/N 1RPNK N545MPWilson Peter M · Warner Robins, GABuilt 2007 · S/N A-237-PEG N54BTHeron John S · Denver, COBuilt 2003 · S/N 15GST N54VZVezie Blaise L · Onalaska, TXBuilt 2008 · S/N PC010953P51 N55026Kaufman Timothy L · Palm City, FLBuilt 2007 · S/N 16340 N5502JPendley Terry L B · Carbon Hill, ALBuilt 1995 · S/N GT5-TC0104 N5507RReiter Fred R · Brighton, COBuilt 2004 · S/N 582 944 N5509KLopez Jose J · Lansing, ILBuilt 2001 · S/N 6145 N550RVStanley Donald R · Shawano, WIBuilt 2003 · S/N T02004 N55119Mccarty Robin A · Big Rapids, MIS/N TA-17 N5512KStone Ronald K · Edwardsburg, MIBuilt 1994 · S/N 3193 N5513YCalladine Matthew L · Wellsville, NYS/N 5821053 N5514WHornbake Lawrence E · Gettysburg, PABuilt 1998 · S/N WA 670 N5519LSale Reported · Killen, ALSale reportedBuilt 2000 · S/N SR7X1-2622 N5521LRobertson Glenn R · Ryderwood, WABuilt 2003 · S/N IPP2-062 N5534FWysocki Russell M · Custer, WIBuilt 2004 · S/N IPP4-217 N554EReynolds Jarrod N · Lipan, TXBuilt 2002 · S/N A 053 PEG N555KDChristopherson Kevin · Casper, WYBuilt 2012 · S/N 001 N555YZBouis Charles J III · Missoula, MTS/N PC010853W408 N556BWGodwin Bobby L · Key Largo, FLBuilt 2010 · S/N 1092369 N5570TLemon Jay · Arcadia, OKS/N A411PEG N557RHSchmitt Mark A · Fort Branch, INBuilt 2002 · S/N 3C0502 N558ARIosua Gary F · Billerica, MABuilt 2002 · S/N 0006 N55995Rash Floyd E · Powhatan, ARBuilt 2002 · S/N A090PEG N559RDMinear Paul · Ramsey, MNBuilt 2009 · S/N JG001 N55FZKuranda Michael J · Stamford, VTBuilt 2000 · S/N HD00044M N56006Ruffino Michael · Yuma, AZBuilt 2006 · S/N 3012 N5601YPowers Thomas R · Seminole, FLS/N 3648 N5602ELoafman Michael A · Bowling Green, KYBuilt 2006 · S/N IPP6-335 N5602GWebb Mark E · O Brien, FLS/N 7-314729479 N5603Werren Carroll E · Epsom, NHBuilt 2002 · S/N HD02070M N5603DPittenger David F · Belton, TXBuilt 2005 · S/N A-349-PEG N5603TStraub Karl M · Smithfield, UTBuilt 2002 · S/N DE 2824 N56045Condon Ronald W · Winston Salem, NCBuilt 2003 · S/N 0601013 N5604GLutz Tony M · Hickory, NCS/N 98-2085-SR7X1 N56051Rhody Daniel A · Toronto, SDBuilt 2002 · S/N 5503646 N5605NIfly4u LLC · Benton, LABuilt 2000 · S/N A 131 POW N5606KGrant Parish Sheriffs Office · Colfax, LABuilt 2006 · S/N 16825 N5608PTanner David M · Eden, UTBuilt 1999 · S/N 99 2215 SR7XL N5609HPier Martin S · Deer Trail, COFirst renewal noticeS/N 582-626 N5609PReynolds Jackye · Raleigh, NCS/N T99080 N56117Gillette Donald E Jr · Lakeland, FLBuilt 2003 · S/N A122PEG N5611UMartin Brent M · Reinholds, PABuilt 2002 · S/N 3C0489 N56127Ries Gary G · Prescott, WIBuilt 2007 · S/N R95009 N56128Ries Gary G · Prescott, WIBuilt 2007 · S/N T01003 N56139Martin Kevin · New Carlisle, OHBuilt 2007 · S/N 3397 N5613FLouck Merle W · Phoenix, AZBuilt 2004 · S/N 065-07 N5613KBorths Jamie C · Kenosha, WIS/N HD04123M N5613YWeaver Jason M · Harrisburg, PAS/N 1C0274 N5614AKalb Brian A · Mechanicsburg, OHBuilt 2007 · S/N A155INF

Back to Rotax 582SER