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.

N743BSauls Emily A · La Vernia, TXBuilt 1948 · S/N D-1749 N744BGraves Bryan G Sr · Madisonville, TNBuilt 1948 · S/N D-1750 N747WRCesare Frank · Cerro Gordo, NCBuilt 1947 · S/N NAV-4-997 N748BMckinney Mark L · Naperville, ILBuilt 1948 · S/N D-1756 N749DOliver Rodney W · Houston, AKBuilt 1951 · S/N D-3019 N74DSSale Reported · Lake City, FLSale reported, canceledS/N NAV-4-1959 N74SCGreen Michael B · Kent, WAS/N D-432 N751DSloan Parker Ryan · Pryor, OKBuilt 1951 · S/N D-3021 N752DSpoltman James H · Oak Harbor, WABuilt 1953 · S/N D-3413 N755DN755d Llp · Sidney, MTBuilt 1951 · S/N D-3025 N756BFrymire Terry R · Floresville, TXS/N D-1764 N75881Hot Shot Aviation Inc · Milbank, SDS/N NAV-4-620 N75RJones Daniel · Cypress, TXBuilt 1964 · S/N D-7730 N760BShorter David A · Duncan, OKBuilt 1948 · S/N D-1768 N761BMyron Wayne R · Ione, WABuilt 1948 · S/N D-1769 N764DBonanza Partners · Sleepy Hollow, ILBuilt 1951 · S/N D-3034 N76BBEdl Sf Enterprise LLC · Coral Springs, FLBuilt 1952 · S/N D-3110 N76ZBlake Trenton D · Anderson, INBuilt 1947 · S/N NAV-4-685 N771NHeitzman Gordon E · White Bear Lake, MNBuilt 1947 · S/N D-1082 N7727CBohl Howard M · Temecula, CAS/N NAV4-1688 N7728CBranstner August M · Taft, CAS/N NAV-4-1737 N772BCox Bryan L · Greensboro, NCS/N D-1782 N7733CPaliughi Ronald D · Fresno, CABuilt 1948 · S/N NAV-4-1680 N776BGas Corporation Of America · Wichita Falls, TXS/N D-1786 N776DBHagglund Carl D · Pendleton, ORBuilt 1952 · S/N D-3046 N776RFTrzcinski Douglas R · Chesapeake, VABuilt 1949 · S/N D-2082 N777BLexair Corporate Aviation · Miami, FLBuilt 1948 · S/N D-1787 N777WCHome Run Rv LLC · Helena, MTBuilt 1952 · S/N D-3148 N777WDMob Aviation USA LLC · Auburndale, FLBuilt 1960 · S/N D-6491 N779DGlendaloch Partners Lp · El Reno, OKBuilt 1951 · S/N D-3048 N77BHLattimer Bill D · Monroe, WABuilt 1963 · S/N NAV-4-1713 N77XSCarlson Jonathan J · Hernando, MSS/N D-3446 N787DMoore Christopher R · Cape Coral, FLBuilt 1952 · S/N D-3056 N78849Holliday Mark E · Lake Elmo, MNBuilt 1950 · S/N 103 N78851Old Style Aircraft LLC · Ellsinore, MOBuilt 1951 · S/N 105 N78852Brown Robert A · Peachtree City, GABuilt 1951 · S/N 106 N7889Missing Link Gravel LLC · Glasgow, MTBuilt 1949 · S/N D-2089 N78YBNovember Sierra Aviation LLC · O'Neill, NES/N D-2493 N795BTwo Motor Odor LLC · Paris, TXBuilt 1948 · S/N D-1807 N795DDudley Hugh G · Albion, NYBuilt 1952 · S/N D-3064 N796BStarnes Robert D · Lavonia, GAS/N D-1808 N797BLong E V · Wichita, KSBuilt 1948 · S/N D-1809 N7989Pour Le Merite Aviation LLC · Houston, TXBuilt 1971 · S/N 476 N798BVaughn Ken W · Fort Bragg, CAS/N D-1810 N7RTTomlin Rollin D · Wilmington, OHBuilt 1947 · S/N NAV-4-592 N7SWWheeler Ralph F · Lake City, FLS/N D-3382 N80406Johnson Raymond · Eldridge, NDBuilt 1947 · S/N D-6 N80409Beechcraft Heritage Museum Inc · Tullahoma, TNBuilt 1947 · S/N D-9 N80411Parkin Steven H · Yucca Valley, CAS/N D-11 N80412Nason David F · Kent, WABuilt 1947 · S/N D-12

Back to Continental E185 series