Skip to content

Franklin 6V4 series

Registered aircraft · 84

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

N10195Deuchar Hillary · Brookings, ORS/N 562 N1101VClement Walter F · Enfield, NCBuilt 1947 · S/N 18 N12888Suess Robert D · San Jose, CABuilt 1947 · S/N 20 N1348ZPockrus Pat B · Mineral Wells, TXBuilt 1958 · S/N 1043 N153BScotts Helicopter Service · Le Sueur, MNBuilt 1947 · S/N 7 N155JNAero-Mobil Inc · Wilmington, DEBuilt 1955 · S/N 1445 N157BLewis Gerald K · Bakersfield, CABuilt 1947 · S/N 11 N160BJames David R · Wayne, MIBuilt 1947 · S/N 14 N162MCosta James Joseph · Tulare, CABuilt 1962 · S/N 238 N16356Modern American Warrior Inc · Spring, TXBuilt 1951 · S/N 536 N172SMSedeyn Thomas Sr · Salem, NJBuilt 1950 · S/N 317 N1773Aircraft Sales LLC · Caledonia, MIBuilt 1967 · S/N SA51 N182BLay Lawrence W · Douglass, KSBuilt 1948 · S/N 36 N184BTaz Air Service Inc · Middletown, DEBuilt 1959 · S/N 45 N225BHammock Flying Service Inc · Smithville, ARBuilt 1949 · S/N 149 N225REMoonshadow Aviation Inc · Wilmington, DES/N DLW3 N234SMRobertson Kenneth W · Sussex, NJBuilt 1955 · S/N 55-4101 N237DJJames David R · Wayne, MIS/N 237 N2480BWillert Fred J · San Diego, CABuilt 1955 · S/N 1360 N263SSMadden Russell E · Graford, TXS/N 265 N2821BLumley William B · Delray Beach, FLBuilt 1956 · S/N 1530 N2831BTaz Air Service Inc · Middletown, DEBuilt 1957 · S/N 1361 N2891BCosta James J · Goff, KSBuilt 1957 · S/N 1535 N307AJSwashbuckle Air LLC · Anchorage, AKBuilt 1952 · S/N 426 N3103GLancaster Helicopters Inc · Landisville, PABuilt 1959 · S/N 185 N310AAnverse Inc · Cartersville, GABuilt 1947 · S/N 82 N3116GAlvis Michael E · Parkton, NCS/N 284 N3657FDouglas Helicopter Inc · Douglas, GABuilt 1959 · S/N 900 N38767Pockrus Pat B · Mineral Wells, TXS/N 1037 N39WLMinnesota Military And Veterans Museum · Little Falls, MNS/N 514 N4250AIxl Inc · Sulphur, LAS/N 421 N4254AJames David R · Wayne, MIBuilt 1950 · S/N 229 N427HSTaz Air Service Inc · Middletown, DEBuilt 1959 · S/N 427 N4419ERatledge Thomas D · Bethel, AKS/N K651 N47242Pockrus Pat B · Mineral Wells, TXBuilt 1952 · S/N 491 N472DMMcdowell David M · El Cajon, CABuilt 1963 · S/N WH5007 N4733CTaz Air Service Inc · Middletown, DES/N 260 N4786CKincanon Richard F · Elk River, MNBuilt 1942 · S/N 654 N47TKMillenium Helicopters I Inc · Middletown, DEBuilt 1952 · S/N 52-7904 N47WFCantarini Cody M · Fallbrook, CABuilt 1966 · S/N T-610 N47ZAGanuza Diego · North Miami Beach, FLBuilt 1956 · S/N 1533 N4924CBritton John E · Emmett, IDBuilt 1960 · S/N 2 N5104VOutka Wade R · Aberdeen, SDBuilt 1963 · S/N JR-1 N5306VDonnelly Matthew J · Romulus, NYS/N 632 N5311VBotello Michael C · Rancho Mirage, CABuilt 1955 · S/N 703 N5317VInternational Air Services Inc Trustee · Carson City, NVBuilt 1956 · S/N 768 N5320VAlbertson James M · Slocomb, ALBuilt 1956 · S/N 786 N5326VJstream Lc · Sheridan, WYBuilt 1956 · S/N 865 N538ACHardy John S · Fort Worth, TXBuilt 1953 · S/N 538 N59BTBisek Michael David · Bulverde, TXBuilt 1963 · S/N CC1-463

Back to Franklin 6V4 series