Skip to content

Registered aircraft · 1,192

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

N100FYKnop Donald L · Vernal, UTS/N 1187C0234 N100ZXBraxton Flying Club · Sutton, WVS/N 002 N1013BCarkenord Kirk E · Pharr, TXS/N A016AAF N102HKBuchholz William C · Saint Charles, MOBuilt 2007 · S/N HAII-311-R582-TRL N102SCGood John S · Lancaster, PABuilt 2010 · S/N 3106 N102STEaton Stacey L · Toquerville, UTBuilt 2010 · S/N PE6539999A N103DAAllen Dallas R · Plant City, FLBuilt 2002 · S/N 3086 N103FUOvermier Timothy G · Independence, LABuilt 2009 · S/N PC5110631 N103RPRugged Country Helicopters LLC · Cedar City, UTS/N 1953 N104KBKnsuboski Joshua T · Montello, WIBuilt 2014 · S/N MK 114 N10532Tabers William B Jr · Whitleyville, TNBuilt 2010 · S/N 04-006 N105KWHenson Wayne E · Springfield, ILBuilt 2003 · S/N WKG0007 N105TRAndrews Kevin M · Hermitage, TNS/N IPP5-311 N106PFFarina Paul · Liberty Twp, OHBuilt 2015 · S/N C-1389 N1070DHansen David B · Wichita, KSBuilt 2004 · S/N CO 98 N109BDHowell Aviation LLC · Orlando, FLBuilt 2013 · S/N TTA-56 N109HMSale Reported · North Tonawanda, NYSale reportedBuilt 1990 · S/N 65 N109PGCarkenord Aric L · Pharr, TXBuilt 2003 · S/N A109PEG N110SRRyer Michael · Salem, ORBuilt 2014 · S/N MR-R-S9-001 N110ULFeemster John R · Saratoga, CABuilt 1992 · S/N 310 N112DLLightair LLC · Timnath, COBuilt 2001 · S/N 001 N112SWTroy Thomas S · Westminster, COBuilt 1996 · S/N 001 N11582Wolff Albert J · Bonners Ferry, IDBuilt 2013 · S/N 11023 N116GJCruse Donald A · Minerva, OHBuilt 2011 · S/N 0093 N116LGBlake Oley H · Harrison, TNBuilt 2002 · S/N T01119 N116RFFosdick Richard A · Bunker Hill, WVBuilt 1998 · S/N X.S. 007-98 N1189GDurden Joseph Wayne · Mobile, ALBuilt 2005 · S/N 000701 N118ANGregory David R · Shingletown, CABuilt 2001 · S/N T02071 N118EWSchraek Eric W · Naples, FLBuilt 2001 · S/N T01025 N119SEWilliams Conley B · Duffield, VAS/N 4636 N119WMBartu Leroy Richard · Pocatello, IDBuilt 1999 · S/N 0007 N11LUHickox Daniel J · Austin, TXBuilt 2012 · S/N 450 N11ZBGoodman Donald L Jr · Saint Joseph, MOBuilt 2004 · S/N 29048 N120WDApanovitch Joseph · Medina, OHBuilt 2014 · S/N SR72014 N121HMSill David E · New Era, MIS/N 105 N122LKEnsey Craig S · Albany, ORBuilt 2018 · S/N 11960764 N124LPColon Roberto · Mayaguez, PRBuilt 2009 · S/N 06061007 N125ATBurk Corey A · Prescott Valley, AZBuilt 1998 · S/N 033099 N125GLLewis Gregory G · Saratoga Springs, UTBuilt 2006 · S/N 001 N125TYBuchanan Guy E · Ramona, CABuilt 2006 · S/N HCU089 N1287BHaley Ronnie G · Poolville, TXBuilt 2002 · S/N 6144 N128GKKowitz Glen G · Moose Lake, MNBuilt 2012 · S/N 001 N1299WMyers Joey M · Fairfield, CABuilt 1999 · S/N 99-2324SR7XL N1317LMason Craig · Austin, TXS/N AP2A0009 N131GWLongshore George W II · Davenport, FLBuilt 1983 · S/N DR0016 N132LSDeckard Jerry E · Neelyville, MOBuilt 2004 · S/N 03030966 N133EZHay Thomas E · Burien, WAS/N 001 N1370RJohnson Robert E · Blanco, TXBuilt 2005 · S/N 3021 N139AHUskoski Axel E · Moorcroft, WYS/N 244 N139DTRoyal Scott A · Richmond, MEBuilt 1998 · S/N 4277

Back to Rotax 582SER