Skip to content

Continental A-75 series

Registered aircraft · 9

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

N225VGBowman Stephen L · Palm Bay, FLBuilt 2015 · S/N VCG-2 N29BFGlittenberg Donald R · Decatur, TXBuilt 2009 · S/N 315 N394JWStanton Todd A · Plain City, OHBuilt 2010 · S/N 001 N4202DJohnson Scott W · Saline, MIBuilt 1991 · S/N 321 N438MBMendes Frank Skye Rodrigues · Coolidge, AZBuilt 2011 · S/N 779 N556GSSammons Guy L · Savannah, GABuilt 2004 · S/N 82-5 N56FFJames Marvin L · Scio, ORBuilt 2019 · S/N MJFF001 N86EMAustin Paul W · Des Moines, IABuilt 1975 · S/N 2914 N87162Evans Orville J · New Philadelphia, OHBuilt 1946 · S/N 335

Back to Continental A-75 series