Skip to content

Continental A50 series

Registered aircraft · 26

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

N1149Hallam Drew R · Orfordville, WIS/N Z88 N17RLChristensen Scott A · Plano, TXBuilt 1984 · S/N 635 N1938KHaney Benjimen A · Vermont, ILS/N KCA-35 N200GMMedve George · Medway, OHBuilt 2015 · S/N GM04 N20304Rougeau Derek E · Florida, MABuilt 1937 · S/N 405 N21021Stewart Donald M · Vulcan, MIBuilt 1938 · S/N KCA6 N21261Whitaker David E · Canton, OHBuilt 1938 · S/N 1054 N21309Dexter Fred H · Live Oak, FLBuilt 1938 · S/N C-1148 N21336Halsey Ronald F · Grassy Creek, NCBuilt 1938 · S/N C-1428 N21528Palmenteri Louis J · Rhome, TXBuilt 1938 · S/N 2380 N21599Hetge Kenneth R · Viola, ARBuilt 1938 · S/N 4-400 N21973Western Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1939 · S/N 559 N21994Taylor Brent · Ottumwa, IABuilt 1939 · S/N 574 N22216Seal Jerry W · Westlake, LAS/N 1154 N22228Brown Edward A · Halifax, MAS/N 1174 N22356Plunkett Robert G · Hudson, OHBuilt 1939 · S/N C-3559 N22725Gebhart Daniel T · Hanover, PABuilt 1938 · S/N 4426 N24294Paula Patrick A · Alleyton, TXBuilt 1940 · S/N C7560 N24806King Barry J · Bentonville, ARBuilt 1939 · S/N 3459 N24810Piper Aircraft Inc · Vero Beach, FLS/N 38-80A0008 N2504FJohnson Scott W · Saline, MIBuilt 1965 · S/N 38 N25436Briley Victor O · Johannesburg, MIBuilt 1940 · S/N 606 N25495Shannon Aviation LLC · Drexel, MOBuilt 1940 · S/N 624 N38584Soulek Joyce · Lake Andes, SDS/N 5-1002 N83289Mcnicoll Steven P · Depere, WIBuilt 1946 · S/N 7AC-1956 N900RSInmon Leon C · Williston, FLS/N 17248585

Back to Continental A50 series