Skip to content

Continental E185 series

Registered aircraft · 1,107

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.

N390Buford Phillip N · Bethesda, DCBuilt 1947 · S/N D-901 N3920NAllen Sanford B · Everett, WABuilt 1947 · S/N D-1175 N3921NPlane Fun Inc Tr Trustee · Snellville, GABuilt 1947 · S/N D-1177 N3932NKearby Derek L · Greenbrier, ARS/N D-1189 N3935NBravo Humberto H · Harker Heights, TXBuilt 1947 · S/N D-1192 N3941NCarlson Brent A · Shelley, IDBuilt 1948 · S/N D-1257 N3954NNagy Richard C · Shepherd, TXBuilt 1947 · S/N D-1214 N3958NKash Ronald D · Mansfield, OHS/N D-1218 N3959NRobinson Shawn Tracy · Valencia, PABuilt 1947 · S/N D-1219 N3975NBas Part Sales LLC · Greeley, COS/N D-860 N3993NBeck Larry A · Arkdale, WIS/N D-2237 N3GGCampbell William J DBA · Santa Rosa, CABuilt 1949 · S/N NAV-4-1824 N3KWBeute Walter A · Palatka, FLBuilt 1947 · S/N D-828 N4000GTomlin Rollin D · Wilmington, OHBuilt 1949 · S/N NAV-4-1920 N4001KZahn Mark V · Sarasota, FLBuilt 1947 · S/N NAV-4-1001 N4015KCarroll David A · Gibsonville, NCS/N NAV-4-1002 N4020KMeinen Albert D · Troy, ILBuilt 1947 · S/N NAV-4-1020 N4026KWarbird Holdings LLC · Middletown, DEBuilt 1947 · S/N NAV-4-1026 N4029KCampbelll William Jr T · Sand Springs, OKBuilt 1947 · S/N NAV-4-1029 N4030KBurnett David Mark · Scott City, KSBuilt 1947 · S/N NAV-4-1030 N4032KWeise David D · Lakewood, COS/N NAV-4-1032 N4037KByrne Sofia V · Merrimack, NHBuilt 1947 · S/N NAV-4-1037 N406BAndrews Alfred L · San Antonio, TXBuilt 1948 · S/N D-1411 N4080K80 Kilo LLC · Hammond, LAS/N NAV-4-1080 N409BMorris Danny L · Woodland, CABuilt 1948 · S/N D-1414 N40URoss Stan W · Scandia, MNBuilt 1948 · S/N D-1336 N4101KBravery Aviation LLC · Viburnum, MOS/N NAV-4-1101 N4102KTomlin Rollin D · Wilmington, OHBuilt 1947 · S/N NAV-4-1102 N4106KBriggs Dan E · Hayden, IDS/N NAV-4-1106 N410BWright Samuel B · Haines, AKBuilt 1948 · S/N D-1607 N4110KDdrl Holdings LLC · Missoula, MTBuilt 1947 · S/N NAV-4-1110 N4111KMillar Charles R · Maricopa, AZS/N NAV-4-1111 N4124KOtt Dean R · Carrollton, OHBuilt 1947 · S/N NAV-4-1124 N4126KNichols Jan L · Bonham, TXS/N NAV-4-1126 N4130KColvin Buster · Big Cabin, OKS/N NAV-4-1130 N4131KDarnall Lane · Harrisburg, NEBuilt 1947 · S/N NAV-4-1131 N4132KJohnston William D · Visalia, CAS/N NAV41132 N4134KOv-10 Bronco Association Inc · Fort Worth, TXBuilt 1947 · S/N NAV-4-1134 N4139KStone Jason · Wellington, KSS/N NAV-4-1139 N413BKc Beech Front Ltd · Kansas City, KSBuilt 1948 · S/N D-1419 N4142KHopkins Frank · Wilmington, DEBuilt 1948 · S/N NAV-4-1142 N4143KDerickson Russell J · Lamberton, MNBuilt 1948 · S/N NAV-4-1143 N4145KGerondale Gregory · Tulsa, OKS/N NAV-4-1145 N4146KHolmes Peter N · Spokane, WABuilt 1948 · S/N NAV-4-1146 N4150KTomlin Rollin D · Wilmington, OHBuilt 1949 · S/N NAV-4-1150 N4156KLohse Charles R · Onalaska, WAS/N NAV-4-1156 N4179AWeaver Gary M · Morgantown, INBuilt 1948 · S/N NAV-4-1628 N4180KCooper Melvin R Jr · Prineville, ORBuilt 1948 · S/N NAV-4-1180 N4183KGroth Matthew C · Arlington, WABuilt 1948 · S/N NAV-4-1183 N4185KKennedy John E · Martinsville, INBuilt 1948 · S/N NAV-4-1185

Back to Continental E185 series