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.

N5450TCessna 172E · S/N 17251350Cancelled Nov 25, 1964 · Eielson Afb Aero ClubN2601MPiper PA-12 · S/N 12-959Cancelled Oct 21, 1964 · Exported to Canada · Built 1946 · Wenger Tim JN5030CBeech B35 · S/N D-2292Cancelled Oct 8, 1964 · Seattle Pilots IncN94891Ercoupe 415-G · S/N 5019Cancelled Sep 30, 1964 · Peter Vike JrN56589Douglas DC3C-S1C3G · S/N 4400Cancelled Jul 21, 1964 · Exported to Uruguay · West Coast Airlines IncN62373Douglas DC3C · S/N 19212Cancelled Jul 16, 1964 · Exported to Uruguay · West Coast Airlines IncN95490Douglas C54D-DC · S/N 10774Cancelled Jun 18, 1964 · Exported to Guinea · Built 1947 · Alaska Airlines IncN91306Douglas DC-6B · S/N 43826Cancelled Jun 15, 1964 · Built 1953 · Alaska Airlines IncN4004EAeronca 11BC · S/N 11BC-92Cancelled May 13, 1964 · Reverman Henry JN8677XCessna 180A · S/N 50128Cancelled May 13, 1964 · Exported to Canada · Reverman Henery JN5635ECessna 150 · S/N 17135Cancelled Apr 28, 1964 · Exported to Canada · Aero Flight IncN6442CBeech C-45 · S/N 44-87275Cancelled Mar 26, 1964 · Seattle School District No 1N6118CDouglas DC-6A · S/N 45243Cancelled Nov 29, 1963 · Alaska Airlines IncN6574KRepublic RC-3 · S/N 847Cancelled Nov 8, 1963 · Buhts Roderick LN6090KRepublic RC-3 · S/N 273Cancelled Nov 7, 1963 · Noble William LeeN2707Fairchild F-27 · S/N 32Cancelled Nov 4, 1963 · West Coast Airlines IncN28835Luscombe 8A · S/N 1577Cancelled Oct 10, 1963 · Exported to Canada · Oneill James PN53313Consolidated Vultee BT-13B (SNV-2) · S/N 79-843Cancelled Jul 23, 1963 · Built 1945 · Foreign And Domestic Enterprises IncN1404ZBeech A45 · S/N G-817Cancelled Jun 28, 1963 · United States Air Force Elmendorf Afb Aero ClubN3614MPiper PA-12 · S/N 12-2460Cancelled Apr 26, 1963 · Kelsay William KeithN2916NCessna 120 · S/N 13177Cancelled Apr 24, 1963 · Scowden Ralph R CaptN9755ZDehavilland L20A · S/N 355Cancelled Jan 25, 1963 · Exported to Australia · Hansen Harold JN1554VLockheed L-749A · S/N 2555Cancelled Sep 23, 1962 · Pacific Northern Airlines IncN7931CDouglas C-47B · S/N 25839Cancelled Sep 4, 1962 · Exported to Peru · Built 1944 · Smith Edward R & Rekow Lloyd AN29JHoward DGA-15P · S/N 701Cancelled Jun 20, 1962 · Exported to Canada · Built 1942 · Jobmaster CoN4663EAeronca 7EC · S/N 7EC-11Cancelled Jan 11, 1962 · Elmendorf Air Force Base Aero ClubN2840BBell 47J · S/N 1429Cancelled Dec 1, 1961 · Exported to Canada · Aero BoeingN33059Piper J-3 · S/N 5816Cancelled Aug 28, 1961 · Exported to Mexico · Hargreaves PhilipN79909Noorduyn UC-64AS · S/N 242Cancelled Jul 27, 1961 · Exported to Canada · Alaska Airlines IncN91JHoward DGA-15P · S/N 533Cancelled Jun 22, 1961 · Exported to Canada · Jobmaster CompanyN3968EAeronca 11BC · S/N 11BC-53Cancelled Dec 20, 1960 · Exported to Colombia · Hart Floyd E JrN40836Piper J3L-65 · S/N 7539Cancelled Dec 12, 1960 · Exported to Canada · Jack Woodrow WN1949NCessna 120 · S/N 12189Cancelled Sep 26, 1960 · Exported to Canada · Boeing Employees Flying Association IncN56540Noorduyn UC-64 · S/N 440Cancelled Sep 20, 1960 · Exported to Canada · Alaska Airlines IncN1705VCessna 120 · S/N 13890Cancelled Sep 10, 1960 · Exported to Canada · Boeing Employees Flying Association IncN94812Ercoupe 415-E · S/N 4925Cancelled Jun 2, 1960 · Exported to Canada · Evans O GN8813CPiper PA-22 · S/N 22-1425Cancelled Sep 25, 1959 · Cruisers IncN29381Culver LCA · S/N 170Cancelled Sep 15, 1959 · Built 1940 · Nelson Ernest LN9480EAeronca 11AC · S/N 11AC-1116Cancelled Jul 8, 1959 · Built 1946 · Clark Harold MN6539ACessna 180 · S/N 32436Cancelled Jun 22, 1959 · Exported to Canada · Marine Medical Mission IncN1835PPiper PA-22-150 · S/N 22-2615Cancelled Feb 17, 1959 · Exported to Canada · Efford M D Robert JN18280Sport-Flugzeubau GOPPINGEN 1 WOLF · S/N MK1-BCancelled Jan 16, 1959 · Built 1939 · Bowers Peter MN4638EAeronca S7CCM · S/N 7CCM-203Cancelled Jan 2, 1959 · Fields Edward ON91852Schweizer SGU 2-22 · S/N 24Cancelled Sep 22, 1958 · Exported to Canada · Robertson Joseph MN9292KStinson 108-2 · S/N 108-2292Cancelled Jun 23, 1958 · Built 1947 · Louthan B HN1921NCessna 120 · S/N 12165Cancelled May 7, 1958 · Exported to Canada · Keller Gene WardN41703Culver LFA · S/N 427Cancelled May 1, 1958 · Sweet GodfreyN4222HPiper PA-14 · S/N 14-25Cancelled Mar 7, 1958 · Mile 26 Flying Club IncN41809Boeing 247D · S/N 1699Cancelled Feb 26, 1958 · Exported to Canada · Central Aircraft IncN43976Taylorcraft BC12-D · S/N 7635Cancelled Jan 9, 1958 · Keiser Howard
Back to Seattle, WA