Skip to content

Franklin 6V 350 series

Registered aircraft · 134

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

N10175Bassett Donald J · Midland City, ALBuilt 1954 · S/N 1272 N12CJPerskys Air Service Inc · Lapine, ALBuilt 1969 · S/N 4-184 N140BL Bachman LLC · Independence, IABuilt 1947 · S/N 60 N1452PSorenson Mark A · Senoia, GABuilt 1956 · S/N 23-515 N147DPWeeks Kermit A · Polk City, FLBuilt 1956 · S/N 1685 N19WXSale Reported · Alex, OKSale reportedBuilt 1973 · S/N 2165C N1XSaitto Jeffrey M · Media, PABuilt 1965 · S/N 17252958 N2010USkydotcom LLC · Inver Grove Hgts, MNBuilt 1967 · S/N 2010C N2012UZimlich Kaylee M · Fort Collins, COBuilt 1967 · S/N 2011C N2020UGrant James L · Cameron Park, CABuilt 1968 · S/N 2014C N2028UFisher Jeffrey L · Thorndale, TXBuilt 1968 · S/N 2016C N2030UStandridge Dan J · Milpitas, CABuilt 1969 · S/N 2026C N2032UMerrell Jared E · Wasilla, AKBuilt 1969 · S/N 2021C N2039UElison Tad · Hagerman, IDBuilt 1969 · S/N 2034C N2049UCarlson Kent V · Jacobson, MNBuilt 1970 · S/N 2044C N2074UObannon Jack Jr · Houston, TXBuilt 1971 · S/N 2065C N2077UUnertl Ronald W · Waupaca, WIBuilt 1971 · S/N 2070C N207KMWayt Kevin D · Ladera Ranch, CABuilt 1971 · S/N 2062C N2174BReid Charles A · Hamburg, NJBuilt 1968 · S/N 393 N220PMFarmer Daniel L · Colorado Springs, COBuilt 1973 · S/N 2175C N221KMDahl Kevin · Soldotna, AKBuilt 1972 · S/N 12014 N23RMiller Boyd A · Mexia, TXBuilt 1969 · S/N 4-188 N2425LZappia Jonathan L · Yucaipa, CABuilt 1967 · S/N 17255625 N2469BKothman Kenn Kode · Sheffield, TXS/N 1446 N2473BKerr Douglas E · Oakland, CABuilt 1955 · S/N 1450 N264HUSpearhead Aviation Inc · Parker, COS/N 2012C N2830WWingate Barry · Dayton, NVBuilt 1969 · S/N 4-187 N2VBParker Grant F · Elgin, ORBuilt 1974 · S/N 5051C N305YStrategic Aircraft Management LLC · Fairbanks, AKBuilt 1973 · S/N 6825A-358 N32BFCrowe Jordan F · Rutherfordton, NCBuilt 1971 · S/N 11719 N330MLacy Glenn M · Bedford, VAS/N 287 N33507Gooney Bird Group Inc Non Profit Corp · Templeton, CABuilt 1953 · S/N 1088 N33BFRunway 23 LLC · Wurtsboro, NYBuilt 1971 · S/N 11720 N3550SSwalling Matthew C · Wasilla, AKBuilt 1963 · S/N 17250750 N35653Fitzgerald Bryan L · Craig, AKBuilt 1968 · S/N 17256886 N35BFBrownlee Michael C · Warner Robins, GABuilt 1971 · S/N 11722 N36BFCrowe Jordan · Rutherfordton, NCS/N 11837 N3740GSkypro · Jacksonville, FLS/N 461 N37BFLetellier Todd · Gig Harbor, WABuilt 1971 · S/N 11838 N3823SBurbank David E · Oak Harbor, WABuilt 1963 · S/N 17251023 N3859SFlorance Robert L · Fort Worth, TXBuilt 1963 · S/N 17251059 N40309Laurain Terry · Monroe, MIBuilt 1971 · S/N 2085C N40319Mceewen David L · Galata, MTBuilt 1972 · S/N 2094C N40324Weir John · High Point, NCS/N 2099C N40326Registration Pending · Bowdoin, MERegistration pendingBuilt 1972 · S/N 2101C N40329Goering Ryan I · Prineville, ORS/N 2104C N40330Hubbell Jef C · Kermit, TXBuilt 1972 · S/N 2105C N40331Snow Joe W · Pauls Valley, OKBuilt 1972 · S/N 2106C N40333Cathriner Robert A · Frisco, TXBuilt 1972 · S/N 2108C N40341Beer Carter · Columbus, MTBuilt 1972 · S/N 2117C

Back to Franklin 6V 350 series