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.

N49162Ryan Aeronautical ST3KR · S/N 2126Cancelled Dec 21, 1948 · Russell Wilmer R & Norman E WolfeN49214Consolidated Vultee BT-13A · S/N 2091Cancelled Nov 17, 1948 · Thompson Everett LN49269Ryan Aeronautical PT-22 · S/N 1449Cancelled Nov 17, 1948 · Fox Thomas DarrellN49250Fairchild M-62A · S/N T41-854Cancelled Nov 12, 1948 · Van Dyke Glen IN34595Aeronca 65-CA · S/N 16381Cancelled Sep 27, 1948 · Herkes Ray E & Raymond R KluthN22135Aeronca 50-C · S/N C-2369Cancelled Sep 2, 1948 · Olson Carroll And Powell Jean L And Glass George AN23531Aeronca 65-C · S/N 4859Cancelled Jun 18, 1948 · Built 1939 · Macfarlane R LN22544Stinson HW75 · S/N 7030Cancelled Jun 15, 1948 · Southwell James MurlanN1043NCessna AT 17B · S/N 3087Cancelled Jun 10, 1948 · Gardner Erwin EN1044NCessna T-50 · S/N 3193Cancelled Jun 10, 1948 · Gardner Erwin EN1002NFairchild PT-26A · S/N FT-675Cancelled Jun 9, 1948 · Buy-PlaneN1041NCessna UC-78B · S/N 5528Cancelled Jun 9, 1948 · Gardner Erwin EN49441Cessna T-50 · S/N 5067Cancelled May 12, 1948 · Sample Byron JN27555Taylorcraft BL-65 · S/N 2197Cancelled May 10, 1948 · Northern Aircraft CoN218KArrow Aircraft & Motors ARROW SPORT · S/N 417Cancelled Apr 29, 1948 · Dehaan Paul HenryN79KBird BK · S/N 2010-69Cancelled Apr 14, 1948 · Eugene Paul WebbN9150Fairchild 71 · S/N 635Cancelled Apr 7, 1948 · Exported to Canada · Built 1929 · Elliott E WN1974Boeing B1E · S/N 1Cancelled Apr 1, 1948 · Seattle Historical SocietyN5821Waco GXE · S/N 1508Cancelled Mar 31, 1948 · Severson Harold FN835MBoeing 40-B-4 · S/N 1160Cancelled Feb 18, 1948 · Exported to Peru · Built 1929 · Boeing Airplane CoN836MBoeing 40-B-4 · S/N 1161Cancelled Feb 18, 1948 · Exported to Peru · Built 1929 · Boeing Airplane CoN49246Fairchild M-62A · S/N T42-1980Cancelled Jan 6, 1948 · Van Dyke Glen IN86614Grumman G-44A · S/N 1440Cancelled Dec 16, 1947 · Patty Ernest N JrN1362EAeronca 7AC · S/N 7AC-4923Cancelled Dec 2, 1947 · Washington Aircraft & Transport CorpN85588Aeronca 7AC · S/N 7AC-4331Cancelled Nov 13, 1947 · Northern Commercial CompanyN49439Cessna T-50 · S/N 6221Cancelled Oct 16, 1947 · Arthur Fremont Johnstone DBA Northern Aircraft CoN18585Beech E17B · S/N E17B-189Cancelled Dec 12, 1946 · Built 1937 · Clark Theodore EdwardN49282Consolidated Vultee BT-13A · S/N 6541Cancelled Oct 10, 1946 · Swann James PN92909Commonwealth 185 · S/N 1640Cancelled Oct 10, 1946 · Johnstone A F /DBA Northern Aircraft CoN49288Boeing PT-17 · S/N 75-1612Cancelled Jun 22, 1946 · Built 1941 · Thomas A Edison Vocational SchoolN23519Aeronca 65-C · S/N C-4659Cancelled Jun 3, 1946 · Built 1939 · Arthur Douglas LN49129Interstate S-1B1 · S/N 227Cancelled Mar 15, 1945 · Sulak A F DBA Sulak Manufacturing CoN34413Aeronca 65-CA · S/N CA14461Cancelled Oct 14, 1943 · Flying Twenty Club IncN16446Beech C17L · S/N C17L-105Cancelled Aug 6, 1943 · Built 1936 · H L E Meyer Jr & CoN20818Piper J-3 · S/N 2118Cancelled May 3, 1943 · Hartzell Thomas WoodrowN41548Piper J3C-65 · S/N 8222Cancelled Jul 29, 1942 · U S Government Navy DepartmentN41549Piper J3C-65 · S/N 8203Cancelled Jul 29, 1942 · U S Government Navy DepartmentN602MFleet 7 · S/N 176Cancelled Jun 24, 1941 · Washington Aircraft & Transport CorpN7824Monocoupe 113 · S/N 263Cancelled Oct 15, 1940 · Davis R HN12413Aeronca C-3 · S/N A-179Cancelled Sep 26, 1940 · Jensen Harry JN6663AV Roe AVRO 594 AVIAN IV · S/N 169Cancelled Jul 1, 1940 · Wilson James RonaldN13751Kinner SPORTSTER K · S/N A-1721Cancelled Mar 10, 1940 · Built 1933 · Soderlund Floyd OscarN16482Arrow F · S/N 4Cancelled Apr 29, 1939 · Frank E ParsleyN7755Bryon Carr Moore NB · S/N 23Cancelled Apr 25, 1939 · Moore Byron CarrN19901Boeing S307 · S/N 1994Cancelled Mar 18, 1939 · Built 1938 · Boeing Aircraft CoN19784Aeronca KS · S/N K281Cancelled Mar 12, 1939 · Built 1937 · Washington Aircraft & Transport CorpN2734Lincoln Standard LINCOLN STANDARD · S/N A-1024Cancelled Feb 20, 1939 · Built 1924 · Miller C F / Hill HughN175MSavoia Marchetti S-55-P · S/N 10520Cancelled Aug 15, 1938 · Alaska Airways IncN12740Vieweg Otto C O V 1 GLIDER · S/N 14-VCancelled Oct 15, 1937 · Built 1931 · Neyland HomerN20KSavoia Marchetti S-55-P · S/N 10517Cancelled Sep 30, 1937 · Built 1929 · Alaska Airways Inc
Back to Seattle, WA