Kenmore Air Harbor Inc

Earlier aircraft under this name · 25

Cancelled registrations that named this owner when they ended, newest first.

Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
  WHERE d.registrant_name = 'KENMORE AIR HARBOR INC' OR list_contains(d.other_registrant_names, 'KENMORE AIR HARBOR INC')
  ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"

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.

N6781LDehavilland BEAVER DHC-2 MK.1 · S/N 788Cancelled Jul 8, 2019 · Second renewal notice · Built 1953 · Kenmore, WAN167WDehavilland BEAVER DHC-2 MK.1 · S/N 8Cancelled Mar 24, 2015 · First renewal notice · Kenmore, WAN9777ZDehavilland BEAVER DHC-2 MK.1 · S/N 607Cancelled Mar 10, 2015 · Built 1972 · Kenmore, WAN1980UCessna A185E · S/N 18501725Cancelled Dec 13, 2013 · Exported to Canada · Built 1970 · Kenmore, WAN2748KCessna 180K · S/N 18053058Cancelled Mar 31, 2009 · Triennial form not returned · Built 1979 · Kenmore, WAN61181Cessna A185F · S/N 18504120Cancelled Nov 3, 2004 · Exported to Australia · Built 1980 · Kenmore, WAN234KADehavilland DHC-3 · S/N 42Cancelled Dec 9, 2002 · Exported to Canada · Kenmore, WAN25149Dehavilland DHC-2 · S/N 1520Cancelled Aug 26, 2002 · Exported to Canada · Built 1962 · Kenmore, WAN1018FDehavilland BEAVER DHC-2 · S/N 684Cancelled Mar 22, 2000 · Triennial form not returned · Kenmore, WAN83UDehavilland DHC-3 · S/N 371Cancelled Jan 9, 1998 · Exported to Canada · Kenmore, WAN75561Cessna 172N · S/N 172-67810Cancelled Jan 4, 1982 · Kenmore, WAN67685Dehavilland-Webber Airlines DHC-2 BEAVER · S/N 57-6158Cancelled Nov 2, 1981 · Exported to Australia · Kenmore, WAN7805KCessna 180J · S/N 18052739Cancelled Aug 8, 1977 · Exported to Canada · Kenmore, WAN52186Cessna 180J · S/N 18052544Cancelled Apr 21, 1975 · Exported to Canada · Kenmore, WAN1210MCessna 172L · S/N 17259410Cancelled Jan 30, 1974 · Exported to Canada · Built 1970 · Kenmore, WAN3810QCessna A185F · S/N 18502201Cancelled May 23, 1973 · Exported to Canada · Kenmore, WAN64390Dehavilland DHC-2 MK. I(L20A) · S/N 1203Cancelled Apr 11, 1973 · Exported to Canada · Kenmore, WAN9758ZDehavilland DHC-2 · S/N 397Cancelled May 10, 1972 · Exported to Canada · Kenmore, WAN4787XCessna 150G · S/N 15064837Cancelled Feb 7, 1972 · Exported to Canada · Kenmore, WAN4474BCessna 170B · S/N 26818Cancelled Jun 30, 1970 · Kenmore, WAN82554Aeronca 7AC · S/N 7AC-1191Cancelled Jun 30, 1970 · Kenmore, WAN4518FCessna A185E · S/N 185-1002Cancelled Dec 1, 1969 · Exported to Canada · Kenmore, WAN2148ZCessna 180F · S/N 18051248Cancelled Apr 21, 1969 · Exported to Canada · Kenmore, WAN1151CPiper PA-18A-135 · S/N 18-2209Cancelled Nov 8, 1963 · Kenmore, WAN39198Taylorcraft BC12-D · S/N 6450Cancelled Jul 11, 1958 · Exported to Canada · Kenmore, WA
Back to Kenmore Air Harbor Inc