Skip to content

Registered aircraft · 18

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

N163ABKirkhuff Martin M · Queen Creek, AZBuilt 2006 · S/N 001 N1944XLifto Thomas W · Barronett, WIBuilt 2004 · S/N CH2-0604-2492 N2513SBanman Abraham K · Seminole, TXBuilt 1999 · S/N AV-002 N318MCTrail William H · Reidsville, NCBuilt 1992 · S/N 280 N3283NBudd Kenneth · Lancaster, PABuilt 2005 · S/N 6199 N342TMLabermeier William C Jr · Munford, TNBuilt 2008 · S/N CH2-1005-2673 N415MBKarstedt David B · Tampa, FLS/N 1333 N4317UBalckmon Burnie B III · Monterey, INS/N CH2-1105-2701 N5142FMathews Lyle W · Red Bud, ILBuilt 1996 · S/N CH-21094CW1232 N55012Geisen Ernest F · Cullman, ALBuilt 1985 · S/N EC 112882 N6056BBrewster Thomas J · East Syracuse, NYBuilt 2001 · S/N GT 2801476 N719VCMorrison Dale C · Eloy, AZBuilt 2007 · S/N 001 N80719Ohler Ron · Nashville, MIBuilt 2007 · S/N XP-503-49 N855LLCassetta Thomas · Dundee, NYS/N CH2-1108-2855 N8606AHowell Dave B · Orlando, FLBuilt 1986 · S/N 1081 N901GHNorman Monroe E · Duvall, WABuilt 1990 · S/N CH20990W0559 N9148RPreston Lawrence D · Murrieta, CABuilt 1986 · S/N 5B2312 N964JWilliamson Lee · Franklin, KYBuilt 1999 · S/N HD 99024 EX

Back to Rotax 503DC