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.

N1053GCrisman Donlin D · Mckinney, TXBuilt 1982 · S/N 1 N10547Alfred And Lois Kelch Aviation Museum Inc · Brodhead, WIBuilt 1935 · S/N 283 N10594Piper Aircraft Inc · Vero Beach, FLS/N 12 N11785Revoir Richard E · Hastings, NYBuilt 1935 · S/N 320 N12607Caldwell Stephanie Trustee · New Middletown, OHS/N 27 N12627Brandt Terry R · Hood River, ORBuilt 1931 · S/N 32 N12628Shannon Air Museum LLC · Fredericksburg, VABuilt 1932 · S/N 33 N13021Hammond James F · Yellow Springs, OHBuilt 1932 · S/N A-236 N13114Martinez Anthony · Great Bend, KSS/N 47 N13146Dougherty Paul D Jr · Bethel, PABuilt 1932 · S/N 54 N13179Poplar Grove Aviation Education Assoc Inc · Poplar Grove, ILBuilt 1933 · S/N 60 N13RNMurphy Dale · Pagosa Springs, COBuilt 1936 · S/N 938 N14373Middlebrook Reece · Penn Yan, NYS/N 117 N14419Pietsch Warren A · Minot, NDBuilt 1937 · S/N 1607 N14737Revoir Scott R · Hastings, NYBuilt 1935 · S/N 144 N14757Mid America Flight Museum · Mount Pleasant, TXS/N 150 N14843Gillespie Bob · Gladys, VABuilt 1937 · S/N 103 N14HDPioneer Flight Museum · Kingsbury, TXBuilt 1983 · S/N 143 N15009Stewart Mark W · Arnold, MDBuilt 1935 · S/N 174 N15083Mckinley Scott E · Spokane Valley, WAS/N 222 N15333Saint Stephen F · Dunnellon, FLBuilt 1935 · S/N 251 N15676Cournoyer John J · Ellsinore, MOBuilt 1935 · S/N 341 N15792Mid Atlantic Air Museum · Reading, PAS/N 1006 N15965Maxson Lee V · Mesa, AZBuilt 1936 · S/N 509 N16621Stewart Robert J Jr · Erie, PABuilt 1936 · S/N 636 N16651Horst Aviation LLC · New Holland, PABuilt 1936 · S/N 666 N16667Stewart Mark W · Arnold, MDBuilt 1936 · S/N 682 N16747Curtis Air · Pittsfield, MEBuilt 1936 · S/N 749 N16769Castle Air LLC · Livermore, CABuilt 1936 · S/N 771 N16935Bowe Drew J · Poplar Grove, ILBuilt 1936 · S/N 801 N16947Tre Aviation Corp · Wilmington, DEBuilt 1936 · S/N 813 N16957Hurlburt Ronald V DBA · Durand, WIBuilt 1936 · S/N 823 N16971Registration Pending · Ashley, MIRegistration pendingBuilt 1936 · S/N 837 N16DCFriedman Richard E · Valley Center, KSBuilt 1973 · S/N SC1 N17220Mcneill Daniel A · Placerville, CABuilt 1936 · S/N 886 N17247Antique Preservation Assn Greenfield · Greenfield, IABuilt 1937 · S/N 913 N17253Command Aire LLC · Sitka, AKBuilt 1936 · S/N 919 N17261Schaller Lee W · New Athens, ILBuilt 1936 · S/N 927 N17283Harter Michael R · Greenfield, INBuilt 1937 · S/N 950 N17287Tomasz Steve · Westland, MIBuilt 1937 · S/N 1222 N17390Taylor Douglas B · New Middletown, OHBuilt 1936 · S/N 25 N17525Schulz Michael L · Norfolk, NEBuilt 1936 · S/N 945 N17549Brown Thomas E · Coalinga, CABuilt 1936 · S/N 1049 N17554Martinez Anthony Nmn · Great Bend, KSS/N 1057 N17569Barry Kevan · Gig Harbor, WAS/N 1069 N17834Rhinebeck Aerodrome Museum · Rhinebeck, NYS/N 1269 N17847Flying M Services Inc · Germansville, PAS/N 1282 N17872Ficklin Robert L · Fairbury, ILBuilt 1937 · S/N 1306 N17876Beicker Dennie L · Hernando, MSS/N 1310 N17910Old Aeroplane Co LLC · Fort Ogden, FLBuilt 1937 · S/N 1510

Back to Continental A40 series