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.

N333FMLake LA-4-200 · S/N 527Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1972 · Walker Virgil FN769BABoeing 747-8HVF · S/N 37669Cancelled Sep 6, 2013 · Exported to Bermuda · Built 2013 · Boeing CoN2343NRobinson Helicopter R22 BETA · S/N 2191Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1992N9039WCottrill Eugene FOCKE WULF FW190 · S/N 125Cancelled Aug 21, 2013 · Sale reported, canceledN7820MFairchild FH-227B · S/N 558Cancelled Aug 20, 2013 · Sale reported, canceled · Built 1967N5720XCessna 320 · S/N 320-0020Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1961 · Whitley Thomas MN9756ZSikorsky H04S-1 · S/N 125513Cancelled Aug 7, 2013 · Revoked, canceled · Polaris Helicopters IncN1799KLuscombe 8E · S/N 4526Cancelled Aug 6, 2013 · Registration expired, pending cancellation · Built 1946 · Orr Harold LN527FAAndersen Frank R MINI-MAX · S/N MK-165Cancelled Jul 30, 2013 · Sale reported, canceledN7379NCessna U206G · S/N U20603643Cancelled Jul 30, 2013 · Sale reported, canceled · Built 1977N5103QCessna T210L · S/N 21059603Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Built 1972 · Northwest Brewers Grains IncN2228JCessna 150G · S/N 15065428Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Built 1966 · Kelmin Aviation IncN19222Cessna 150L · S/N 15074249Cancelled Jul 16, 2013 · Sale reported, canceled · Built 1972N8072VRobinson Helicopter R22 BETA · S/N 1313Cancelled Jul 16, 2013 · Registration expired, pending cancellation · Built 1990 · Puget Sound Helicopters IncN47902Schweizer SGS 2-8 · S/N 52Cancelled Jul 11, 2013 · Sale reported, canceledN77QRutan QUICKIE-54 · S/N 001Cancelled Jul 10, 2013 · Sale reported, canceled · Built 1978N62212Yost Mfg. RB-42 · S/N 103Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1974 · Tychsen Paul E JrN9094AMoore Jack B-8M · S/N 1Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1978N539DSBoeing 737-8FV · S/N 40819Cancelled Jun 19, 2013 · Boeing CoN1509HBalloon Works FIREFLY 8-24 · S/N F8002Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1982 · Wicks Enterprises IncN4247Sikorsky S-58B · S/N 58807Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1958 · Queen City Helicopters IncN958BABoeing 747-87UF · S/N 37563Cancelled Jun 14, 2013 · Exported to Saudi Arabia · Boeing CoN208TKKimball Thomas C VARI-EZE · S/N 2068Cancelled Jun 13, 2013 · Registration expired, pending cancellation · Kimball Thomas CN577Piper J3C-65 · S/N 22575Cancelled Jun 13, 2013 · Sale reported, canceled · Built 1946N681RDWeyerts Raymond H B2-RD · S/N IS011Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1984 · Day Richard JN782JMMooney M20C · S/N 2748Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1964 · Speegle Joe Thomas JrN8004UDouglas DC-8-21 · S/N 45281Cancelled Jun 10, 2013 · Sale reported, canceled · Built 1959N233WNOden William N SENIOR AERO SPORT · S/N 50Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Oden William NN36104Balloon Works FIREFLY 8-24 · S/N F8-006Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Wicks Enterprizes IncN444NJMelton James A VANS RV-4 · S/N 2186Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Melton James AN770RSchempp-Hirth STANDARD CIRRUS · S/N 75Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Pfeiffer Robison Holdings IncN2769CBensinger Williams I QUICKIE Q 2 · S/N 2124Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Bensinger William IraN2770HSolomon Glenn F KR 1 · S/N 1Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Built 1982 · Erwin David EN103VAEmbraer EMB-110P1 · S/N 110-204Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Built 1979 · Marta CorporationN1152TMooney M20K · S/N 25-0630Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Built 1981 · Lux Horst EN521DSBoeing 737-8FV · S/N 40611Cancelled May 20, 2013 · Exported to India · Built 2012 · Boeing CoN90678Commonwealth 185 · S/N 1803Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1946 · J C Corp IncN9072NRobinson Helicopter R22 · S/N 0211Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1981 · Skyball IncN8850Wilson BABY GREAT LAKES · S/N 6906M186BCancelled May 15, 2013 · Registration expired, pending cancellation · Built 1974 · Hansberry Orvus LN803QBeech 65 · S/N LC-12Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1960 · Bishop JerryN5243GCessna 310E · S/N 310M0021Cancelled May 10, 2013 · Sale reported, canceled · Built 1961N4091XAero Commander S2R · S/N 1922RCancelled May 9, 2013 · Sale reported, canceled · Built 1974N7854VMooney M20C · S/N 2817Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1964 · Grant Arnold PN79538Cessna 172K · S/N 17258159Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1969 · Seattle Navy Aero ClubN74963Piper PA-18-150 · S/N 18-7709043Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1976 · All Alaskan Seafoods IncN72655Cessna 172M · S/N 17267230Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1976 · Avx CorporationN730TBoeing 720-027 · S/N 18154Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1961 · Aeroamerica IncN7343PCessna P210N · S/N P21000006Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1978 · Webster Associates LLC DBAN734TBoeing 720-027 · S/N 18065Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1961 · Eisenberg Yvette LisaN738TDCessna 172N · S/N 17270217Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1977 · Bulzomi Frank D
Back to Seattle, WA