Skip to content

Cancelled registrations · 168

Query with SQL

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 = 'BELLEVUE' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 = 'BELLEVUE'
  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.

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 = 'BELLEVUE'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N429LEBell Helicopter Textron Canada 429 · S/N 57272Cancelled Feb 12, 2026 · Exported to Canada · Built 2015 · Evans James L N2655KCessna 180K · S/N 18053028Cancelled Mar 31, 2025 · Exported to New Zealand · Built 1978 · Cost Kenneth Lee Trustee N18LEEdvinson THORP T-18 · S/N 725Cancelled May 21, 2024 · Exported to Sweden · Built 1972 · Edvinson Lennart E N57TJAnthony L Jurcan SEAWIND 3000 · S/N 52Cancelled Mar 25, 2024 · Jurcan Anthony L N544DDXag P100 · S/N 82182503C10HCancelled Mar 16, 2024 · Sale reported, canceled N215ATDouglas A4D-2N · S/N 12795Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Pacific Aero Equipment LLC N220ATDouglas A4D-2N · S/N 12865Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Pacific Aero Equipment LLC N3844UCessna 336 · S/N 336-0144Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Built 1963 · Lysdale Steven J N651LJLearjet 24A · S/N 125Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Lysdale Steven J N717TTAllen Terry Robert VANS RV-7A · S/N 71282Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Allen Terry R N1679WBeech V35B · S/N D-9384Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Hesse Robert R C N132SGStemme S10-VT · S/N 11-032Cancelled Mar 25, 2022 · Exported to Spain · Built 1999 · Seclusion Valley LLC N8532XCessna P172D · S/N P17257132Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Built 1962 · Factoria Aircraft N88818Kasper 100 TAILLESS · S/N 1Cancelled Aug 2, 2020 · Revoked, canceled · Built 1973 · Kasper Aircraft Inc N717MWPphu Ekolot KR-010-ELF · S/N 01-01-07Cancelled Jun 12, 2020 · Sale reported, canceled · Built 2016 N73WSCessna 185A · S/N 18501645Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Factoria Aircraft N686SDJI INSPIRE 1 PRO · S/N CJ291444005794Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Cogan Thomas J N71693Cessna 182M · S/N 18259720Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Factoria Aircraft N3034KCulver V · S/N V253Cancelled Dec 9, 2019 · Revoked, canceled · Built 1946 · Sinkler S D N98296Piper PA-28-140 · S/N 28-26153Cancelled Nov 15, 2019 · Revoked, canceled · Built 1969 · Engstrom Richard K N9356UCessna 150M · S/N 15078305Cancelled Sep 11, 2019 · Exported to Thailand · Built 1976 N636SDJI INSPIRE 1 · S/N CA242320065577Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Cogan Thomas J N710XPSoftex Invest V-24L · S/N 14-03-05Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 2014 · Summit International American Ltd N4641ELowe Bruce VANS ACFT RV3 · S/N 11124Cancelled Mar 16, 2019 · Sale reported, canceled N504ZXTrimble Navigation ZX5 · S/N ZX5004 1507366Cancelled Jun 26, 2018 · Registration pending, canceled N244CBCessna 185C · S/N 185-0727Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1964 · Lysdale Steven J N9002MCessna 180H · S/N 18052102Cancelled Apr 24, 2018 · Registration expired, pending cancellation · Built 1969 · Factoria Aircraft Inc N8230SAerotechnik L-13 SEH VIVAT · S/N 930504Cancelled Feb 8, 2018 · Built 1993 · Kasprowicz Krzysztof J N3691RBalloon Works FIREFLY 8B · S/N F8B-002Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1984 · Paul Bobbie L N15415Piper PA-28-140 · S/N 28-7325062Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1972 · Salter Tod N5452BCessna 182 · S/N 33452Cancelled Nov 20, 2017 · Revoked, canceled · Built 1956 · Wilson William L N224GSCirrus Design SR22 · S/N 1326Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 2005 · Washtucna Aviation LLC N134CABoeing 727-77 · S/N 18744Cancelled May 15, 2017 · Registration expired, pending cancellation · Built 1964 · Avengair Inc N8SUBeech C35 · S/N D-3102Cancelled Feb 4, 2017 · Revoked, canceled · Built 1952 · Hubbard Virginia D N6743KRepublic RC-3 · S/N 1031Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1947 · Mcdowell Frances M N5900XBrantly B-2 · S/N 35Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1960 · Marihugh Lloyd Jr N223EPKolb TWINSTAR MARK III C · S/N M3-90-0022Cancelled Apr 24, 2015 · Registration expired, pending cancellation · Built 2008 · Price P Scott N99623Bell TH-13T · S/N 67-15927Cancelled Dec 1, 2014 · Registration expired, pending cancellation · Built 1967 · Tri-Marine International Inc N4826KRyan NAVION · S/N NAV-4-1826Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1949 · Criteser Cecil V DBA N2280WBell 47G-5 · S/N 7970Cancelled Sep 16, 2014 · Registration expired, pending cancellation · Built 1969 · Pan Pacific Trading Corp N1621Dehavilland DHC-2 · S/N 1621Cancelled Feb 3, 2014 · Exported to Canada · Built 1966 · Mkl Aviation Management LLC N65910Boeing 727-162 · S/N 19243Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Built 1966 · Avengair Inc N1314RRaven S-60A · S/N S60A-127Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1978 · Karras William G N4992BBeech D-50 · S/N DH-49Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1956 · Boekelman Leonard V N924TSBoeing 727-227 · S/N 21041Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1975 · Northwest Air Leasing LLC N225RSSchreiber Robert E QUICKIE · S/N 014Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Schreiber Robert E N61BGHughes 269A · S/N 880959Cancelled Aug 7, 2013 · Sale reported, canceled · Built 1967 N6146LAmerican AA-1 · S/N AA1-0346Cancelled Aug 5, 2013 · Revoked, canceled · Built 1970 · Mccaw Bruce R N62403Pilatus PC-6 · S/N 558Cancelled Aug 5, 2013 · Revoked, canceled · Williamson Dale D N44177Opdycke Wallace E BUSHMASTER · S/N 001Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Built 1992 · Opdycke Wallace E

Back to Bellevue, WA