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.

N877MWWindschitl Mike G · Comfrey, MNBuilt 2010 · S/N CH2-0104-R-2417 N878DWRiemer Edward L · Bakersfield, CABuilt 1994 · S/N T94503CAZK0104 N878VBNordlander Eric G · Ridgway, COBuilt 2015 · S/N CH2-0510-2878 N87MZZabel Mark G · New London, WIBuilt 1999 · S/N 005923 N881KHendrickson Keith D · Caldwell, IDBuilt 2005 · S/N 298 N886SEichmann Richard W · Paulden, AZS/N 001 N898NTTaylor Gregory S · Beaver, OHBuilt 2021 · S/N 320657 N899RDDunn Larry W · Benton City, MOBuilt 2004 · S/N CH2-0804-2516 N9034HHummel Dennis K · Fairdealing, MOBuilt 2000 · S/N CH2-0700-1986 N905GFGrant Finley J · Moses Lake, WABuilt 2011 · S/N 001-052011 N9062UNeuman Michael R · Valencia, PABuilt 1992 · S/N 21492 N90779Heil William J · Marathon, WIS/N 796 N9088GCody Rodney W · Spring Creek, NVBuilt 1998 · S/N 2005 N9092NSteenholdt Terry · Sioux Falls, SDBuilt 2006 · S/N JVC 0110 N909DSSepulveda Daniel R · Hormigueros, PRBuilt 2013 · S/N 05041569 N911ULHeimbuch Russell D · Moorhead, MNS/N 403 N9128YWoodhouse Russell D · Franklin, INBuilt 1997 · S/N 464301A N9132VDigel-Barrett Roger · Etna, OHBuilt 2007 · S/N CH2-0204-2445 N913WWGilbert Kent G · Brookshire, TXBuilt 1999 · S/N 378 N919KHDetloff Robert L · Tieton, WABuilt 2001 · S/N 001 N92076Mceachran Frank W · Marshall, ILBuilt 2007 · S/N 1948FWM N92310Smith Lucius C · Homerville, GABuilt 1993 · S/N FS1003 N9237EPreston Jeffrey · Unadilla, GABuilt 1992 · S/N CH2 0292 0826 N9237NMurray Mark J · Georgetown, GABuilt 1991 · S/N CH2 0891 CW0719 N923FADahlstrom Scott J · Greenville, OHBuilt 2013 · S/N CH-2-0202-2193 N924PJBowden Mark H · Brownsboro, ALBuilt 2006 · S/N CH2-1103-2399 N929YEHayes William U · Pinson, ALBuilt 2007 · S/N 00001 N93106Hladilek Anthony T F · Cadott, WIBuilt 2021 · S/N 001 N9321ROsher Terry G · Wallingford, IABuilt 2007 · S/N 1213 N93331Kistler Cory S · Colby, KSBuilt 2007 · S/N SS-022 N935EHJensen Layne C · Thatcher, AZS/N CH2-0101-2052 N935FSStier Fred A · Antioch, TNBuilt 1999 · S/N 1002 N9381MWroe Daniel C · Ridgely, MDBuilt 2006 · S/N 001 N939WTSimpson Benjamin A Jr · Whitman, NEBuilt 2010 · S/N 43010 N93JBBanks John J · Anchorage, AKBuilt 1998 · S/N 5124 N9434FReynolds Cheryl L · Union, SCBuilt 2000 · S/N CH208001990 N94436Roy Roland Paul · Lewiston, MEBuilt 1999 · S/N 123 N945RJMasters David B · Fairbanks, AKBuilt 2015 · S/N CH2-0704-2499 N94630Donahoo Gary Wayne · Reeves, LAS/N CH2 1001 2140 N9473YBeckley Larry · Scottsburg, INBuilt 1995 · S/N 11KUC N947BXBertling Courtney · Wilsonville, ORBuilt 2020 · S/N 001 N949UXDifferent Auto LLC · Twin Falls, IDBuilt 1992 · S/N CH2 1192 0806 N95054Fly Ppc LLC · Bountiful, UTBuilt 1996 · S/N 96-1529-2 N9511PCessna 20420 Holding LLC · Philadelphia, PAFirst renewal noticeS/N 00053 N951GLLinzmayer George J · Saint Cloud, FLBuilt 1987 · S/N B1B 417 503 N95352Unger Michael L · Chambersburg, PABuilt 2002 · S/N CH2-1201-2157 N95386Weder William C · Saint Jacob, ILBuilt 2000 · S/N 153 N953HPPerkins Howard · Jenks, OKBuilt 2015 · S/N 0892040 N9546JWeill Eric N · Hattiesburg, MSBuilt 2006 · S/N 000 586 N9556QMoore Dennis R · Swan Point, MDBuilt 1995 · S/N 950996

Back to Rotax 503 DCDI