Skip to content

Continental A&C75 series

Registered aircraft · 1,505

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

N1611Hibler Kenith R · Newcastle, OKBuilt 1946 · S/N 1537 N168PMcmanus Brian K · Smithville, TXBuilt 1946 · S/N 905 N1716MMinor James F · Lake Dallas, TXBuilt 1945 · S/N 13306 N171SBButler Harris K III · Towanda, KSBuilt 1993 · S/N 001 N17234Berney John E · Morgan Hill, CABuilt 1936 · S/N 1014 N1776Polyspray Corp · Asheboro, NCBuilt 1941 · S/N 6600 N177ACIsaac Bron A · Soldotna, AKS/N 7AC-5275 N17JDSpecht Leo M · Towner, COS/N 4354 N184DBExperimental Aircraft Association No 179 · Albuquerque, NMBuilt 1997 · S/N GN1-1814 N1863EHager Spraying Service Inc · Barney, NDBuilt 1946 · S/N 7AC-5430 N1864EMcalister Bryan · Lindsay, TXBuilt 1946 · S/N 7AC-5431 N1891BSmithwick Patrick Michael Trustee · Kiowa, COBuilt 1948 · S/N 6318 N18CSMclauchlin Todd Randall · Sparks, NVBuilt 1997 · S/N AV1055 N18CTAugustin Lyn H · Saint Thomas, NDBuilt 1953 · S/N 287 N190EDHarris Roy · Wasilla, AKBuilt 1990 · S/N 1-90 N1938EMcfarlane Bradley J · Turlock, CABuilt 1946 · S/N 7AC-5505 N1975BHolliday Mark E · Lake Elmo, MNBuilt 1948 · S/N 6402 N1979EWomack Rob L Jr · Waco, TXBuilt 1946 · S/N 7AC-5546 N1998EHinson John F · Jefferson Hills, PABuilt 1946 · S/N 7AC-5565 N1VBMckee Robert D · Odessa, WABuilt 1974 · S/N 7102F-352B N2006HLegrand Stephen L · Oro Valley, AZBuilt 1946 · S/N 2629 N2007HElder Robert C · Prosser, WABuilt 1946 · S/N 2630 N2010MThomas Spencer S · New Castle, COS/N 20774 N2014BRoot Daniel J · Friday Harbor, WABuilt 1948 · S/N 6441 N2016MHenkelmann David H · Janesville, WIBuilt 1946 · S/N 21007 N2021HGregory Vernon L · Swansea, SCBuilt 1946 · S/N 2644 N2022HGartke Michael L · Waterman, ILBuilt 1946 · S/N 2645 N2022MRegistration Pending · Middletown, DERegistration pendingBuilt 1946 · S/N 20787 N2024HVarzavand Shahram · Cedar Falls, IABuilt 1946 · S/N 2647 N2026HFlying R Aviation LLC · Smackover, ARBuilt 1946 · S/N 2649 N2034HWustrack Jeffrey F · Wichita, KSS/N 2657 N2035HPoliak Mark A Trustee · Carmel, INBuilt 1946 · S/N 2658 N2048HLund Patrick · Gilmer, TXBuilt 1946 · S/N 2671 N2049HArquer Nicholas R · Rancho Cucamonga, CAS/N 2672 N2050KWalton T Michael · Hudson Falls, NYBuilt 1947 · S/N 4777 N2056HKieffer William A · Chillicothe, MOBuilt 1946 · S/N 2662 N2064HMcbride Devin · Forney, TXS/N 2687 N2065HAnderson Nancy L · Chehalis, WAS/N 2688 N2076EZerovich Karl · Cortland, OHBuilt 1946 · S/N 7AC-5646 N2077HWinter Jack W · Custer, SDBuilt 1946 · S/N 2700 N2081HGutierrez Ryan Y · Pacoima, CABuilt 1946 · S/N 2704 N2083HHatcher Joe W · Ripon, WIBuilt 1946 · S/N 2706 N2084KDelisio Matthew W · Lake Elsinore, CAS/N 4811 N2091HCripe Daniel J · Kuna, IDBuilt 1946 · S/N 2714 N2093HAdams Ronald B · Statesboro, GABuilt 1946 · S/N 2716 N2095HStovall Spencer R · Iuka, MSBuilt 1946 · S/N 2718 N20988Registration Pending · Oklahoma City, OKRegistration pendingBuilt 1940 · S/N 117 N2098EFritzinger Thomas · Maidens, VABuilt 1946 · S/N 7AC-5669 N2099HVess Gerald · Livingston, TXS/N 2722 N2102HHarvell Randall W · Manteno, ILS/N 2725

Back to Continental A&C75 series