OpenAirDocs.org
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.

N815WPUav Solutions TALON 120LE · S/N 134Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Old World Properties LLCN816WPUav Solutions TALON 120LE · S/N 135Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Old World Properties LLCN160RLBeech 58 · S/N TH-60Cancelled Jan 3, 2020 · Registration expired, pending cancellation · Built 1970 · Atomic Aircraft Maintenance LLCN6153QCessna 320F · S/N 320F-0003Cancelled Dec 3, 2019 · Registration expired, pending cancellation · Built 1967 · Bird James AN332AFUav Solutions TALON 120LE · S/N 125Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Old World Properties LLCN42127Piper J3C-65 · S/N 14353Cancelled Nov 25, 2019 · Revoked, pending cancellation · Built 1945 · Foster John EN28711Luscombe 8A · S/N 1472Cancelled Nov 22, 2019 · Revoked, canceled · Built 1940 · Gingras Peter PN2974GBensen B-8M · S/N 2Cancelled Nov 22, 2019 · Revoked, canceled · Built 1964 · Lock Edward RN784ZXDJI PHANTOM 2 VISION PLU · S/N PH645314915-V2Cancelled Nov 18, 2019 · Third renewal notice · U S Dept Of LaborN486APApple.Aero LLC DBA Applewhite INVENIO · S/N 20122Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Built 2013 · Applewhite Aero LLCN64RYRyka Communications LLC DBA RY QUAD 8 · S/N RY0001Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Ryka Communications LLC DBAN418QXBombardier DHC-8-402 · S/N 4143Cancelled Oct 7, 2019 · Exported to Canada · Built 2007 · Horizon Air Industries IncN680LUUniversity Of Washington SKYWALKER X8 · S/N 201601Cancelled Oct 5, 2019 · Registration expired, pending cancellation · University Of WashingtonN102KADJI PHANTOM 2 · S/N PT646006760Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Ryka Communications LLC DBAN104KADJI PHANTOM 2 · S/N PT645234396Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Ryka Communications LLC DBAN37GTRhodes K/Kenney M RHODES-KENNEY 320 · S/N 001Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 2004 · Rhodes Kent AN489PAApple.Aero LLC DBA Applewhite JAGO · S/N 20131Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Applewhite Aero LLCN489YAApple.Aero LLC DBA Applewhite BALA · S/N 20132Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Applewhite Aero LLCN676ZLUniversity Of Washington SKYWALKER X8 · S/N 201505Cancelled Sep 6, 2019 · Registration expired, pending cancellation · University Of WashingtonN83482Aeronca 7AC · S/N 7AC-2153Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Heller David JN1174NFairchild PT-26A · S/N FZ221Cancelled Aug 29, 2019 · Revoked, canceled · Built 1943 · Dvorak EdN97768Stinson 108 · S/N 108768Cancelled Aug 5, 2019 · Revoked, canceled · Built 1946 · Paull CorpN535PAApplewhite Aero PGA1 · S/N 1Cancelled Jul 29, 2019 · Applewhite Aero LLCN3807DCessna 310 · S/N 35370Cancelled Jul 26, 2019 · Registration expired, pending cancellation · Macveigh Craig AN486LQApple.Aero LLC DBA Applewhite INVENIO · S/N 20121Cancelled Jul 25, 2019 · Registration expired, pending cancellation · Built 2013 · Applewhite Aero LLCN1049NFairchild M-62A · S/N FC186Cancelled Jul 3, 2019 · Revoked, canceled · Mccaslin Wesley CN77815Luscombe 8F · S/N 3542Cancelled Jul 3, 2019 · Revoked, canceled · Built 1946 · Rockwell J HN92621Piper J3C-65 · S/N 16982Cancelled Jul 3, 2019 · Revoked, pending cancellation · Built 1946 · Green James RN63APApple.Aero LLC DBA Applewhite INVENIO · S/N 20123Cancelled Jun 29, 2019 · Registration expired, pending cancellation · Built 2013 · Applewhite Aero LLCN36319Piper PA-34-200T · S/N 34-7870318Cancelled May 7, 2019 · Registration expired, pending cancellation · Built 1978 · Airpac Airlines IncN14519Republic P-47 · S/N 42-8205Cancelled May 6, 2019 · Registration expired, pending cancellation · Built 1942 · Windward Aviation IncN620NSStratis Imaging MODEL 2 · S/N 0000-0002Cancelled May 6, 2019 · Registration expired, pending cancellation · Stratis Imaging IncN621DSStratis Imaging MODEL 1 · S/N 0000-0001Cancelled May 6, 2019 · Registration expired, pending cancellation · Stratis Imaging IncN9459EAeronca 11AC · S/N 11AC1097Cancelled May 4, 2019 · Revoked, canceled · Built 1946 · Mcalister Henry L M SgtN606YSDJI PHANTOM 2 · S/N PH645256322Cancelled May 1, 2019 · Registration expired, pending cancellation · Parametrix IncN9865KStinson 108 · S/N 1082865Cancelled Apr 15, 2019 · Revoked, canceled · Built 1947 · Orenstein Stephen M 1st LtN327AFUas USA TEMPEST · S/N 080515-2Cancelled Mar 18, 2019 · Registration expired, pending cancellation · Vulcan IncN328AFUas USA TEMPEST · S/N 080515-3Cancelled Mar 18, 2019 · Registration expired, pending cancellation · Vulcan IncN5010MTaylorcraft BF · S/N 10310Cancelled Mar 9, 2019 · Revoked, pending cancellation · Built 1946 · StabbertsN2778EAeronca 7AC · S/N 7AC-6361Cancelled Mar 2, 2019 · Sale reported, canceled · Built 1946N315AFUas USA TEMPEST · S/N 080515-1Cancelled Feb 23, 2019 · Registration expired, pending cancellation · Vulcan IncN318AFFalcon Unmanned FALCON · S/N F033Cancelled Feb 23, 2019 · Registration expired, pending cancellation · Vulcan IncN11232DJI PHANTOM 3 PROFESSION · S/N P76DCE19014221Cancelled Feb 7, 2019 · Registration expired, pending cancellation · Aerial Scouts IncN11233DJI PHANTOM 3 ADVANCED · S/N P76DCG22011489Cancelled Feb 7, 2019 · Registration expired, pending cancellation · Aerial Scouts IncN80432Beech 35 · S/N D-32Cancelled Feb 5, 2019 · Registration expired, pending cancellation · Brewer Dorian LN8711FHughes 269A · S/N 111-0024Cancelled Jan 22, 2019 · Revoked, canceled · Built 1961 · Olympic Helicopters IncN224EAHawker Siddeley HS.125 SERIES 700A · S/N 257088Cancelled Jan 16, 2019 · Exported to Mexico · Built 1980 · Vica Aviation IncN26059Liddington BENSEN B-8M · S/N 1Cancelled Jan 14, 2019 · Revoked, canceled · Built 1976 · Liddington Steven LN578BCBoeing 747-4B5 · S/N 24619Cancelled Jan 10, 2019 · Boeing Aircraft Holding CoN392PAAmazon Logistics MK021 · S/N 000159Cancelled Jan 9, 2019 · Built 2017 · Amazon Logistics Inc
Back to Seattle, WA