Skip to content

Franklin 6A&6V335 series

Registered aircraft · 71

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

N102MDFarrington Kelly · Sisters, ORS/N 2127C N103JAJoann Air Inc · Mulberry, FLFirst renewal noticeS/N 782 N108DShettel Jay E · Boiling Springs, PAS/N MT-1 N1427YSpark 1 Aviation LLC · Wichita, KSFirst renewal noticeBuilt 1961 · S/N 17249127 N162DLLewkowicz Augusto D · Fort Lauderdale, FLS/N 224 N17611Tc Bouslog LLC · Noblesville, INBuilt 1952 · S/N 1041 N2050UAnderson Daniel A · Overly, NDBuilt 1970 · S/N 2047C N2051UHood River Aviation LLC · Hood River, ORFirst renewal noticeBuilt 1970 · S/N 2046C N2054UMerrell Jared E · Wasilla, AKBuilt 1970 · S/N 2051C N2056UKw Group LLC · Philipsburg, MTBuilt 1970 · S/N 2050C N2064UHoward Nathan L · Fairbanks, AKFirst renewal noticeBuilt 1970 · S/N 3004C N2065UKohler Richard L · Moriarty, NMBuilt 1970 · S/N 2056C N2066UFletcher John G · Diamondhead, MSBuilt 1970 · S/N 2057C N2069UBaucom Thomas A · Midland, NCFirst renewal noticeBuilt 1971 · S/N 2059C N222TEFranke Darren · Yorktown, TXBuilt 1955 · S/N 802 N2502UChristensen Alan B · Murphysboro, ILBuilt 1963 · S/N 17250102 N2690USmith Daryn D · Billings, MTBuilt 1963 · S/N 17250290 N2814BC-Fleet LLC · Missoula, MTBuilt 1956 · S/N 1528 N2832WIbrahim Phillip · Whitinsville, MABuilt 1969 · S/N 4-189 N33616Sale Reported · Lakeland, FLSale reportedBuilt 1955 · S/N 720 N3566DLucky Rose LLC · Brainerd, MNBuilt 1956 · S/N 27109 N36015Cotton Charles Randall · Lagrange, GAS/N 768 N3701LRice Solutions LLC · Plymouth, NHS/N 17253870 N3MLTherp Todd J · Rigby, IDBuilt 1970 · S/N 2048C N40303Dalziel Inc · White Salmon, WABuilt 1971 · S/N 3006C N40677Merrell Jared · Wasilla, AKS/N 2181C N4115ADobalian Vaughn E · Jacksonville Beach, FLBuilt 1957 · S/N 1084 N431PHMcmullen Albert John · Corsicana, TXBuilt 1989 · S/N 1 N4450CC & C Auto Sales LLC · Atlanta, MOBuilt 1960 · S/N 56553 N4977EWyllie Ashton R J Trustee · Thornton, NHBuilt 1951 · S/N 254 N50GACantrell James E Trustee · Madison, GABuilt 1974 · S/N 5003C N51602Krebs Martin C · Miami, FLBuilt 1974 · S/N 5013C N51619Isabella Ralph N · Delanson, NYBuilt 1974 · S/N 5009C N51626Silvey Brandon · Cascade, IDBuilt 1974 · S/N 5015C N51629Phillips Aaron W · Fort Scott, KSS/N 5017C N51638Janczak Gillian · Golden Valley, AZS/N 5027C N5330VMiami Helicopter Services Corp · Miami, FLBuilt 1959 · S/N 1042 N53BFPerkins Adam J · Chillicothe, ILS/N 12009 N55LETimmreck Joseph P · Anchorage, AKBuilt 1974 · S/N 5004C N56BFFlight Tech Inc · Arlington, WAS/N 12011 N57CDCarey James Dean · Winterset, IABuilt 1957 · S/N 878 N62017Bond Kelly J · Wasilla, AKS/N 5045C N62020Chardon Stephen A · Franconia, NHBuilt 1974 · S/N 5047C N6214Domingue David K · Port Neches, TXBuilt 1952 · S/N 1023 N62329Puch Len D · New Boston, MIS/N 558 N630CFilkill David B · Willow, AKBuilt 1947 · S/N 108-3630 N6356Eagal Lloyd S · Renfrew, PABuilt 1956 · S/N 1671 N64764Registration Pending · Riverbank, CARegistration pendingBuilt 1952 · S/N 489 N6520NDemeyer Scott M · Olympia, WABuilt 1949 · S/N 1641 N66BFRobbins Tracy F · Tacoma, WABuilt 1972 · S/N 12026

Back to Franklin 6A&6V335 series