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.

N6761ECessna 175A · S/N 56261Cancelled Apr 23, 1974 · Fernandez Donna RN6063PPiper PA-24-250 · S/N 24-1159Cancelled Mar 26, 1974 · Exported to Canada · Peterson Ellen MN88931Boeing 747-128 · S/N 20798Cancelled Mar 20, 1974 · Exported to France · Boeing Commercial AirplaneN9917VCessna 180H · S/N 18051769Cancelled Feb 26, 1974 · Exported to Canada · Herb LarsenN96597Hughes 269C · S/N 210092Cancelled Jan 25, 1974 · Exported to New Zealand · North American Helicopter Services IncN7126QCessna 172L · S/N 17260426Cancelled Jan 23, 1974 · Exported to Canada · Davis Douglas FN4790PPiper PA-23-250 · S/N 27-348Cancelled Oct 26, 1973 · Exported to Canada · Clough Equipment CoN4165WPiper PA-32-300 · S/N 32-40240Cancelled Oct 17, 1973 · Exported to Canada · Skycraft IncN3705XAero Commander 100-180 · S/N 5006Cancelled Sep 28, 1973 · Exported to Canada · Skycraft IncN2SWHughes 269A · S/N 43-0197Cancelled Aug 22, 1973 · Empire Helicopter & Aviation IncN2800NNorth American T-28A · S/N 50-258Cancelled Jun 26, 1973 · Tyer John WN5957LAmerican AA-1 · S/N AA1-0257Cancelled Jun 26, 1973 · Paul CarlstedtN1964TPiper PA-28-180 · S/N 28-7105197Cancelled Jun 25, 1973 · Seattle Flight Service IncN7287DPiper PA-18A · S/N 18-5706Cancelled Jun 25, 1973 · Culver JamesN43570Taylorcraft BC12-D · S/N 7229Cancelled Jun 22, 1973 · Built 1946 · Arthur D LN7705RBeech D55 · S/N TE-628Cancelled May 25, 1973 · Horton Dennis And Associates IncN78036Globe GC-1B · S/N 2036Cancelled Mar 12, 1973 · Exported to Canada · Turnquist John CN89866Cessna 140 · S/N 8911Cancelled Nov 15, 1972 · Bouchard ClaudeN3753FCessna 172H · S/N 17255248Cancelled Jun 28, 1972 · Exported to Canada · Farwest Construction CoN770ECessna 310 · S/N 35456Cancelled Jun 27, 1972 · Walker & Associates IncN2848DDehavilland BEAVER DHC-2 · S/N 358-FM173Cancelled Jun 23, 1972 · Exported to Canada · North Country IncN7958NPiper PA-28-180 · S/N 28-5374Cancelled Jun 6, 1972 · Exported to Canada · Built 1969 · Seattle Flight Service IncN879CStinson 108-3 · S/N 108-3879Cancelled May 17, 1972 · Exported to Canada · Lars G RombergN8131FCessna 150F · S/N 15064231Cancelled May 12, 1972 · Built 1966 · Seattle Navy Aero ClubN2723SCessna 150G · S/N 15066623Cancelled May 11, 1972 · Exported to Canada · Boeing Emplyees Flg Assn CorpN9099Arnesen BENSEN B8-M · S/N ARN-1Cancelled May 8, 1972 · Arnesen William TN8173UCessna 172F · S/N 17252073Cancelled Mar 30, 1972 · Exported to Canada · Morton Robert JN1688GChampion 7KCAB · S/N 74Cancelled Mar 20, 1972 · Exported to Canada · Airbatic-SportsN4899MPiper PA-11 · S/N 11-420Cancelled Feb 3, 1972 · Built 1947 · Harmon Aude VN2982GAir Camper SS-1 · S/N AYK-22Cancelled Jan 17, 1972 · William Sloan StevenN6348VHelio H-295 · S/N 1290Cancelled Dec 27, 1971 · Marine Vessels Associatin IncN93401Engineering & Research 415-C · S/N 724Cancelled Dec 3, 1971 · Shankland D DN5475Boeing 727-24C · S/N 19524Cancelled Nov 18, 1971 · Exported to Colombia · The Boeing CompamyN8320Boeing 727-24C · S/N 19526Cancelled Nov 18, 1971 · Exported to Colombia · Boeing CoN58737Fairchild Funk M-62CF-23B · S/N 2233AECancelled Sep 25, 1971 · Webb Harry DN13458Stinson JR. SR · S/N 8711Cancelled Aug 26, 1971 · Jack R DeanN250CUniversal Stinson 108-2 · S/N 108-3250Cancelled Aug 25, 1971 · Revoked, pending cancellation · Built 1947 · Tatom Jack LN2999GShelton Howard L TAYLOR SIRIUS · S/N 1-HSCancelled Jul 17, 1971 · Howard L SheltonN89937Cessna 140 · S/N 8989Cancelled Jul 15, 1971 · Jurgensen JohnN4329JPiper PA-28-140 · S/N 28-22704Cancelled Jul 14, 1971 · Govier Charles A & Myrtle E GovierN5796ACessna 172 · S/N 28396Cancelled Jul 14, 1971 · Falconers IncN8630HNorth American NAVION · S/N NAV-4-595Cancelled Jun 14, 1971 · Herb L RuffN49264Fairchild M-62A · S/N T43-5610Cancelled May 25, 1971 · Cawley Glen James Williams Bruce Hubbard John SheeN8712EBoeing 720-025 · S/N 18241Cancelled May 24, 1971 · Exported to Denmark · Boeing CoN8850MBeech S35 · S/N D-7361Cancelled Apr 19, 1971 · Exported to Canada · Maxfield Cyrus EN43738Taylorcraft BC12-D · S/N 7397Cancelled Mar 22, 1971 · Craft Leonard IrvinN22328Cessna 150H · S/N 15068218Cancelled Mar 19, 1971 · Exported to Canada · M & O Executive Training IncN5718ECessna 150 · S/N 17218Cancelled Mar 1, 1971 · Galvin Flying ServiceN6798SCessna 150H · S/N 15067598Cancelled Feb 25, 1971 · Galvin Flying Service IncN7556PPiper PA-24-250 · S/N 24-2764Cancelled Feb 10, 1971 · Fletcher Robert J
Back to Seattle, WA