OpenAirDocs.org
Hayton James B

Registered aircraft · 32

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 = 'HAYTON JAMES B' OR list_contains(g.other_registrant_names, 'HAYTON JAMES B')
  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.

N19982Cessna 172M · S/N 17260909Built 1972 · Sedro Woolley, WAN23600Air Tractor AT-301 · S/N 301-0398Sedro Woolley, WAN2369EAeronca 7AC · S/N 7AC-5946Built 1946 · Sedro Woolley, WAN2495GCessna 182B · S/N 51795Built 1959 · Sedro Woolley, WAN28355Cessna 140A · S/N 15579Built 1950 · Sedro Woolley, WAN2973CCessna 180 · S/N 30873Built 1954 · Sedro Woolley, WAN2991KCessna 180K · S/N 18053154Sedro Woolley, WAN31618Dehavilland BEAVER U-6A · S/N 858Built 1956 · Sedro Woolley, WAN4262FCessna 172 · S/N 46162Built 1958 · Sedro Woolley, WAN4456ZPiper PA-18-150 · S/N 18-8803Sedro Woolley, WAN4494HPiper PA-15 · S/N 15-283First renewal noticeBuilt 1948 · Sedro Woolley, WAN4504NCessna A185F · S/N 18502550Sedro Woolley, WAN4528BCessna 180 · S/N 31427Built 1955 · Sedro Woolley, WAN4604MPiper PA-11 · S/N 11-108Sedro Woolley, WAN5238SAir Tractor AT-301 · S/N 301-0132Built 1978 · Sedro Woolley, WAN5317RCessna A185F · S/N 18503031Sedro Woolley, WAN62314Dehavilland BEAVER DHC-2 · S/N 56-366Sedro Woolley, WAN6327SCessna 150G · S/N 15067127First renewal noticeBuilt 1967 · Sedro Woolley, WAN64384Dehavilland BEAVER DHC-2 MK.1 · S/N 622Built 1954 · Sedro Woolley, WAN6661SCessna 150H · S/N 15067461Built 1967 · Sedro Woolley, WAN6697QGrumman Acft ENG Cor-Schweizer G-164B · S/N 207BBuilt 1977 · Sedro Woolley, WAN70206Cessna A185E · S/N 18502057Built 1972 · Sedro Woolley, WAN7938VCessna 180H · S/N 18051838Built 1967 · Sedro Woolley, WAN83283Piper PA-18-150 · S/N 18-7609065Built 1976 · Sedro Woolley, WAN83568Piper PA-18-150 · S/N 18-7709080Sedro Woolley, WAN85442Aeronca 7AC · S/N 7AC-4182Built 1946 · Sedro Woolley, WAN8651HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1446Sedro Woolley, WAN8886SAir Tractor AT-301 · S/N 301-0227Built 1979 · Sedro Woolley, WAN90758Dehavilland DHC-3 · S/N 455Sedro Woolley, WAN9839YChampion AERONCA 7FC · S/N 7FC-451Built 1961 · Sedro Woolley, WAN9928BCessna 182A · S/N 34328Sedro Woolley, WAN998BChampion 7KCAB · S/N 7KCAB-47Built 1967 · Sedro Woolley, WA
Back to Hayton James B