Skip to content

Registered aircraft · 135

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

N101DZNorth Matthew E · Tucson, AZS/N ULFF029 N101SJYant David J · Freeland, MIBuilt 2017 · S/N DJY003 N105MVFly Virginia Beach Inc · Chesapeake, VABuilt 2002 · S/N 001 N106BEAbrosius John E · Tellico Plains, TNBuilt 2000 · S/N 1612 N120WSShippee William S · Lake City, FLBuilt 2007 · S/N SPORT 271 N122HMSill David E · New Era, MIBuilt 2006 · S/N 1 N154MBRandall Howard A · Belvidere, ILBuilt 1995 · S/N 02950542 N15GBBergby Steinar L · Pleasanton, KSBuilt 2007 · S/N A042M16 N165WBBaier Warren R · Horicon, WIBuilt 1997 · S/N 97 N167ABBurrows William G · Reno, NVBuilt 1989 · S/N 8901125 N1759Sale Reported · Athol, IDSale reportedBuilt 1995 · S/N 794 N1843CBeins D Ross · Aurora, NEBuilt 2008 · S/N FS0801 N198PRThornton Shawn W · Cheyenne, WYBuilt 2023 · S/N FS-14-4-00096 N213ATAbreu Orlando · Adjuntas, PRS/N 244 N2167ZMintkenbaugh Russell R · West Chester, OHBuilt 2007 · S/N RM1955 N225SSMillsap Steven M · Lander, WYBuilt 2000 · S/N 326 N2353SLawrence Brant E · Paulden, AZS/N J O #1 N243YAMcclurkan Phillip Andrew · Bush, LABuilt 2025 · S/N 001 N245AKruse Larry G · Ankeny, IABuilt 1994 · S/N 001 N2483UDepaolis Michael A · Rochester, PABuilt 2005 · S/N H-SSCU-923-R447-TRI N2483WSteinbrecher Josh · Pulaski, WIBuilt 1990 · S/N 90129 N2490POltermann Steven H · Oklahoma City, OKBuilt 2001 · S/N 434670 N2550ALowery Derrick L · Wildwood, GABuilt 2003 · S/N M5161764 N2635EPeach Christopher G · Waterville, MNBuilt 1986 · S/N CGP 001 N263ABWood Virgil W · Webb City, MOBuilt 1994 · S/N AB22 N2651TVarilek Jerry L · Lamar, NEBuilt 1984 · S/N 2-17-48 N2668NMoeser Alan J · Bensalem, PABuilt 1998 · S/N DS102 N267MMBlue Todd I · Albuquerque, NMBuilt 1992 · S/N 267 N2687WBaker Steven E · Springfield, ORBuilt 2007 · S/N 173 N2706BSnyder Dalton D · Toulon, ILS/N CH1-1102-0779 N2729RNeal Clarence K · Harahan, LABuilt 2005 · S/N 4117 N2781AMiller Danny D · Pleasant Hill, MOBuilt 1995 · S/N 6907 N281DHillard Dan J · Minnetonka, MNBuilt 2006 · S/N L.F.001 N2917ALarson Charles D · Belvidere, ILS/N 0586-B-0199 N293RAArndt Steven R · Concord, NHBuilt 2007 · S/N 001 N299JFDavis John W · Bishopville, SCBuilt 1995 · S/N 749-95 N301DWBaylor David S · Meridian, IDS/N GT2801093 N314PVOver Watch Tools Inc · Chesapeake, VABuilt 2003 · S/N 10010703 N3178PStevenson Lawrence H · Marietta, GABuilt 1992 · S/N 166 N319TCLuberda Albert John · Au Gres, MIBuilt 1998 · S/N JU6A-1 N343TSSmith Terry W · Jackson, GAS/N TWS1950 N35070Kreling Jack R · Mattawan, MIBuilt 1985 · S/N 638 N357SJJenkins Kenneth Edward · Ellenton, FLBuilt 2007 · S/N JDT-123 N3651TDaus Charles J · Imler, PABuilt 2005 · S/N 001 N3678Nelsen Douglas K · Little Elm, TXS/N 1997-017 N3774SKerfeld Kyle E · Alexandria, MNBuilt 2008 · S/N ME1 N38MLHomic Michael J · Edmond, OKS/N HDH-0013 N3974VHinote Scott L · Chestnut Mound, TNBuilt 2007 · S/N 001 N3978WHolmes Zachary · Saint Paul, MNBuilt 2018 · S/N W001 N398PBBuss Paul B · Eland, WIBuilt 1998 · S/N 58

Back to Rotax 447