Skip to content

Continental A40 series

Registered aircraft · 112

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

N18336Davis Trenten E · Brodhead, WIBuilt 1937 · S/N 69 N18339Strine Russell A · Reading, PABuilt 1937 · S/N 72 N18365Mann Thomas A · Ford, WABuilt 1937 · S/N 97 N18743Airpower Museum Inc · Ottumwa, IAS/N 529 N18817Lyon Richard K · Mansons LandingBuilt 1974 · S/N 493 N19028Cannard Marius A · Shullsburg, WIS/N 134 N19232Decklar Mark R · Grass Valley, CAS/N 1632 N19236Hendrickson Steve L · Lake Stevens, WABuilt 1937 · S/N 1636 N19263Sweeney Aron T · Murray, KYBuilt 1937 · S/N 1663 N19285Wright Thomas L · Clyde, OHBuilt 1937 · S/N 1685 N19502Dexter Fred H · Live Oak, FLBuilt 1937 · S/N 1702 N19510Wagner James E Jr · Peotone, ILBuilt 1937 · S/N 1710 N19511Rare Aircraft Ltd · Faribault, MNBuilt 1937 · S/N 1711 N19518Nichols Charles F Trustee · Baldwin Park, CABuilt 1937 · S/N 1718 N19608Petro Jerry R · Williamsburg, VABuilt 1937 · S/N 214 N19612Braness Jim G · Richmond, MNS/N 219 N19615Pearlman Aircraft Co · Orlando, FLBuilt 1937 · S/N 222 N19649Lindquist Lucy M · Hampshire, ILBuilt 1937 · S/N 256 N19653Ranger Airfield Foundation · Ranger, TXBuilt 1937 · S/N 260 N19660Meyer Jeremy · Conway Springs, KSBuilt 1937 · S/N 267 N19693Byrd David J · Greensboro, NCBuilt 1937 · S/N 300 N19716Dexter Fred H · Live Oak, FLBuilt 1937 · S/N K228 N19826Poorman Benjamin T · Wauseon, OHBuilt 1937 · S/N 331 N19829Pope Andrew W · New Boston, TXS/N 334 N19832Helgerson David · Ottumwa, IAS/N 337 N19844Lindquist Lucy M · Hampshire, ILBuilt 1937 · S/N 349 N20027Edmiston Brandon L · Murray, KYBuilt 1937 · S/N 1827 N20034Aas LLC · Ovid, MIBuilt 1937 · S/N 1834 N20037Gonzales Donald M · Columbia Station, OHBuilt 1937 · S/N 1837 N20096Higley Rick · Basehor, KSBuilt 1937 · S/N 1896 N20101Carter Curtiss D · Orono, MES/N 1901 N20150Sweeney Andrew H · Murray, KYBuilt 1938 · S/N 1950 N20156Fazzolare Dennis J · Strabane, PABuilt 1938 · S/N 2233 N20161Gaskill Leslie David · Ottumwa, IABuilt 1938 · S/N 1961 N20165Newcomer Steven · Loganville, GAS/N 2217 N20206Risker Dale W · Bulger, PAS/N 2006 N20231Gregory Richard L Jr · Houston, TXBuilt 1937 · S/N 2031 N20257Palmer Flying Service Inc · Manito, ILBuilt 1941 · S/N 2057 N20258Brandt Terry R · Hood River, ORBuilt 1938 · S/N 2058 N20261Vankirk Malcolm R · Frederick, MDBuilt 1938 · S/N 2061 N20467Hetge Kenneth R · Viola, ARBuilt 1939 · S/N 162 N20524Pflegl David H · Oregon City, ORBuilt 1937 · S/N 529 N20546Perry Aaron O · Piqua, OHS/N 554 N20833Paetzold Larry E · Brownwood, TXBuilt 1961 · S/N 2133 N20886Ari Ben Aviator Inc · Fort Pierce, FLBuilt 1938 · S/N 2195 N2414Martinez Anthony III · Great Bend, KSS/N 64 N2768Newhouse Hayden V · Fredericksburg, TXBuilt 1982 · S/N 102 N2864AWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1994 · S/N 1928-3 N329YSchildberg Gregory M · Casey, IABuilt 1963 · S/N FMB18158 N33500Abel Brandon R · Henderson, NVBuilt 1945 · S/N 11000

Back to Continental A40 series