Skip to content

Registered aircraft · 561

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

N1701BKedish Kirk · Helena, MTBuilt 2007 · S/N 1107 N171DAAddison Don C · Greenville, ALBuilt 1995 · S/N 300 N173CFMurphy Robert L · Morristown, TNBuilt 1995 · S/N 96-1367-2 N1758CKay Michael B · Green Bay, WIBuilt 2007 · S/N CH2-1104-2546 N176CBBush Shannon C · Abbeville, ALBuilt 1994 · S/N CH20694H76 N177RMHillger Mike D · Garden City, TXBuilt 1991 · S/N 9001 N1780CBonkowski David J · Portland, ORBuilt 2004 · S/N 22 N179RDDooley Rhett A · Brush, COBuilt 2004 · S/N 001 N17JXGilkey Jeffrey C · Albuquerque, NMBuilt 2004 · S/N C071 N182EZHammond Robert · North Attleboro, MABuilt 1997 · S/N FS 645 N183SWCasey Jeremy R · Phenix City, ALBuilt 1997 · S/N CH2-0697-1619 N1847Ranson Andrew Wyatt · Tacoma, WABuilt 2002 · S/N 503/728 N184CTMoore Steven J · Lakewood, COBuilt 2000 · S/N 001 N1864LGafford Brian A · Lewis Center, OHBuilt 2015 · S/N 1001 N1872CKokkinos Haralabos · Saugus, CABuilt 1998 · S/N 4339396 N1874MAnderson William Henry · Holt, FLS/N CH2-2240 N187EJHanna Ryan D · Berthold, NDBuilt 2001 · S/N CH2-0301-2059 N18VESky Knights Flight Club · Thousand Oaks, CABuilt 2003 · S/N 000550 N18XDCasciola Dean E · Burlington, MABuilt 2013 · S/N CH2-1010-2885 N190PCUltra Flight LLC · Le Mars, IABuilt 1996 · S/N CH2-1094-R-1231 N191PDDeland Research Corp · Deland, FLS/N SR074 N191SCBartholomew John Davis · Medford, ORBuilt 2007 · S/N 3068 N1948RWilliams Darian J · Hazard, KYBuilt 2007 · S/N CH2-1003-2391 N1974LLaplante Bryan D · Montello, WIBuilt 2006 · S/N CH2-1005-CW-2690 N197AHarvey John A · Nashville, TNBuilt 2001 · S/N 001 N197ABOstler Harold · Omaha, NEBuilt 2000 · S/N CH2-300-1956 N202FSTirko Terry J · Wellsville, PABuilt 1998 · S/N 201 N203CBLuptowski Joseph M · Hudsonville, MIS/N CH20987B0271 N203MGHuffine Kenneth B · Gardena, CABuilt 1999 · S/N 1196-1533 N203SDRegistration Pending · Clermont, FLRegistration pendingBuilt 2007 · S/N F1237 N2040DMarcks Philip C · Shawano, WIBuilt 1998 · S/N 4098 N204PKNill Robert M · Grandfield, OKBuilt 1996 · S/N CH2-0398-1724 N2055SGraves David A · Crothersville, INBuilt 2007 · S/N 0001-2007 N207XPWinter Kenneth L · Tazewell, TNBuilt 1985 · S/N 2077 N2090ABingham Joe R · Delta, COS/N 1256 N2091JCarvalho Nelson H · Sevierville, TNBuilt 2003 · S/N 1942 N21388Dewanz Daniel · Cannon Falls, MNBuilt 2000 · S/N F1229 N213FWWalker Frederick C · Fort Wayne, INBuilt 2012 · S/N RWS5213 N213JBForce Gary S · Granbury, TXBuilt 2005 · S/N D04XXXCOHK0475 N2145WWalker Craig C · Indian, AKBuilt 2002 · S/N 187 N214TRNeuharth Timothy E · Courtland, CABuilt 2008 · S/N CH2-0405-2623 N2157Schams Gregory P · Mchenry, ILBuilt 2000 · S/N 2157 N217BESchuck Robert A · Elyria, OHBuilt 2000 · S/N BE001 N219CNCastro Leonardo · Carolina, PRFirst renewal noticeS/N 2618 N21PRPeck Nathan M · Leavenworth, KSS/N 0130 N222CHGnd Efeckt Llp · Cairo, NES/N CH2-0701-2118 N228BTDeleon-Quinones Denis Jose · Florida, PRS/N FS120 N229KGray Mark F · Macomb, MIBuilt 2007 · S/N F1086 N22HKKulp Earl F Jr · Marion, NCBuilt 2002 · S/N H-8-346-R-503 N231TADenoyer Mark A · Phoenix, AZBuilt 2012 · S/N CH2 0394 CW 1129

Back to Rotax 503 DCDI