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.

N532PCCessna A185F · S/N 185-02830Cancelled Apr 20, 2005 · Triennial form not returned · Built 1975 · Gehlen John NN5246YBeech U-8F · S/N 62-3869Cancelled Apr 13, 2005 · Triennial form not returned · South Seattle Community CollegeN8407CPiper PA-34-200T · S/N 34-7670137Cancelled Apr 13, 2005 · Triennial form not returned · Built 1976 · Airpac Airlines IncN323CTBoeing 737-8BK · S/N 33023Cancelled Apr 7, 2005 · Exported to India · Boeing CompanyN722LJAero Commander 680T · S/N 1538-5Cancelled Mar 15, 2005 · Exported to Venezuela · Built 1966 · Performance Plus LLCN3775Boeing 737-832 · S/N 30826Cancelled Mar 10, 2005 · Exported to Spain · Boeing CompanyN743ASBoeing 737-210C · S/N 21821Cancelled Jan 12, 2005 · Triennial form not returned · Built 1979 · Alaska Airlines IncN942EWEurocopter AS 350 B2 · S/N 1942Cancelled Jan 11, 2005 · Exported to Canada · Built 1995 · Astar N2491y LLCN4458VBeech 35 · S/N D-1274Cancelled Nov 19, 2004 · Triennial form not returned · Built 1948 · Sewell Sam S IIIN492USFokker F.28 MK4000 · S/N 11159Cancelled Nov 9, 2004 · Exported to Ecuador · Built 1980 · Horizon Air Industries IncN490USFokker F.28 MK4000 · S/N 11152Cancelled Nov 5, 2004 · Triennial form not returned · Built 1980 · Horizon Air Industries IncN707BZBoeing 737-7BC · S/N 32970Cancelled Sep 17, 2004 · Exported to Bermuda · Built 2001 · Boeing CoN60SMBell 206-L4 · S/N 52176Cancelled Jul 21, 2004 · Exported to Canada · Built 1996 · Long Ranger LLCN5547BCessna 182 · S/N 33547Cancelled Jun 30, 2004 · Sale reported · Built 1956 · Gore Kenley BN182QSBoeing 737-7BC · S/N 32575Cancelled Mar 17, 2004 · Exported to Brazil · Built 2001 · Boeing Domestic Sales CorpN728PKRobinson Helicopter R44 · S/N 0728Cancelled Dec 16, 2003 · Exported to Sweden · Built 2000 · Kummerman AlexN375BCBoeing 737-8EV · S/N 33079Cancelled Dec 11, 2003 · Exported to Belarus · Built 2001 · Boeing Aircraft Holding CorpN73718Boeing 747-243B · S/N 23301Cancelled Dec 9, 2003 · Exported to Iceland · Boeing Aircraft Holding CoN5540BCessna 182 · S/N 33540Cancelled Oct 9, 2003 · Triennial form not returned · Built 1956 · Outous Ronald WN594HABoeing 767-3CB · S/N 33469Cancelled Sep 8, 2003 · Exported to Bermuda · Built 2003 · Boeing CompanyN497USFokker F.28 MK4000 · S/N 11173Cancelled Aug 1, 2003 · Exported to Burkina Faso · Built 1981 · Horizon Air Industries IncN1105XMcdonnell Douglas C17 · S/N 02-1105Cancelled Jul 9, 2003 · Boeing CoN4HAerospatiale AS 365 N2 DAUPHIN · S/N 6450Cancelled May 20, 2003 · Exported to Belgium · Built 1992 · Otter CorpN38GFCessna 172P · S/N 17275161Cancelled May 7, 2003 · Triennial form not returned · Built 1981 · Galvin Flying Service IncN147MAGrumman S2F-3 · S/N 147531Cancelled May 6, 2003 · Triennial form not returned · Built 1959 · South Seattle Community CollegeN374BJBoeing 737-8DP · S/N 32451Cancelled Feb 28, 2003 · Exported to Saudi Arabia · Built 2001 · Boeing Aircraft Holding CoN22757Beech U-8D · S/N 57-6072Cancelled Feb 20, 2003 · Triennial form not returned · South Seattle Community CollegeN2658KCessna 180K · S/N 18053030Cancelled Feb 10, 2003 · Built 1979 · Westlake Marina LLCN713BABoeing 747-200F · S/N 22169Cancelled Jan 24, 2003 · Exported to Ghana · Boeing Aircraft Holding CoN355BJBoeing 737-7AJ · S/N 33499Cancelled Nov 5, 2002 · Exported to Saudi Arabia · Boeing Aircraft Holding CoN747ERBoeing 747-438 · S/N 32909Cancelled Oct 30, 2002 · Exported to Australia · Built 2002 · Boeing Aircraft Holding CoN4708RCessna TU206G · S/N U20606807Cancelled Oct 11, 2002 · Exported to Mexico · Built 1984 · Pacific Rubber IncorporatedN215BABoeing 747-SR-81 · S/N 22291Cancelled Oct 8, 2002 · Exported to Israel · Boeing Aircraft Holding CoN373JMBoeing 737-7FG · S/N 33405Cancelled Sep 26, 2002 · Exported to Saudi Arabia · Boeing CoN73724Boeing 757-258 · S/N 24254Cancelled Sep 26, 2002 · Exported to Canada · Boeing Aircraft Holding CoN372BCBoeing 737-7DP · S/N 32805Cancelled Jun 7, 2002 · Exported to Saudi Arabia · Built 2001 · Boeing CoN73795Boeing 747SR-100 · S/N 21925Cancelled Jun 6, 2002 · Boeing Aircraft Holding CoN207BABoeing B-747-200F · S/N 22482Cancelled May 31, 2002 · Exported to Ghana · Boeing Aircraft Holding CoN111PHRobinson Helicopter R44 · S/N 0972Cancelled Apr 2, 2002 · Built 2001 · Howard PatN2013KAmerican Blimp A-60+ · S/N 02Cancelled Mar 29, 2002 · Second triennial mailing, no response · American Blimp CorporationN73712Airbus Industrie A340-313 · S/N 117Cancelled Feb 28, 2002 · Exported to Germany · Boeing Aircraft Holding CoN793BABoeing 747-300 SERIES · S/N 23029Cancelled Jan 24, 2002 · Exported to Singapore · Boeing Aircraft Holding CoN791BABoeing 747-246B · S/N 20505Cancelled Jan 9, 2002 · Boeing Aircraft Holding CoN792BABoeing 747-312 · S/N 23026Cancelled Jan 9, 2002 · Boeing Aircraft Holding CoN979ANBoeing 737-823 · S/N 29551Cancelled Dec 13, 2001 · Exported to Australia · Boeing CompanyN980ANBoeing 737-823 · S/N 30101Cancelled Dec 12, 2001 · Exported to Australia · Boeing CompanyN981ANBoeing 737-823 · S/N 30897Cancelled Dec 12, 2001 · Exported to Australia · Boeing CompanyN982ANBoeing 737-823 · S/N 29552Cancelled Dec 12, 2001 · Exported to Australia · Boeing CompanyN983ANBoeing 737-823 · S/N 30899Cancelled Dec 12, 2001 · Exported to Australia · Boeing CompanyN984AMBoeing 737-823 · S/N 29553Cancelled Dec 12, 2001 · Exported to Australia · Boeing Company
Back to Seattle, WA