Seattle, WA

Cancelled registrations · 1,563

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_state = 'WA' AND d.registrant_city = 'SEATTLE'
  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.

N738XXCessna 172N · S/N 17270328Cancelled Sep 10, 1986 · Hartley Daniel BN797ASBoeing 727-90C · S/N 19169Cancelled Jan 3, 1986 · Exported to Canada · Built 1966 · Alaska Airlines IncN6761GCessna 150L · S/N 15072261Cancelled Jan 2, 1986 · Atsugi Navy Flying ClubN770BEBoeing 720-024B · S/N 18419Cancelled Nov 25, 1985 · Boeing Equipment Holding CoN60665Cessna 150J · S/N 15070487Cancelled Oct 22, 1985 · Iwakuni Flying ClubN7573ABoeing 707-123B · S/N 19323Cancelled Oct 15, 1985 · Built 1966 · Boeing Equipment Holding CoN7570ABoeing 707-123B · S/N 19186Cancelled Oct 9, 1985 · Built 1966 · Boeing Equipment Holding CoN7589ABoeing 707-123B · S/N 19339Cancelled Oct 9, 1985 · Boeing Equipment Holding CoN7554ABoeing 707-123B · S/N 19185Cancelled Oct 1, 1985 · Boeing Equipment Holding CoN52363Cessna 172P · S/N 17274502Cancelled May 8, 1985 · Ream Norman LN354ASBoeing 747-287B · S/N 21189Cancelled Jun 6, 1984 · Exported to United Kingdom · Boeing Equipment Holding CoN5498KCessna 172P · S/N 17274163Cancelled Feb 14, 1984 · Exported to Canada · Sommer MarkN45733Boeing 737-2Z6 · S/N 23059GCancelled Feb 2, 1984 · Built 1983 · Boeing CoN1776QBoeing 720-048 · S/N 18041Cancelled Nov 23, 1983 · Administratively canceled · Aeroamerica IncN4563HBoeing 737-2T4 · S/N 22700Cancelled Oct 13, 1983 · Exported to Algeria · Boeing Domestic Sales CorpN733TBoeing 720-027 · S/N 18581Cancelled Oct 12, 1983 · Aeroamerica IncN45742Boeing 767-200 · S/N 22922Cancelled Jul 11, 1983 · Exported to Brazil · Built 1983 · Boeing International Sales CorpN4575LBoeing 767-200 · S/N 22923Cancelled Jul 11, 1983 · Exported to Brazil · Built 1983 · Boeing International Sales CorpN1160QCessna T210L · S/N 21059660Cancelled Jun 25, 1983 · Administratively canceled · Upanaway Aircraft CorporationN4574MBoeing 767-2Q4 · S/N 22921Cancelled Jun 24, 1983 · Exported to Brazil · Built 1983 · Boeing International Sales CorpN6640NCessna 210N · S/N 21063130Cancelled May 27, 1983 · Domingues Kenneth VN3890DCessna 182A · S/N 34590Cancelled Apr 29, 1983 · Flying Goose Aviation NcN757BBoeing 757-236 · S/N 22172Cancelled Apr 13, 1983 · Exported to United Kingdom · Boeing CoN4571ABoeing 737-2E7 · S/N 22876Cancelled Mar 16, 1983 · Exported to Israel · Built 1982 · Boeing International Sales CorpN45708Boeing 737-2V6 · S/N 22875Cancelled Mar 3, 1983 · Exported to Israel · Boeing International Sales CorpN1032ZWickham James M MODEL-E · S/N 1Cancelled Dec 11, 1982 · Administratively canceled · Wickham James MN5873NRockwell International 114 · S/N 14418Cancelled Nov 12, 1982 · Built 1978 · Robird EnterprisesN45591Luscombe 8A · S/N 2118Cancelled Sep 16, 1982 · Exported to Canada · Built 1946 · Wasson Richard BN172KACessna 172M · S/N 17261431Cancelled Aug 12, 1982 · Administratively canceled · Robinson William TN747BABoeing 747-2B5B · S/N 20770Cancelled Jul 26, 1982 · Exported to South Korea · Boeing Equipment Holding CoN2737VBeech 35 · S/N D-117Cancelled Jul 22, 1982 · Built 1947 · Aure Martin HN6679LLake LA-4-200 · S/N 442Cancelled Jul 10, 1982 · Exported to Canada · Ansell H AlbertN1061LLake LA-4-200 · S/N 654Cancelled Apr 15, 1982 · Administratively canceled · New Horizons Aviation IncN6GKCessna R172K · S/N R1722729Cancelled Mar 30, 1982 · Exported to Canada · Puget Sound Flight Center IncN3192ECessna 172N · S/N 17271463Cancelled Mar 25, 1982 · Exported to Germany · Built 1978 · Wood Calvin TN47576Piper PA-28-161 · S/N 287816098Cancelled Mar 1, 1982 · Estep Max H JrN95172Piper PA-28-140 · S/N 28-25831Cancelled Jan 7, 1982 · Coble Clarence CN9651FHughes 269C · S/N 110081Cancelled Jan 7, 1982 · City Of SeattleN4619PPiper PA-23-250 · S/N 27-133Cancelled Dec 23, 1981 · Built 1960 · South Seattle Community CollegeN530HEnstrom Helicopter 280C · S/N 1025Cancelled Dec 18, 1981 · Richins A C & Diehl Paul LN36TPBeech A36TC · S/N EA100Cancelled Dec 12, 1981 · Built 1980 · Cosgrave Ronald FN8006UDouglas DC-8-21 · S/N 45283Cancelled Nov 12, 1981 · Sale reported · Built 1959N8019UDouglas DC-8-21 · S/N 45592Cancelled Nov 12, 1981 · Sale reported · Built 1959N707QTBoeing 707-700C · S/N 21956Cancelled Nov 6, 1981 · Exported to Morocco · Boeing Equipment Holding CoN692KXMccoy SPORTSMAN VJ-22 · S/N MC-100Cancelled Oct 20, 1981 · Mccoy William JN7514VCessna 177RG · S/N 177RG-0811Cancelled Oct 19, 1981 · Queen City Aviation IncN78977Mooney M20C · S/N 2011Cancelled Oct 19, 1981 · Exported to Canada · Sandell David WN91623Temco D-16 · S/N TTN-17Cancelled Oct 14, 1981 · Built 1946 · Fox Frank WN519BBeech 35 · S/N D1252Cancelled Oct 9, 1981 · Exported to Canada · Burkhard Donald CN61045Cessna 150J · S/N 15070760Cancelled Sep 21, 1981 · Iwakuni Flying Club
Back to Seattle, WA