Skip to content

Registered aircraft · 578

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

N452AFJohnson Richard H · Plattsburgh, NYBuilt 2005 · S/N SPIRIT XL2342 N4546AYarber Robert B III · Redford, MIBuilt 2005 · S/N 0024 N456AVNegron Alvin · San Juan, PRBuilt 2006 · S/N SKR0606719 N458FPKesey Monte J · Monahans, TXBuilt 2011 · S/N A495PEG N463PCHuber Nace · Simpsonville, KYBuilt 2005 · S/N BSX463 N465XCGrace Michael · Waynesville, OHBuilt 2004 · S/N HD04134M N466AFPace Edgar A · Pinnacle, NCBuilt 2002 · S/N 00106 N469ZLLamb Terry A · Temperance, MIBuilt 2012 · S/N 0271 N471PBeacon International Inc · Dover, DEBuilt 2004 · S/N 1002634 N4732FJenkins Michael L · Tonopah, AZBuilt 2002 · S/N T-BIRD II-2002-R582-E-TRI N4758TBarnes Cecil M · Fort Madison, IABuilt 2000 · S/N 1B0059 N47FBTeasdale Frederic A · Meadville, PABuilt 2020 · S/N 001 N480LGMeier George D · Wichita, KSBuilt 2012 · S/N 1278JG N4813FBuffalo Ridge Airsports LLC · Forest, VABuilt 1999 · S/N 002 N4829EHarris John L · Alamogordo, NMFirst renewal noticeBuilt 2000 · S/N 1B0112 N482VXBetke Hendrik C · Wyoming, MIBuilt 2013 · S/N CH2-1108-2853 N4830TRosen Maurice D · East Wenatchee, WABuilt 2004 · S/N IPP4-261 N487TPZimmerman Bruce · Pierce, NEBuilt 2012 · S/N A503PEG N48PTTischner Roger D · Kensington, KSBuilt 2017 · S/N 1264D N4907ETaber Matthew A · Rising Fawn, GABuilt 2002 · S/N 032954 N491XPReiger David T · Zephyr, TXBuilt 2013 · S/N A504PEG N499KCStalcup David S · Mandeville, LABuilt 2001 · S/N A-069 N499PCBolen Arthur Dale · Flushing, OHBuilt 2000 · S/N 4936 N49FPBouwmeester Hendrikus P · South Haven, MIS/N 80207 N49FUHudson Jeffrey A · Sebring, FLBuilt 1995 · S/N 1195 N50204Griner Dale · Anchor Point, AKBuilt 2006 · S/N IPP6-331 N50313Manning Donald G Jr · Mishawaka, INS/N 1B0105 N50344Darnell Gary · Church Hill, TNBuilt 2003 · S/N 16397 N5039STalbott Walter B · Rochester, INBuilt 1997 · S/N 3672 N5041TBecker Shawn W · Kampsville, ILBuilt 2003 · S/N 16320 N5052UFinney Dean C · Fall Branch, TNBuilt 2002 · S/N 0505 N5055LJamesson Michael J · Sparta, WIBuilt 2005 · S/N 707694 N5061Lucas Gregory A · Smiths Grove, KYS/N 22-2001 N50622Anderson Eric G · Lebanon, MEBuilt 1993 · S/N 001 N50668Berg John D · Tulsa, OKBuilt 2002 · S/N 2816 N5080PBrinkmann Farms Inc · Carlyle, ILBuilt 2002 · S/N 3C0519 N50831Graf David R · Oakdale, MNS/N 420 N50860Tatro Jack M · Momence, ILBuilt 2001 · S/N 1B0076 N5098KOliver Theodore M · Waukesha, WIBuilt 2006 · S/N 0957 N51054Eidman Donal J · Strong City, KSBuilt 2004 · S/N A-316-PEG N5109VTuskegee Airmen National Historical Museum Inc · Detroit, MIBuilt 2001 · S/N 001 N5112FWall Les A · Heber Springs, ARBuilt 2000 · S/N 5008 N511RCCox Rodney J · Haven, KSBuilt 2001 · S/N A86POW N51241Schmidt Richard L · Mount Morris, ILBuilt 2002 · S/N 007 N5126MDick Ronald J · Fort Wayne, INBuilt 2005 · S/N TUPO223 N512BEZmich Robert M · Canton, GAS/N 0077 N512HSKielar Richard W · Riverton, UTS/N 582-674 N51344Herschberger Glen R · Iola, KSBuilt 1998 · S/N 4229 N51404Hickox Daniel J · Austin, TXBuilt 2007 · S/N USA270406 N5142JBunton Michael F · Lamar, MOBuilt 1992 · S/N 0192253

Back to Rotax 582DCDI