Skip to content

Continental C85-8

Registered aircraft · 16

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

N10FKWeller Steven C · Hummelstown, PABuilt 1985 · S/N KOSIK-1 N114WTLarson Greg A · Hartland, WIBuilt 2011 · S/N C9812 0227 N157HDDouglas Hiram P · Godley, TXBuilt 2026 · S/N 003 N1973MScruggs John S · Hazlehurst, GAS/N 21572 N21820Lemons Mike · Conway, ARBuilt 1938 · S/N 2612 N2765EBergman Peter A · Duluth, MNBuilt 1946 · S/N 7AC-6348 N29832Lee Thomas M · Newnan, GABuilt 1943 · S/N 11123 N30494Aslesen Ann Marie · Hillsboro, NDBuilt 1940 · S/N 4874 N31086Cabigas John V · Yuba City, CABuilt 1940 · S/N 5314 N3668EAnderson Richard A · Sycamore, ILBuilt 1947 · S/N 11AC-1844 N44288Foley Sumner R · Spring Hill, FLBuilt 1946 · S/N 7AC6746 N4479ETampa Bay Flying Club LLC · Palmetto, FLBuilt 1948 · S/N 7DC101 N45016Weber Jeffrey W · Marlton, NJBuilt 1941 · S/N 7467 N6385VChamp Flyers Of Va LLC · Glen Allen, VABuilt 1946 · S/N 7AC-5482 N81596Super D Group LLC · Hanoverton, OHBuilt 1945 · S/N 7AC-215 N82700Augspurger James F · Lake Wylie, SCBuilt 1946 · S/N 7AC-1339

Back to Continental C85-8