Skip to content

Registered aircraft · 1,193

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.

N70910Mozingo John C · Winterville, NCBuilt 2001 · S/N 246 N7096TBowers Gary · Mount Airy, NCBuilt 1998 · S/N B21274 N709VTenpas Mark H · Chicago, ILBuilt 2000 · S/N EX-469 N70NAMears Johnny G · Laurinburg, NCBuilt 2006 · S/N 3C0426 N7116JBone Mark W · Monticello, IABuilt 1998 · S/N 1017631 N711ULLefevre Jerry D · Beaumont, CABuilt 2003 · S/N 0067 N7122PKroft John B · Glade Park, COBuilt 2006 · S/N 3048 N7122XBrandt Mark A · Bradford, OHBuilt 2002 · S/N 6045 N7123VAutrey Randy D · Bethel, MEBuilt 1998 · S/N 98-2073-SR7XL N7132LFitzsimmons Anthony · Conway, NHBuilt 2000 · S/N 2850 N713BFMccurdy Prescott E · Harpswell, MEBuilt 1998 · S/N 4272 N713JJFinishline Motors · Colorado Springs, COBuilt 2001 · S/N DO1582SOHF0401 N713KWWade Kenneth L · Huron, TNBuilt 2011 · S/N CH2-1108-2854 N713SLNoah Jeremy L · Brookville, INBuilt 2015 · S/N SLS-1501 N71418Johnk Ethan J · Donalds, SCBuilt 1991 · S/N 270 N7154BCastle Jonathon Blake · Gate City, VABuilt 2000 · S/N 2570 N715ATAir-Tech Inc · Reserve, LABuilt 2006 · S/N 0086 N715PMThomas Clarence D · Heyworth, ILBuilt 1995 · S/N 3334 N7176JLangley Gary W · Georgetown, INBuilt 2000 · S/N 1B0183 N717GBStyer David L · Mount Gilead, OHBuilt 1991 · S/N PFA 172-11773 N7191HLong Richard D · Kelseyville, CABuilt 1990 · S/N 0048 N7193WBrumbaugh Wayne · Peru, INS/N 16355 N71SJJoyner Spencer A Jr · Moultonborough, NHBuilt 2000 · S/N T00027 N721KBBrandon Stephen R · Livermore, CABuilt 1998 · S/N 4085 N7228CTonjes Kevin L · Bancroft, NEBuilt 2005 · S/N SR7DE-2971 N727GJWolf Donald J · Mulberry, FLS/N KLM003 N727WPAttaway Lauren C · North Las Vegas, NVBuilt 2004 · S/N 001 N7285CSnyder Molly M · Wernersville, PAS/N W123040PPC N728ACCarpenter Andrew J · Columbus Junction, IABuilt 2013 · S/N 7-6261 N729MPRichardson William S · Shelbyville, INBuilt 1999 · S/N 4568 N730PHGwyn Zachary J · Winston Salem, NCBuilt 2007 · S/N 001 N7311CKennicutt Herman David · Coweta, OKBuilt 2002 · S/N A14CBW N733TCrail Aviation LLC · Colorado Springs, COBuilt 2002 · S/N 11 N737RSStropes Ray E · Chilhowee, MOBuilt 2008 · S/N 1289073-2 N739ACRichard A Pierce And Associates LLC · North Conway, NHBuilt 2000 · S/N 699 N739BBohbrink Clark G · Brownsburg, INBuilt 2007 · S/N 104 N7420CGrooms Nick L · Drakesville, IABuilt 2001 · S/N 3096 N7424SIdent LLC · Prescott, AZBuilt 2013 · S/N 0458 N746FLHowell Jeannet D · Orlando, FLBuilt 2001 · S/N A99024-9014 N747AZDroter Bert E · Chester, MDBuilt 1997 · S/N SWJ582499006 N747MFFish Michael F X · Severna Park, MDFirst renewal noticeBuilt 2000 · S/N ZYPFBOLPH101 N747SRKaspar Russell B · Frankfort, INBuilt 2003 · S/N A163PEG N75087Chicoine Timothy E · Carl Junction, MOBuilt 2002 · S/N A018 PEG N7509UBrown Robert J Jr · Nekoosa, WIS/N 0039 N75101Harris Jeff M · Ashdown, ARBuilt 2006 · S/N 582-524 N7510LFulton Daniel M · Blacksburg, SCBuilt 2006 · S/N 002 N7511NKortens William J · Black Creek, WIBuilt 2003 · S/N SPORT 2S 0076 N7511XKieffer William A · Chillicothe, MOBuilt 2006 · S/N WOH 1948 N7512HJolly Nicholas B · Inman, SCBuilt 2006 · S/N A10LSB N7513GDrake Air LLC · Shelbyville, INS/N 1B0033

Back to Rotax 582SER