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.

N6177GCollier Tony · Grayson, KYBuilt 2007 · S/N 0564 N6178ABurns Jason D · Helena, MTBuilt 2000 · S/N 5061 N6179VHuynh Tam C · Ozark, ALBuilt 2000 · S/N 3C0404 N617DMMoulton Donald E · Bunker Hill, ILBuilt 2000 · S/N A89POW N617SCBlue Wings LLC · Spokane, WABuilt 2006 · S/N TL001 N6180PMoody Felix R · Dudley, NCS/N 3867 N619CWOneil Conn W · Ogallala, NEBuilt 1992 · S/N 06271952 N620SDWinnestaffer Brian E · Palmer, AKBuilt 1990 · S/N 952 N623DRHurley Gary L · Roosevelt, UTS/N CH20694P1172 N623EMPeacock Robert W · Chapin, ILBuilt 2003 · S/N 16338 N623PCShippee Patrick M · Colrain, MABuilt 2001 · S/N T99016 N628FCHeacock Jeffrey A · Hollis Center, MEBuilt 2000 · S/N SR7X1 2599 N62WGNuckles Charles A Jr · Suffolk, VABuilt 2002 · S/N 67 2002 N630DHMckibben Brian C · Fort Worth, TXBuilt 2003 · S/N 2945 N630MNorman John · Fallon, NVBuilt 1993 · S/N 630 N6365ALeverton James F · Cannon Falls, MNBuilt 1999 · S/N SC1999CS N638EBCzerwinski Brian J · Oak Creek, WIBuilt 2004 · S/N 16403 N63988Lewis David S · Leechburg, PABuilt 2004 · S/N SS-013 N644NJThomas Jeff A · Havertown, PABuilt 2006 · S/N XT 582-0035 N648TCMcdonner Mark C · Zachary, LABuilt 2013 · S/N 1 N65087Registered aircraftBuilt 2000 · S/N 1065902 N65108Williamson Steve A · Smithton, ILBuilt 2002 · S/N A118SKY N6512BColeman Max E · Lancaster, CABuilt 2006 · S/N 0928 N65139Taylor Mason M · Slippery Rock, PAS/N 0002 N651TTBeard Don H · Hurley, MOBuilt 2011 · S/N 060308419 N65270Mudd Michael R · Owasso, OKBuilt 2002 · S/N A194-POW N65336Ritton Kevin W · Schenevus, NYBuilt 2000 · S/N HD00042M N6537TWilliamson Terry W · Pratt, KSS/N A016POW N6538LEnsinger Charles W · Elliottsburg, PABuilt 2007 · S/N 4778 N653KMMunn Kenneth D · Zephyr Cove, NVS/N 0001 N6552SEckart Bryan D · Hume, MOS/N A-011PEG N6557RBreunig Mark J · Sheboygan Falls, WIBuilt 1996 · S/N 3484 N6564TSturgill John C · Lexington, KYBuilt 2000 · S/N 5044 N6567BArnold David R · Ashland, KSBuilt 2007 · S/N IPP4232 N65797Funk Luke · Dallas Center, IABuilt 2002 · S/N 16256 N657JDDill James C · Fountain Inn, SCBuilt 2006 · S/N 582-659 N6581ZOrgass Howard J · Logan, NMBuilt 2003 · S/N 2818 N65838Dalis Charles J · Imler, PABuilt 2000 · S/N T00015 N65887Rock David A · Brighton, COBuilt 2003 · S/N A000PPC N65906Ppcruiser Inc · Wakarusa, KSBuilt 2007 · S/N A003PPC N6592CGraves Daniel J · Cookeville, TNBuilt 1993 · S/N HA-II-096-R583 N659DGUskoski Neal E · Brush Prairie, WABuilt 2004 · S/N LEGEND XL-2970 N6603RGough Terome Merril · Fairmount, INBuilt 2002 · S/N 16249 N66146Becht Richard · Crystal, MNS/N 16506 N6616ADixon Ronald G · Evans, WVBuilt 2003 · S/N A165 PEG N661MBFlying Signs LLC · Mesa, AZBuilt 2007 · S/N A442 PEG N6622XMalcolm Michael D · Cleveland, OHS/N 001 N662MBFlying Signs LLC · Mesa, AZBuilt 2007 · S/N 06.02/B04.11A N663AKShipman James A · Chugiak, AKBuilt 2001 · S/N 582663 N665JDDittmer John G · Cullom, ILS/N 5051

Back to Rotax 582SER