Skip to content

Rotax SEE BOMBADIER

Registered aircraft · 710

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

N10027Tinkham Michael D · Kirkwood, ILBuilt 1996 · S/N 1295910ES N10037Braught Eldin V · Sand Springs, OKBuilt 1991 · S/N 0790-132 B N1005AValentine James F Jr · Cary, NCS/N 05-039 N100MGFaust Kevin C · Long Prairie, MNBuilt 2011 · S/N 1210550 N10120Stoll William J · Greenleaf, WIBuilt 2006 · S/N 10051701 N1014PWoods Monroe E · Shidler, OKBuilt 2001 · S/N L0109-110 N1017QOwens David R · Benson, AZBuilt 2006 · S/N 06041585 N1017WShook Daniel R · Spring Mills, PABuilt 1993 · S/N 01005 N101XLBarnhart David L · Pensacola, FLBuilt 1997 · S/N GCX-010 N101XXMurray Mark J · Georgetown, GABuilt 2004 · S/N CH2-0604-2482 N10260Taylor Raymond D · Doniphan, MOBuilt 2002 · S/N CH2-1202-2283 N102YBMcbean John B · Homedale, IDBuilt 2003 · S/N S60101051 N10315Porteous Kyle · Elverta, CABuilt 2005 · S/N 001 N103ESForester Dwain · Royal City, WABuilt 2005 · S/N 7-9728 N103GERam Beacon LLC · Lake Bluff, ILBuilt 2003 · S/N 60111-066 N103TSKilbarger Shawn R · Jamestown, OHBuilt 1992 · S/N M3/003 N104DWCoons Steve J · Rushville, MOS/N CH2-0804-2511 N104KKHalmon Henry W · Manvel, TXS/N KKFS-438 N104SBSpader Michael W · Pt Pleas Bch, NJBuilt 2004 · S/N CH2-0704-2498 N1058CPoehlein Steven E · Mcleansville, NCS/N AGA222 N1064HAmesbury Connor H · Valley Springs, CABuilt 2001 · S/N SA-26SS-007 N106THMorgan Anthony R · Groveoak, ALBuilt 2003 · S/N 10000928 N106TRHill Joann · San Antonio, NMBuilt 2011 · S/N 08081896 N10798Russell Robert Q · Genoa City, WIBuilt 2002 · S/N 01540 N107DKHobbs Kevin J · Minooka, ILBuilt 2004 · S/N 09001386 N107JLNowlin Rick D · Goodyear, AZBuilt 2005 · S/N 05020945 N107TUMaceo David Matos · Sebring, FLBuilt 2005 · S/N 135 N107WWMile-High Enterprises LLC · Wilmington, DEBuilt 2005 · S/N 05-07-01 N108MDBryant Heath W · Collinsville, ALBuilt 2003 · S/N 1200192 N108TMMolano Gonzalo A · Marana, AZS/N 013 N109LSSpann William J · Dothan, ALS/N 054 N109WBHalpin James F · Marengo, OHS/N CH2-0504-2479 N10NHDaughenbaugh Randall J · Rapid City, SDBuilt 2004 · S/N S9909 0214 N10VXGrant Paul · Meridian, IDBuilt 2005 · S/N 06041592 N1100PAnderson Gerald D · Two Harbors, MNBuilt 2002 · S/N 0396145 N1101RReinhardt Robert N · College Station, TXBuilt 2011 · S/N 1LK-528C N114JWSliko Terence M · Plant City, FLBuilt 2004 · S/N CH2-0295-1285 N115BESchwartz Kenneth G · Lincoln, CAS/N 02030960 N115BTRhoades Rick D · Portageville, MOBuilt 2005 · S/N CH2-01961436 N115EPLehto Esa O · Southlake, TXBuilt 2003 · S/N 411 N1164MClark Richard M Jr · Eden Prairie, MNBuilt 2003 · S/N 1752 N1169DGohlke William J Trustee · Mountain Home, ARS/N 1169D N116JAPuryear Christopher · Wilmington, NCBuilt 2003 · S/N JAESC0001 N11739Mclead Leonard D · Blounts Creek, NCBuilt 2002 · S/N CH2-0395-1308 N117AFRowcliffe William A · Basehor, KSBuilt 1998 · S/N 117 N117YZDu Toit Carel Andre · Stanley, NCBuilt 2002 · S/N 05960728 N118TFZacherl Randall L · Indiana, PABuilt 1996 · S/N AB118 N119CKCilliers Carlo R · Frederick, MDBuilt 2004 · S/N AC0100 N119MRPiroli Robert R · Poplar Bluff, MOBuilt 2004 · S/N CH2-0802-2253 N122JVBishop Andre · Greenback, TNBuilt 2004 · S/N 04-11-06

Back to Rotax SEE BOMBADIER