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.

N2179CCessna 195B · S/N 16164Cancelled Nov 24, 1976 · Built 1955 · King Richard DN40120Boeing 737-268 · S/N 21282Cancelled Nov 23, 1976 · Exported to Saudi Arabia · Built 1976 · Boeing Third International Sales CorpN40112Boeing 737-284 · S/N 21302Cancelled Oct 29, 1976 · Exported to Greece · Built 1976 · Boeing Third International Sales CorpN73WJGrumman G-164 · S/N 9Cancelled Sep 7, 1976 · Nickele S Joseph JrN6224GCessna 150K · S/N 15071724Cancelled Sep 6, 1976 · Seattle Flight Service IncN982SCCessna 185B · S/N 185-0586Cancelled Jul 14, 1976 · Exported to Canada · Built 1963N16768Boeing 727-30 · S/N 18363Cancelled Jul 2, 1976 · Exported to Iran · Boeing Equipment Holding CoN61956Cessna 172M · S/N 17264913Cancelled Jun 22, 1976 · Exported to Canada · Lematta M EN12427Beech D-45 (T-34B) · S/N BG-356Cancelled May 28, 1976 · Built 1957 · United States NavyN772ESikorsky S-55 · S/N 52-7501Cancelled May 28, 1976 · Olympic Helicopters IncN85TABell 206B · S/N 1606Cancelled May 26, 1976 · Built 1975 · City Electric IncN26981Weaver BD-5B · S/N 2874Cancelled May 18, 1976 · Weaver Forest KN4034Scheibe SF-24B MOTORSPATZ · S/N 4034Cancelled May 14, 1976 · Exported to New Zealand · Built 1963 · Denniston George C JrN20822Cessna 172M · S/N 17263847Cancelled Apr 26, 1976 · Exported to Canada · R F B EnterprisesN1451ZBoeing 737-281 · S/N 20226Cancelled Apr 19, 1976 · Exported to China · Built 1976 · Boeing Equipment Holding CompanyN1238EBoeing 737-2N8 · S/N 21296Cancelled Jan 3, 1976 · Exported to Yemen · Built 1976 · Boeing Third International Sales CorporationN604XSikorsky S-55B · S/N 55459Cancelled Dec 22, 1975 · Trans Alaska Helicopters IncN7478ECessna 210 · S/N 57178Cancelled Oct 21, 1975 · Palmer StanN97135Stinson 108 · S/N 108-135Cancelled Oct 21, 1975 · Exported to Canada · Lavier Kenneth CN46479Cessna 172K · S/N 17257294Cancelled Sep 19, 1975 · Exported to Canada · Built 1968 · Skycraft IncN2614HErcoupe 415-C · S/N 3239Cancelled Aug 29, 1975 · Exported to Canada · Built 1946 · Faulkner Kenneth L & Hill Merrill JN3437APiper PA-22 · S/N 22-1709Cancelled Jul 11, 1975 · Exported to Canada · Hilyer Gale P JrN9290LAmerican AA-1A · S/N AA1A0190Cancelled May 28, 1975 · Aries AviationN6286GCessna 150K · S/N 15071786Cancelled May 9, 1975 · Galvin Flying Service IncN11383Cessna 150L · S/N 15075372Cancelled May 2, 1975 · Built 1973 · Ohara J HN9702CLockheed 188A · S/N 188A-1052Cancelled May 1, 1975 · Exported to Ecuador · Boeing CoN23419Cessna 150H · S/N 15068937Cancelled Apr 4, 1975 · Built 1968 · Galvin Flying Service IncN87569Boeing 737-241 · S/N 21006Cancelled Mar 10, 1975 · Exported to Brazil · Boeing International Sales CorpN1035Stits SA6B FLUT-R-BUG · S/N P-2106Cancelled Mar 5, 1975 · Verkler Arthur JN1507WBoeing 707-347C · S/N 20316Cancelled Feb 5, 1975 · Built 1969 · Boeing CompanyN1508WBoeing 707-347C · S/N 20317Cancelled Feb 5, 1975 · Boeing CoN1509WBoeing 707-347C · S/N 20318Cancelled Feb 5, 1975 · Boeing CoN1510WBoeing 707-347C · S/N 20319Cancelled Feb 5, 1975 · R C CurtissN94624Ercoupe 415-CD · S/N 4725Cancelled Sep 27, 1974 · Burgener Kenneth DN7212DPiper PA-22-150 · S/N 22-5036Cancelled Sep 23, 1974 · Fleury Alex CN7251DPiper PA-22-150 · S/N 22-5077Cancelled Sep 11, 1974 · Exported to Canada · Davenport Michael SN68654Sorrell John JA-3-80 · S/N 1Cancelled Aug 14, 1974 · Strathdee James DN8396UCessna 172F · S/N 17252296Cancelled Aug 12, 1974 · Exported to Canada · Lake Union Air Service IncN2378XCessna 182H · S/N 18256278Cancelled Jul 31, 1974 · Exported to Canada · Boeing Employees Flying Association IncN35369Cessna 172G · S/N 17256737Cancelled Jul 31, 1974 · Exported to Canada · Davis Douglas FN7743YPiper PA-30 · S/N 30-834Cancelled Jun 24, 1974 · Commanche Associates IncN5534TCessna 172E · S/N 17251434Cancelled Jun 7, 1974 · Exported to Canada · Skycraft IncN6772GCessna 150L · S/N 15072272Cancelled May 28, 1974 · Iwakuni Flying ClubN6327VHelio H-295 · S/N 1401Cancelled May 23, 1974 · Exported to Canada · Fleet Investment Co IncN3638EAeronca 11AC · S/N 11AC-1832Cancelled May 20, 1974 · Exported to Canada · Thorne Ned MN4649LCessna 172G · S/N 17254644Cancelled May 17, 1974 · Exported to Canada · Built 1966 · Boeing Employees Flying Association IncN77437Cessna 120 · S/N 11879Cancelled Apr 24, 1974 · Hubbard Floyd EN4291RPiper PA-32-300 · S/N 32-40668Cancelled Apr 23, 1974 · Built 1971 · H & S Leasing IncN5771LAmerican AA-1 · S/N AA1-0171Cancelled Apr 23, 1974 · Foster Vincent EN5861GCessna 150K · S/N 15071361Cancelled Apr 23, 1974 · Galvin Flying Service Inc
Back to Seattle, WA