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.

N9708CLockheed 188A · S/N 1106Cancelled Dec 10, 1969 · Exported to Peru · Boeing CoN2264TCessna A185E · S/N 185-1423Cancelled Oct 13, 1969 · Exported to Philippines · Built 1968 · Consolidated Services IncN62376Douglas DC3C · S/N 19978Cancelled Sep 26, 1969 · West Coast Airlines IncN6103DPiper PA-22-150 · S/N 22-4747Cancelled Sep 24, 1969 · Exported to Canada · Hester Wm FN1063APiper PA-18 · S/N 18-642Cancelled Sep 18, 1969 · Exported to Australia · Built 1951 · Angel Peter CN6011QMooney M20C · S/N 3228Cancelled Sep 9, 1969 · Exported to Canada · Rent-Aire IncN9710CLockheed 188A · S/N 188C1134Cancelled Sep 9, 1969 · Exported to Honduras · Boeing CoN18383Douglas C-54B · S/N 18383Cancelled Jul 28, 1969 · Exported to Canada · Griffith Glynn KN7319KPiper PA-20 · S/N 20-228Cancelled May 1, 1969 · Exported to Canada · Gordan HamiltonN4397DBeech E50 · S/N EH-63Cancelled Apr 14, 1969 · Exported to Canada · Huston W F DBA Huston AviationN78889Mooney M20F · S/N 680170Cancelled Jan 30, 1969 · Chamberlain Howard EN5326SCessna 337A · S/N 337-0426Cancelled Jan 28, 1969 · Galvin Flying Service IncN4144WPiper PA-32-300 · S/N 32-40126Cancelled Jan 3, 1969 · Exported to South Korea · M W K International LtdN67623Douglas B-26B · S/N 28977Cancelled Dec 13, 1968 · Overseas Aeromarine IncN46598Douglas B-26B · S/N 27694Cancelled Sep 18, 1968 · Overseas Aeromarine IncN4498APiper PA-18A 150 · S/N 18-4872Cancelled Sep 17, 1968 · Exported to Canada · Built 1956 · Nickerson William LN3909HErcoupe 415-C · S/N 4610Cancelled Jun 26, 1968 · Lloyd M LudvigsenN2023ZCessna 150C · S/N 15059823Cancelled Jun 24, 1968 · Exported to Canada · Galvin Flying ServiceN9101Douglas DC-9-12 · S/N 45794Cancelled Jun 13, 1968 · Built 1966 · West Coast Airlines IncN1445CPiper PA-22-135 · S/N 22-1212Cancelled Jun 3, 1968 · Exported to Canada · Burrell Edward CharlesN230EStinson SR-9E · S/N 5258Cancelled Apr 26, 1968 · Exported to Canada · Lewis Lorin FN6449TCessna 150 · S/N 17849Cancelled Jan 29, 1968 · Exported to Canada · Galvin Flying ServiceN7822ZCessna 150 · S/N 15059922Cancelled Jan 17, 1968 · Exported to Canada · Built 1963 · Galvin Flying ServiceN8244UCessna 172 · S/N 17252144Cancelled Nov 16, 1967 · Wood Lyle AN5132CBeech B35 · S/N D-2417Cancelled Nov 9, 1967 · WolfstoneN86523Lockheed L-749A · S/N 649A-2659Cancelled Jul 14, 1967 · Pacific Northern Airlines IncN4546BCessna 180 · S/N 31445Cancelled Jul 26, 1966 · Lana R KurtzerN73920Bell 47G-3B-1 · S/N 2808Cancelled Jun 9, 1966 · Exported to Canada · Built 1962 · Aero BoeingN9766ZMacchi LASA 60 · S/N 1024Cancelled Feb 18, 1966 · Exported to Guinea · Alaska AirlinesN202WBeech C18S · S/N 44-47620Cancelled Feb 17, 1966 · Learn H WayneN358TACessna 140 · S/N 10871Cancelled Dec 29, 1965 · Forrest Taylor Academy Of FlyingN88967Douglas DC3C · S/N 12863Cancelled Dec 2, 1965 · Exported to Uruguay · West Coast Airlines IncN1157KLuscombe 8A · S/N 3884Cancelled Nov 24, 1965 · Francis NicholsN26WDehavilland DH-104 · S/N 04352Cancelled Nov 15, 1965 · Arctic Pacific IncN63106Douglas DC3C · S/N 20434Cancelled Nov 12, 1965 · Exported to Taiwan · Jupitor Corporation Of WashingtonN93139Morphew SMITH MINIPLANE · S/N 1Cancelled Nov 1, 1965 · Robert H MorphewN2783XCessna 180H · S/N 18051583Cancelled Oct 11, 1965 · Exported to Philippines · Washington Aircraft & Transport DorpN98319Piper J3C-85 · S/N 18481Cancelled Jun 8, 1965 · Roy Alen TongueN1403ZBeech A45 · S/N G-266Cancelled Jun 2, 1965 · United States Air Force OwnerN34922Nelson BB-1 · S/N 506Cancelled May 26, 1965 · Exported to Canada · Built 1946 · Blauman Bruce BN66432Grumman G-44A · S/N 1323Cancelled May 25, 1965 · Built 1956 · Dukes Robert L & Flynn John H JrN83223Aeronca 7AC · S/N 7AC-1884Cancelled May 25, 1965 · Built 1946 · Mummey TedN5777ECessna 150 · S/N 17277Cancelled May 22, 1965 · Galvin Flying ServiceN6284DAero Commander 680 · S/N 680-583-225Cancelled May 22, 1965 · Simlog Equipment CoN21858Piper J3F-65 · S/N 2639Cancelled May 21, 1965 · Built 1938 · Verkler Arthur JN7158CCharles H Sorrell DFG · S/N 1Cancelled May 21, 1965 · Clark Jr Harold MN97532Stinson 108 · S/N 108-532Cancelled May 21, 1965 · Aeroplane Club IncN3397EAeronca 11AC · S/N 11AC-1723Cancelled May 20, 1965 · Richard E MitchellN1701LMacchi LASA 60 · S/N 6149Cancelled May 18, 1965 · Exported to Guinea · Alaska Airlines IncN76922Cessna 140 · S/N 11364Cancelled Apr 16, 1965 · Arrowflight Inc
Back to Seattle, WA