Kenmore Air Harbor LLC

Registered aircraft · 28

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 = 'KENMORE AIR HARBOR LLC' OR list_contains(g.other_registrant_names, 'KENMORE AIR HARBOR LLC')
  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.

N1433ZDehavilland-Kenmore DHC-2 · S/N 595Kenmore, WAN1455TDehavilland DHC 2 MK III · S/N 1647TB26Kenmore, WAN17598Dehavilland BEAVER DHC-2 MK.1 · S/N 1129Built 1958 · Kenmore, WAN390CCPiper/Cub Crafters PA-18-150 · S/N 9944CCBuilt 2002 · Kenmore, WAN426KMCessna 208 · S/N 20800306Built 1999 · Kenmore, WAN50KADehavilland DHC-3 · S/N 221Built 1956 · Kenmore, WAN58JHDehavilland-Hansen DHC-3 · S/N 131Kenmore, WAN606KADehavilland DHC-3 · S/N 37Built 1954 · Kenmore, WAN619MACessna 208B · S/N 208B2192Built 2010 · Kenmore, WAN64389Dehavilland BEAVER DHC-2 MK.1 · S/N 1637Built 1966 · Kenmore, WAN702KADehavilland Canada DHC-3 · S/N 54Built 1954 · Kenmore, WAN707KADehavilland DHC-3 · S/N 106Kenmore, WAN709KADehavilland DHC-3 · S/N 410Built 1960 · Kenmore, WAN72KACessna 208B · S/N 208B0326Built 1992 · Kenmore, WAN737NRCessna 172N · S/N 17269550Built 1977 · Kenmore, WAN765KADehavilland DHC-3 · S/N 26Built 1953 · Kenmore, WAN76KADehavilland DHC-3 · S/N 300Built 1958 · Kenmore, WAN830RRPilatus PC-12/47E · S/N 1149Built 2009 · Kenmore, WAN87KADehavilland DHC-3 · S/N 11Built 1953 · Kenmore, WAN89KACessna 172M · S/N 17261114Built 1973 · Kenmore, WAN900KADehavilland DHC-2 MK.I · S/N 1676Built 1967 · Kenmore, WAN903DPCessna 208B · S/N 208B0703Built 1999 · Kenmore, WAN90422Dehavilland DHC-3 · S/N 152Built 1955 · Kenmore, WAN95RCDehavilland BEAVER DHC-2 MK.1 · S/N 970Built 1956 · Kenmore, WAN9666PPiper PA-18-150 · S/N 18-7509011Built 1974 · Kenmore, WAN9744TDehavilland BEAVER DHC-2 MK.3 · S/N 1692Built 1968 · Kenmore, WAN9766ZDehavilland BEAVER DHC-2 MK.1 · S/N 504Built 1953 · Kenmore, WAN9815GCessna 172L · S/N 17259715Built 1971 · Kenmore, WA
Back to Kenmore Air Harbor LLC