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.

N8781AFischer Dan · Houston, TXBuilt 1949 · S/N D-2186 N8781HKarl Abram · Defuniak Springs, FLBuilt 1947 · S/N NAV-4-781 N8783AScott Roland E Jr · Baltimore, MDS/N D-2205 N8786HInman Dentis R · Medina, TNBuilt 1946 · S/N NAV-4-786 N8787AGehling Kelly P · Fort Worth, TXBuilt 1950 · S/N D-2209 N8788Renken Jeremy L · Fairfax, VAS/N D-2778 N8794AFramiglio John · Nashville, TNBuilt 1950 · S/N D-2216 N8800ABarnes Richard E · Malin, ORBuilt 1950 · S/N D-2222 N8801HDavidson Joel R · Granville, NYBuilt 1946 · S/N NAV-4-801 N8810ACovert Aero LLC · Warren, VTBuilt 1950 · S/N D-2232 N8812HBruck Michael L · Hawthorne, CABuilt 1947 · S/N NAV-4-812 N8813ALange Eric M · Prescott, AZBuilt 1950 · S/N D-2257 N8813HGroff Russell D · Winchester, TNBuilt 1947 · S/N NAV-4-813 N8821HCohen John P · Davidsonville, MDBuilt 1947 · S/N NAV-4-821 N8830ACansler Seth A · Greenville, TXBuilt 1950 · S/N D-2484 N8831ALyons James P · Lake Suzy, FLBuilt 1950 · S/N D-2485 N8837AFrisbie Anthony G · Dallas, TXBuilt 1950 · S/N D-2492 N8837HClements Jeffry J · North Las Vegas, NVBuilt 1947 · S/N NAV-4-837 N8839ALove Robert W · King George, VABuilt 1950 · S/N D-2494 N8846AJolliff Travis L · El Paso, TXBuilt 1950 · S/N D-2501 N8850AGibson Lawrence D · Lakeland, FLBuilt 1950 · S/N D-2505 N8855HMyers Dwight E · Spencerport, NYBuilt 1947 · S/N NAV-4-855 N8857ADixon Kevin S · Denton, TXS/N D-2512 N8858HHogan Reef Alexander · Billings, MTBuilt 1947 · S/N NAV-4-858 N8865AJackson Robert K · Bay City, TXBuilt 1950 · S/N D-2520 N886MDReardon Pat L · Coffeyville, KSS/N NAV-4-486 N8870HOlson Daniel R · Boone, NCBuilt 1947 · S/N NAV-4-870 N8871HHubbard James E · Dover, OHBuilt 1947 · S/N NAV-4-871 N8880HNavion West Inc · Northridge, CAS/N NAV-4-880 N8883ALambson Roger S · Saint Ignatius, MTBuilt 1950 · S/N D-2538 N8886HOffield Shauna · La Vernia, TXS/N NAV-4-886 N8889HMorris John A · Phoenix, AZBuilt 1947 · S/N NAV-4-889 N888LWSchaffer Gary W · Bumpass, VABuilt 1948 · S/N NAV-4-1283 N8890ALangley Troy C · Newport, WAS/N D-2545 N8893ATurbine Financial Group LLC · Ogden, UTBuilt 1950 · S/N D-2591 N8897HCoats Classic Wings LLC · Birmingham, ALBuilt 1947 · S/N NAV-4-897 N8901HMiller Benny Dwayne · Canutillo, TXBuilt 1947 · S/N NAV-4-901 N8905AGalliart Herb · Anthony, NMFirst renewal noticeBuilt 1950 · S/N D-2603 N8906APierce Phillip · Ashville, ALBuilt 1950 · S/N D-2604 N8908AMclenaghan Alvin N · Phoenix, AZBuilt 1950 · S/N D-2606 N8910HSzymczak Chester Z · Bountiful, UTBuilt 1947 · S/N NAV-4-910 N8911ABeverage Jamie L · Crescent, OKBuilt 1950 · S/N D-2662 N8915HJudy Ronald W · Meade, KSBuilt 1947 · S/N NAV-4-915 N8917ARosenkranz Rashell Denning · Ellensburg, WABuilt 1950 · S/N D-2617 N8925ATaylor Ernest N Jr · Doral, FLBuilt 1950 · S/N D-2625 N8926AEllington William E Jr · Houston, TXS/N D-2626 N8927ANatale Julian K · Wakefield, RIBuilt 1950 · S/N D-2627 N8927HQuillin Sean · Dallas, TXBuilt 1947 · S/N NAV-4-927 N8928HLoftin Lowen B Jr · Southlake, TXBuilt 1947 · S/N NAV-4-928 N8930ACusick Christopher J · La Jolla, CABuilt 1951 · S/N D-2684

Back to Continental E185 series