Skip to content

Franklin 6A-350SER

Registered aircraft · 74

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

N10157Kuber Daniel S · Girdwood, AKBuilt 1973 · S/N 2171C N126EEGregory David A · Westmoreland, TNS/N DM0214 N131RDRyan R S · San Diego, CAS/N ER-45 N136LCJewell David S · Olivehurst, CABuilt 2005 · S/N DM0316 N1518WCrook Douglas S · Graham, WABuilt 1968 · S/N 11028 N169AJNolan Davis Dds LLC · Juneau, AKBuilt 1969 · S/N 17257981 N173WJWilbeck W J · S Hutchinson, KSBuilt 2008 · S/N DMO254 N175FWWilfer Dennis · Fairbanks, AKBuilt 1958 · S/N 55020 N175GGoode Greg · Kalispell, MTBuilt 1959 · S/N 56030 N17RFComanche Group Inc · Dallas, TXBuilt 1969 · S/N 2004 N2062UBroadwell Eric · Woodstock, GAS/N 3003C N220HPGorecki Mitchel D · Durham, NCBuilt 1991 · S/N 461 N220VEHanson Rick L · Gautier, MSBuilt 2001 · S/N SRE-052 N2228Leupp John R · Taylors, SCBuilt 1971 · S/N 28 N223AZDanz Kevin James · East Helena, MTBuilt 1998 · S/N NMO 223 N2378EFair Hillary M · Midvale, UTBuilt 2000 · S/N 001 N243BDBennett Reed J · Reno, NVBuilt 1956 · S/N 20591 N250PMorse Edward Jr · Wasilla, AKBuilt 1998 · S/N 97133 N254LFBrand David E · Touchet, WABuilt 2002 · S/N 80254 N2655DSutton Aircraft Salvage LLC · Palmer, AKBuilt 1956 · S/N 20807 N274SJList Chad C · Soldotna, AKBuilt 1974 · S/N 5022C N301AKSale Reported · Grass Valley, CASale reportedS/N 8-3948 N307SKnott John A · Waller, TXBuilt 1970 · S/N 471 N311ECLinton Andrew M · Black Mountain, NCBuilt 1974 · S/N 5026C N314VFrownfelter Grant · Fenton, MIBuilt 2002 · S/N 1992229 N380QThomas George E · Rice, WABuilt 1972 · S/N 2159C N38225Johnson Bonnie L · Sedgwick, KSBuilt 1973 · S/N 001 N3843VKown W B · Hamilton, ALBuilt 1949 · S/N 18730 N3917CGortemiller Trevor Allen · Atkins, ARBuilt 1971 · S/N 2067-C N400BDMusitano Charles M · Huntsville, ALBuilt 2003 · S/N 0001 N40304Howard Nathan L · Fairbanks, AKBuilt 1971 · S/N 2078C N40312Banks Mark Vernon · Jamestown, CABuilt 1971 · S/N 2086C N40314Husbands Jason · Belen, NMBuilt 1971 · S/N 2090C N40335Davis Philip L · Spring Hill, TNBuilt 1972 · S/N 2110C N40344Howard Nathan L · Fairbanks, AKBuilt 1972 · S/N 2120C N40352Shriner Justin M · North Pole, AKS/N 2130C N40628Herrington John · Marion, MTBuilt 1972 · S/N 2149C N40629Tejas Flying Services LLC · Ganado, TXBuilt 1972 · S/N 2150C N40633Rice Richard L · Rossville, TNBuilt 1972 · S/N 2151C N40634Nichols Michael H · Thompson Falls, MTBuilt 1972 · S/N 2152C N40635Yuan Andrew W · Salinas, CABuilt 1972 · S/N 2153C N40640Koch Christopher P · Batavia, NYS/N 2158C N40650Palmer Paul W · Joliet, ILBuilt 1973 · S/N 2166C N411CBOsky Deuce LLC · Saguache, COBuilt 1968 · S/N 2037C N4186GJenkins Michael D · Rigby, IDBuilt 1948 · S/N 108-4824 N420GTCocchiola Bart · Pittstown, NJS/N 1136 N474WH&H Restoration LLC · Wasilla, AKS/N 2027C N4PEJamaican Goose Inc · Cedar Park, TXS/N DMO415 N508ESGarlic Kevin L · Ekron, KYBuilt 1997 · S/N 743 N51620Bork Joseph L · Mosier, ORS/N 5012C

Back to Franklin 6A-350SER