Skip to content

Bombardier ROTAX (ALL)

Registered aircraft · 1,875

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

N100GBKlemp Gregory J Sr · Neshkoro, WIBuilt 1993 · S/N CW0844 N100MFHensel James D · Pembine, WIBuilt 1998 · S/N 051 N10115Western Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1991 · S/N 3 N1014CEjw LLC · Ammon, IDBuilt 2005 · S/N F 150605 LSA N101ABMoore Wayne · Vaughan, MSBuilt 1991 · S/N M3-011 N101EHWashburn Jeffery T · Dresden, TNS/N 0782 N1021VPerkins Brian W · Richland Center, WIS/N CH2-0300-1958 N1024GShenk Ray Daryl · Newmanstown, PABuilt 2003 · S/N 3132 N1024WSmith Alexander B III · Waxahachie, TXS/N 1943 N1029GGiroux Guy M · Topeka, KSBuilt 2001 · S/N AC-060 N1029WNeidig Joseph D · Wadesville, INBuilt 2006 · S/N 5031496 N102DFLe Garrett P · Exeter, CAS/N 10029 N102DGSnowball Joseph L · Fort Wayne, INBuilt 1993 · S/N 1735 N102EYRochette Marc A · Fort Meade, FLBuilt 1997 · S/N 05960728 N102KMSkulking Kitfoxes LLC · Saint George, UTBuilt 1993 · S/N 1702 N102LGBaker Eric M · Loveland, COS/N 1745 N102TKHowlett Randy · Basehor, KSBuilt 1992 · S/N CH 20392B0834 N102TSJabl LLC · Princeton, MNBuilt 1998 · S/N C95080123 N102WWGrubb Gary V · Buffalo, WYBuilt 1989 · S/N 63 N1038ZArnold Frank S · Opelika, ALS/N 582-811 N103CHYork Brandon D · Harrison, ARS/N CH2-1296-CW-1543 N103EDPayton Michael R · Magnolia, KYS/N 1029 N103GMSandoval Jimmy · Lehi, UTS/N 1824 N103LFerrin Lonnie D · Houston, TXBuilt 2001 · S/N A-AWI-012300-86-R503 N103TMWroe Daniel C · Denton, MDBuilt 1984 · S/N 1037 N103WMWeber John H · Leesburg, FLS/N 089099 N1043NHall Larry D · Conesus, NYS/N C072 N104DGSkulking Kitfoxes LLC · St George, UTBuilt 1995 · S/N LCS146 N104GSWells Paul D · Crowley, TXBuilt 2002 · S/N RR582 N104SEHunter S R · Gillette, WYBuilt 1998 · S/N 05971122 N104SHHutson Scott · Walla Walla, WABuilt 1996 · S/N 1002 N105SHLombardos Albert Jr · Leesburg, VAS/N 1091144 N106DWStone Mitchel R · Santa Paula, CABuilt 1998 · S/N 0395785ES N106WMDoyle Wayne S · Severance, COS/N 1405 N10780Sabbin John L · Dent, MNBuilt 2002 · S/N CH2-1201-2155 N107DWCowden Gary · Lynchburg, VABuilt 1995 · S/N 0295083 N10807Castleberry Don P · Boise, IDBuilt 1996 · S/N D95912SOHK0167 N1081FBell B Allan · Coalville, UTBuilt 2002 · S/N 11001398ES N108APSchoen Ronald K · Elizabeth, INBuilt 1982 · S/N 3599 N108BBButler Blake B · Shelbyville, TNBuilt 1989 · S/N 206 N108DSBade John W · Pahrump, NVS/N 1233D N108HKeller Michael W · Lancaster, PABuilt 1993 · S/N 1555 N108KXYancy Kurtis A · Klamath Falls, ORS/N 1908 N108NBLocke-Paddon Kenneth · Watsonville, CABuilt 1994 · S/N CCS108 N1095Schuler Kenneth E · Kiel, WIBuilt 1996 · S/N 1095882S N1095JFerris Gregory M · Muscatine, IABuilt 2002 · S/N 6-3793 N109BBTronier Paul C · Sparks, NVBuilt 1994 · S/N 1719 N109MKKraeger Mark · Poland, NYS/N CH202910643 N10DZZank Don G · Bloomer, WIBuilt 1989 · S/N 0403 N10FRTyler Hugh C · Chico, CABuilt 1991 · S/N 022

Back to Bombardier ROTAX (ALL)