OpenAirDocs.org
Dexter Fred H

Registered aircraft · 51

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_name = 'DEXTER FRED H' OR list_contains(g.other_registrant_names, 'DEXTER FRED H')
  ORDER BY g.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.

N10968Curtiss Wright JR CW1 · S/N 1146Built 1931 · Live Oak, FLN10KPBoeing A75N1(PT17) · S/N 755247Built 1942 · Live Oak, FLN1121Aeronca 7DC · S/N 47-1267Built 1947 · Live Oak, FLN13801Stinson JR. SR · S/N 8755Live Oak, FLN14592Stinson SR-5 · S/N 9333ABuilt 1935 · Live Oak, FLN14632Aeronca C-3 · S/N A-518Built 1935 · Live Oak, FLN15170Stinson SR-6 · S/N 9647Built 1935 · Live Oak, FLN1602EChampion 7AC · S/N 7AC-516Built 1955 · Live Oak, FLN16122Stinson SR-7B · S/N 9684Live Oak, FLN17116Stinson SR-8C · S/N 9801Built 1936 · Live Oak, FLN17190Stinson SR-9C · S/N 5173Live Oak, FLN19502Piper J-2 · S/N 1702Built 1937 · Live Oak, FLN19716Aeronca KC · S/N K228Built 1937 · Live Oak, FLN19744Aeronca K · S/N K260Built 1945 · Live Oak, FLN21309Aeronca 50-C · S/N C-1148Built 1938 · Live Oak, FLN21354Aeronca 65-C · S/N C-1598Live Oak, FLN2308Stinson SR-10J3 · S/N 5924Live Oak, FLN2502FChampion 7ECA · S/N 152Live Oak, FLN2570FChampion 7ECA · S/N 201Built 1965 · Live Oak, FLN26374Aeronca 65-C · S/N C8370Built 1940 · Live Oak, FLN2772MPiper PA-12 · S/N 12-1245Built 1946 · Live Oak, FLN28099Piper J3C-65 · S/N 4577Built 1940 · Live Oak, FLN28880Luscombe 8B · S/N 1622Built 1940 · Live Oak, FLN301KMPyle Kent E SPACEWALKER II · S/N 001KEPLive Oak, FLN3109EAeronca 7CCM · S/N 7AC-6706Built 1946 · Live Oak, FLN3115LCurtiss-Robertson ROBIN · S/N 55Live Oak, FLN323ECurtiss Wright ROBIN · S/N 288Live Oak, FLN323JCurtiss Wright ROBIN C-2 · S/N 480Built 1929 · Live Oak, FLN323RStinson SR-9C · S/N 5324Live Oak, FLN3312EAeronca 7AC · S/N 7AC-6756Built 1947 · Live Oak, FLN33738Aeronca 65-CA · S/N C13061Live Oak, FLN337XCahill William F BOWERSFLY BABY 1A · S/N 1C71Built 1971 · Live Oak, FLN34130Commonwealth REARWIN 185 · S/N 1835Built 1946 · Live Oak, FLN3523Scarborough LINCOLN REPLICA · S/N S-1Live Oak, FLN5031KBellanca 7ECA · S/N 1282-79Live Oak, FLN6213NAeronca 11AC · S/N 11AC1145Live Oak, FLN6341NChampion 7ECA · S/N 328Built 1967 · Live Oak, FLN70499Harrison Larry D FLYING FLEA · S/N 6Built 2004 · Live Oak, FLN81138Funk B85C · S/N 268Built 1946 · Live Oak, FLN8397Curtiss Wright ROBIN · S/N 270Live Oak, FLN8733VBellanca 7GCAA · S/N 316-75Live Oak, FLN9020Johnson ROCKET 185 · S/N 10Live Oak, FLN9051EAeronca 11AC · S/N 11AC-682Built 1946 · Live Oak, FLN91843Schweizer SGU 2-22 · S/N 16Built 1946 · Live Oak, FLN92827Commonwealth 185 · S/N 1623Live Oak, FLN9284EAeronca 11AC · S/N 11AC-921Built 1946 · Live Oak, FLN92920Commonwealth 185 · S/N 1855Built 1946 · Live Oak, FLN93284Rearwin 185 · S/N 1848Built 1946 · Live Oak, FLN9509LAmerican AA-1B · S/N AA1B-0031Built 1972 · Live Oak, FLN9949CSilvaire LUSCOMBE 8F · S/N S-53Built 1959 · Live Oak, FL
Back to Dexter Fred H