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.

N4065TYoder Alan M · Millersburg, OHBuilt 2004 · S/N 16406 N4066MJohnson Charles Edward · Winchester, KYBuilt 2004 · S/N 16388 N40675Smith John C · Ashland, KYBuilt 2004 · S/N 16382 N4067MDickess Ronald D · Ironton, OHBuilt 2003 · S/N 16356 N4067XEvans Joshua L · Ironton, OHS/N 6227 N4068MCorwin Timothy G · Southampton, NYBuilt 2002 · S/N A284POW N406MESheppherd Anthony B · San Diego, CABuilt 2007 · S/N A53PCH N406PEDickerson Darwin · Sturgis, MIBuilt 2005 · S/N A 406 PEG N406TBJackson Donald R · Pattison, TXS/N 4828 N40705Dueitt Chris · Leakesville, MSS/N IPP-305 N40708Denning Robert D · Idaho Falls, IDBuilt 2001 · S/N 2826 N4071WZankovitch Joe · Stopover, KYBuilt 2003 · S/N 16367 N4085HTalbott Scott D · Houston, TXBuilt 2007 · S/N XA-265ROW N409JKSavage Julian J · Butler, PABuilt 2000 · S/N A-210 POW N409NPParzych Gary S · Trumbauersville, PABuilt 2010 · S/N B21480 N409PPParzych Gary S · Trumbauersville, PABuilt 2010 · S/N H20027 N409TRDixon Robert L · Omaha, NEBuilt 2007 · S/N 193421 N409URTurner Kenneth H · Lake Placid, FLBuilt 2010 · S/N A-229POW N41079Hilderbrant William DBA · Dansville, NYBuilt 2002 · S/N SR7XL-2737 N41091Sea & Sky Inc · Fort Walton Beach, FLBuilt 2002 · S/N SB-012K218 N41093Sea & Sky Inc · Fort Walton Beach, FLFirst renewal noticeBuilt 2002 · S/N SB-032K113 N41097Sea & Sky Inc · Fort Walton Beach, FLBuilt 2002 · S/N SB-2K217 N412HGMashy Tiki · Sugar Land, TXBuilt 2001 · S/N 36 N4157PBedwell Brock J · Carlisle, IABuilt 2004 · S/N 0063 N415AGMeyer Gary B · Vernonia, ORBuilt 2013 · S/N 1292353 N415CKKnop Donald Lee · Vernal, UTS/N 0504813 N416AFAcadian Dusters LLC · Church Point, LABuilt 2008 · S/N 0107 N417AGDavis Peter A · Pahrump, NVBuilt 2010 · S/N LS7017 N417MLMueller Victor M · Seattle, WABuilt 2010 · S/N 003 N419RXGoldman Richard · New Bern, NCBuilt 2019 · S/N X1001 N41CNCloutier Chuck A · Zimmerman, MNS/N 0041 N420GMMinolli Gregg · Chelan, WABuilt 2005 · S/N 3564 N422LNChua Boon T · Gardena, CAS/N E7019 N4247FMiller Keith A · Syracuse, INBuilt 1998 · S/N 4413 N4260XWalker Gene S Jr · Mirando City, TXS/N A272PEG N4260ZSchmeeckle Tim · Gothenburg, NEBuilt 2005 · S/N 16476 N42624Struck William C · Burton, MIFirst renewal noticeBuilt 2008 · S/N 180020 N42636Jeffery Scott Stamps · Mounds, OKS/N 99-296XR7 N42637Spmc Inc · Gothenburg, NEBuilt 2003 · S/N 6206 N42664Donovan John P · Moultrie, GABuilt 2005 · S/N 0701018 N426AJWeaver Gary · Buchanan, GABuilt 2009 · S/N 01 N426WSMckinley Tray D · Quemado, NMBuilt 2018 · S/N 1704 N42708Goss Brian V · Allenstown, NHBuilt 2002 · S/N A20INF N4278CVan Ausdoll Timothy A · Vienna, ILBuilt 1999 · S/N 4595 N4290MMiller Steven C · Gravette, ARBuilt 2004 · S/N A346PEG N4294EHershberger Roy A · Mishawaka, INBuilt 1997 · S/N 0003 N429XHBlunck Rex A · Francisco, INBuilt 2010 · S/N IPP10-399 N42HGMashy Tiki · Sugar Land, TXBuilt 2004 · S/N 310101 N42UPWhite Gil R · Blanchard, OKBuilt 2007 · S/N PC090753W403 N430EBBoyles Jerry D · Catoosa, OKS/N IPP2-081

Back to Rotax 582SER