Skip to content

Continental E185 series

Registered aircraft · 1,108

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

N80418Beechcraft Heritage Museum Inc · Tullahoma, TNBuilt 1947 · S/N D-18 N80423N80423 LLC · Palisade, COS/N D-23 N80429Cary William R · Graniteville, SCBuilt 1947 · S/N D29 N80431Biggs Aircraft Inc · Wellston, OKBuilt 1947 · S/N D-31 N80435Christopher T Hoke · Edmond, OKBuilt 1947 · S/N D-35 N80438Newhard Glenn K · Bethlehem, PABuilt 1947 · S/N D-38 N80445Cromley Russell B · Odessa, FLBuilt 1947 · S/N D-45 N8083SKoenig William J · Benedict, MDS/N 15061683 N8095SKimball James D · Osceola, IABuilt 1965 · S/N 15061695 N809TSMedic Choppers LLC · Springdale, ARS/N D-809 N8136SPockrus Pat B · Mineral Wells, TXS/N 15061736 N8145SBissat Rishid H · Visalia, CABuilt 1965 · S/N 15061745 N8403ACrittenden William R · Dunwoody, GABuilt 1948 · S/N D-1815 N8410ABonanza Parts · Davis, CAS/N D-1847 N8412AZeien Robert A · Charlton, MAS/N D-1849 N842JWHerrington Ronald Bruce · Lakeland, GABuilt 1949 · S/N NAV-4-1639 N8430AMontgomery Patrick E · Auburn, NYBuilt 1948 · S/N D-1844 N8431ABas Part Sales LLC · Greeley, COBuilt 1948 · S/N D-1845 N8434AShepard Roger C · Aberdeen, WABuilt 1948 · S/N D-1850 N8440AWeller Donald R · Kathleen, GABuilt 1948 · S/N D-1846 N8452AHoward Jordan Stevens · Tioga, NDS/N D-1870 N8456ACrawford Larry G · California, MOS/N D-1874 N8461ALove Larry E · Greenbrier, ARBuilt 1949 · S/N D-2012 N8465AKeys James B · Oakwood, GABuilt 1948 · S/N D-1883 N8467ARegistration Pending · Tucson, AZRegistration pendingBuilt 1948 · S/N D-1885 N8478ABrice Staeheli · Saint Paul, MNS/N D-1898 N8482AEngelhart Mitchell S · Roswell, GABuilt 1948 · S/N D-1902 N8490AUrquhart Dan DBA · Fallon, NVBuilt 1948 · S/N D-1910 N8497AHaynie Walter R · Brooklyn, IABuilt 1948 · S/N D-1919 N8501ARosanova Richard Shane · Flagstaff, AZBuilt 1948 · S/N D-1923 N8510HWobschall Eric D DBA Buffalo Skyline · Williamsville, NYBuilt 1947 · S/N NAV-4-510 N8511ASipple Ronald W Jr · Gardner, KSBuilt 1949 · S/N D-1933 N8511HCrowley James E · Vero Beach, FLBuilt 1947 · S/N NAV-4-538 N8514HYoung Bobby R · Burnsville, NCBuilt 1947 · S/N NAV4-512 N8517HSieling Ronald D · Brainerd, MNS/N NAV-4-203 N8518ALapinel Marc P · Long Beach, NYS/N D-2018 N8525AAuten Charles W III · Parker, COBuilt 1949 · S/N D-2023 N8530HMeinen Albert D · Troy, ILBuilt 1947 · S/N NAV-4-496 N8534HVandervlugt Hans · Refugio, TXBuilt 1947 · S/N NAV-4-524 N8538AWeeks Stanley III · Taneyville, MOS/N D-1960 N8541HBiers Jerry D · Sturgis, SDS/N NAV-4-208 N8558AAerobanc Of America Inc · Camarillo, CABuilt 1949 · S/N D-1980 N8558HHampton Joseph · Monticello, KYBuilt 1947 · S/N NAV-4-610 N855MDOtt Dean R · Carrollton, OHBuilt 1947 · S/N NAV-4-611 N8565AHendricks Allan T · Pearland, TXBuilt 1949 · S/N D-1987 N8567HHoak Thomas E · Yucaipa, CABuilt 1947 · S/N NAV-4-619 N8571AWilliams Alan P · Bossier City, LABuilt 1949 · S/N D-1993 N8574HDirty Birds Inc · Noblesville, INBuilt 1947 · S/N NAV-4-623 N8576HMandery Jeffrey Alan · Richmond, TXS/N NAV-4-624 N8577ANissen Chris · Sandy, ORBuilt 1948 · S/N D-1999

Back to Continental E185 series