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.

N51722Leith Barry V · Cullman, ALS/N FS99400014 N51726Bill Robert R · Red Bluff, CABuilt 2003 · S/N 031351 RRB N5173JSnider Richard J · Trivoli, ILBuilt 2003 · S/N VA 0005 N517YRRobbins Michael Lee · Cambridge, MNBuilt 2015 · S/N 2202 N5180NCekinovich Ted Milan · Machesney Park, ILS/N 0703180 N518EECassavant Corey S · Milwaukee, WIBuilt 1990 · S/N 001 N521DKSignmaxx LLC · Larksville, PABuilt 1999 · S/N APHP0015 N522DWReed Joseph M · Vinita, OKS/N 001 N522PEJones Edwin A · Charlo, MTBuilt 2005 · S/N CH211941248 N523MHSchmalzel Douglass · Allenton, MIS/N 126 N5244AJohnston Richard A · Canton, GABuilt 1997 · S/N FS1204 N526DRDingmann Rebecca R · Missoula, MTS/N 123301007W1030 N52711Sharp Maurice D · Wakefield, KSBuilt 2008 · S/N CH2-1105-2695 N528PGHarmsworth Colin C · Jefferson, ORBuilt 2002 · S/N 503-719 N52PVAppell Dean J · Arlington, WABuilt 2008 · S/N 3043 N53GGFlahaut Douglas E · Rockland, WIS/N OD-001 N53RKWeber John · Leesburg, FLBuilt 2001 · S/N CH2-0298-B-1713 N53XYPero Wayne M · Redding, CABuilt 2009 · S/N 001 N540ZMMelin Carlyle A · Olathe, KSBuilt 2015 · S/N 050704 N543BWSimmons Lee S · Jackson, TNBuilt 2006 · S/N CH2-1005-Y-2685 N54EKKelly David W · Poplarville, MSBuilt 2002 · S/N 7802 N5509LNeary Thomas G · Godley, ILBuilt 1993 · S/N 93214 N5518LRiebesell Travis · Rockwood, MEBuilt 2000 · S/N 05313 N5518YMckoin Preston E · Homer, LABuilt 1998 · S/N 0395-0559 N552ELPryakhin Vladislav Y · Socorro, NMBuilt 2007 · S/N CH2-0903-CW-2378 N553FTSchroeder Derek D · Lincoln, NEBuilt 2021 · S/N 0215-CW-0808 N556CFFetters Christopher J · Ozark, MOS/N 001 N556TDHayes Stephen E · Saint Louis, MOBuilt 2000 · S/N 7760 N5596VNecker Brad G · Manchester, IABuilt 2005 · S/N 001 N5603UDaus Charles J · Imler, PAS/N GT2801322 N5611VBahr Donald G · Austin, TXBuilt 2001 · S/N CH2-1198-B-1800 N5615BSale Reported · Melba, IDSale reportedBuilt 1996 · S/N 254 N5622JCampbell Thomas C · Mexico, NYBuilt 2002 · S/N EX0207T N5624RHare Sammie Lee · Hernando, MSS/N CH204951320 N56345Porter Garrett E · Truckee, CABuilt 2007 · S/N 7734 N56419Berencsi Tibor C · Edison, NJBuilt 2002 · S/N BS100 N5664LDickert Christopher K · Evansville, WIBuilt 2002 · S/N SPORT 287 N56839Colstrup Dennis J · Albert Lea, MNBuilt 1996 · S/N C-9-94-1 N56920Dooley James L · Summit, MSBuilt 2004 · S/N F1247 N56968Blumie Thomas C · Jewett City, CTBuilt 1994 · S/N CH2-0694-1179 N5698LJolley John A · Covington, GABuilt 1995 · S/N 00112 N5698TAwad Ronald E · Indian Land, SCBuilt 2004 · S/N 8378 N56CRRedden James H · Strunk, KYBuilt 2007 · S/N 30 N5721NThomas Keith Douglas · Andersonville, GABuilt 2025 · S/N 1004 N574LTMann David · Richland, MSBuilt 1997 · S/N 123042 N579RFSteiger Robert A Jr · Paxton, ILBuilt 2000 · S/N 001 N580DCJacobson Joel T · Wilderville, ORBuilt 1994 · S/N 216 N585UGregersen Michael R · Blackfoot, IDFirst renewal noticeBuilt 1994 · S/N T94503SOHF0103 N586BAIsaac Andrew L · Hammett, IDBuilt 2019 · S/N 575 N589SDWalther Frank C · Greenwood, SCBuilt 1999 · S/N 7578

Back to Rotax 503 DCDI