Skip to content

Registered aircraft · 24

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

N107SMDierker Robert R · Chestertown, MDBuilt 2006 · S/N 14010906 N165ZXWingfield Larry T · North Lewisburg, OHBuilt 2001 · S/N 000515 N168RCCudaback Jack L · Omaha, NEBuilt 1999 · S/N 98267 N17XDRollins David M · Martinsville, INBuilt 1999 · S/N 7357 N2097KThompson Gregory G · Denison, TXBuilt 2005 · S/N WA 1115 N2657ELeone Marc J · Wofford Heights, CAS/N 44218 N2672ACrowe Brian T · Saunemin, ILBuilt 2007 · S/N 0812 N3165WBell Charles W Jr · Edison, NJBuilt 1997 · S/N A10CWB N333RCPuckett Eugene A · Phoenix, AZBuilt 2007 · S/N T92503COHK0035 N368MPAndreotta Robert M · Fulton, NYBuilt 2009 · S/N CH2-0407-LSS-0127 N3840GLittle Keene H · Sandpoint, IDBuilt 2009 · S/N CH2-1005-2691 N42CEErickson Clarence B III · Shreveport, LABuilt 2007 · S/N 019T 503 1007 N4473GAllen Jeffery E · Jacksonville, FLBuilt 2003 · S/N 1400 N4854KDoughty Stuart R · Fayetteville, ARBuilt 2005 · S/N CH206032327 N5025VBush Bryan P · Cleghorn, IABuilt 2008 · S/N 1-2564 N503WTWilson John Burttrum III · Round Rock, TXBuilt 2006 · S/N 503:1055 N546FLBeckens Scott A · Sodus, NYBuilt 2002 · S/N 2002 100FC N61086Rateau Claude · Santa Maria, CABuilt 1998 · S/N CH2-0796-1509 N702KWWelch William R · Navajo Dam, NMBuilt 2014 · S/N 01 N702SWFrost Charles R · Mina, NVBuilt 1992 · S/N SPRINT II 345 N9066JGraham Jr Richard A · Colorado Springs, COBuilt 2002 · S/N T02053 N9113TKinsinger Jason Jay · Oakland, MDS/N 0105-CW-0795 N9146ZCauvin John R · Carefree, AZBuilt 2004 · S/N T04033 N923KPPorter Kerry · Oakley, CABuilt 2016 · S/N 156 T 503 LSA

Back to Rotax 503UL