OpenAirDocs.org
Boulder, CO

Cancelled registrations · 262

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 = 'CO' AND d.registrant_city = 'BOULDER'
  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.

N19DCBalony Kubicek Spol Sro BB40D · S/N 1266Cancelled May 4, 2026 · Rocky Mountain Balloon Rides LLCN678SJSparkjoy Backcountry CCX-2000 · S/N CCX-2000-0149Cancelled May 2, 2026 · Sale reported, canceled · Built 2022N360GGGlaser-Dirks DG-400 · S/N 4-276Cancelled Oct 18, 2025 · Sale reported, canceledN4321ZBeech 95-B55 (T42A) · S/N TC-1463Cancelled Oct 7, 2025 · Built 1972 · CedocsN474CDougherty Richard J MODIFIED GYROBEE · S/N 111041Cancelled May 20, 2025 · Lawrence Carl EN99GRGraff/Rezabek J/Rezabek S STEEN SKYBOLT · S/N SS8194GRCancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 1995 · Jefferts StevenN477BRDJI SPREADING WINGS S900 · S/N 370040067Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Rubino BobN8167ZPrescott Wilbur E VANS ACFT RV-6A · S/N 22708Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Anderson Joshua KN4097DBurkhart Grob Flugzeugbau G109 · S/N 6125Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Built 1982 · Corson Michael HN135JHPiper PA-60-602P · S/N 60-8365004Cancelled Feb 19, 2022 · Expired dealer · Built 1982 · Larson Kent W DBAN6893YPiper AEROSTAR 602P · S/N 62P08988165028Cancelled Feb 19, 2022 · Expired dealer · Larson Kent W DBAN125CUUniversity Of Colorado DATAHAWK 2 · S/N CU-DH2-03Cancelled Oct 30, 2021 · Registration expired, pending cancellation · University Of ColoradoN74CUUniversity Of Colorado DATAHAWK 2 · S/N CU-DH2-04Cancelled Oct 2, 2021 · Registration expired, pending cancellation · University Of ColoradoN75CUUniversity Of Colorado DATAHAWK 2 · S/N CU-DH2-05Cancelled Oct 2, 2021 · Registration expired, pending cancellation · University Of ColoradoN77CUUniversity Of Colorado DATAHAWK 2 · S/N CU-DH2-07Cancelled Oct 2, 2021 · Registration expired, pending cancellation · University Of ColoradoN78CUUniversity Of Colorado DATAHAWK 2 · S/N CU-DH2-08Cancelled Oct 2, 2021 · Registration expired, pending cancellation · University Of ColoradoN79CUUniversity Of Colorado DATAHAWK 2 · S/N CU-DH2-09Cancelled Oct 2, 2021 · Registration expired, pending cancellation · University Of ColoradoN181SESteele Jerry P & Steven A EXEC · S/N 2957Cancelled Apr 3, 2021 · Registration expired, pending cancellation · Built 1982 · Farmer David BN8957ZCessna 310G · S/N 310G0057Cancelled Dec 5, 2020 · Registration expired, pending cancellation · Built 1962 · Zero Energy Aviation LLCN173VHayes Doug VELOCITY 173 · S/N 390Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Hayes DougN2094SCessna T210L · S/N 21061060Cancelled Jul 10, 2020 · Exported to Mexico · Built 1975 · N2094s LLCN6455HPiper J3C-65 · S/N 19632Cancelled May 8, 2020 · Revoked, canceled · Built 1946 · Matterhorn Skyways CoN147SEGolden Circle Air T-BIRD I · S/N 001Cancelled May 1, 2020 · Registration expired, pending cancellation · Built 2002 · Kreider Jan FN999LLUav Factory PENGUIN B · S/N PNB0156Cancelled Apr 21, 2020 · First renewal notice · Spec IncN999MFLearjet 25 · S/N 050Cancelled Apr 21, 2020 · First renewal notice · Built 1969 · Ice Niner LLCN138TVPilatus PC-12/47E · S/N 1326Cancelled Mar 10, 2020 · Exported to Germany · Built 2011 · Aerospace Technologies International LLCN9281WPiper PA-28-235 · S/N 28-10956Cancelled Dec 2, 2019 · Registration expired, pending cancellation · Built 1967 · Kettering James FN7406UBalloon Works FIREFLY 7 · S/N F7-367Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Built 1986 · Levin David NN997SWBlack Swift Technologies SKYWALKER EP · S/N F0006Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Black Swift Technologies LLCN36870Balloon Works FIREFLY 6 · S/N F6-002Cancelled Oct 4, 2019 · Registration expired, pending cancellation · Built 1983 · Levin David NN4348BCessna 170B · S/N 26692Cancelled Sep 27, 2019 · Revoked, canceled · Built 1955 · Suhn Donald HN675PBDJI INSPIRE 1 · S/N W13DCB06020397Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Broadreach Images LLCN7416LBalloon Works FIREFLY 6 · S/N F6-006Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Levin David NN9259DPiper PA-18-150 · S/N 18-6552Cancelled Jul 3, 2019 · Revoked, pending cancellation · Built 1958 · Roueche FloydN4051XSwearingen SA-26AT · S/N T26-124Cancelled Jun 24, 2019 · First renewal notice · Built 1969 · Stalick John RN622YFFalkor Aerials CINEMA OCTOCOPTER · S/N FALKOR 002Cancelled May 6, 2019 · Registration expired, pending cancellation · Falkor LLCN624LCFalkor Aerials DSLR OCTOCOPTER · S/N FALKOR 001Cancelled May 6, 2019 · Registration expired, pending cancellation · Falkor LLCN921SWSkywalker Technologies SKYWALKER EP · S/N F0001Cancelled May 4, 2019 · Registration expired, pending cancellation · Black Swift TechnologiesN598SWBlack Swift Technologies SUPERSWIFT · S/N F0002Cancelled Mar 15, 2019 · Registration expired, pending cancellation · Black Swift TechnologiesN627KXRob Winter TAROT FY680 HEXACOPT · S/N DT01X420-01Cancelled Mar 13, 2019 · Registration expired, pending cancellation · La Farge DougN102GTGoogle B3 · S/N 001Cancelled Mar 11, 2019 · Registration expired, pending cancellation · Google IncN108GTGoogle M2 · S/N 001Cancelled Mar 11, 2019 · Registration expired, pending cancellation · Google IncN879BSBlack Swift Technologies SUPERSWIFT · S/N F0005Cancelled Mar 1, 2019 · Registration expired, pending cancellation · Black Swift TechnologiesN829SWBlack Swift Technologies APOLLO · S/N F0004Cancelled Feb 27, 2019 · Registration expired, pending cancellation · Black Swift TechnologiesN738SWBlack Swift Technologies TEMPEST · S/N F0003Cancelled Feb 25, 2019 · Registration expired, pending cancellation · Black Swift TechnologiesN219SWSkywalker Technologies SKYWALKER X8 · S/N F0000Cancelled Feb 23, 2019 · Registration expired, pending cancellation · Black Swift TechnologiesN113CUUniversity Of Colorado BERGEN OBSERVER · S/N CU/113Cancelled Feb 7, 2019 · Registration expired, pending cancellation · University Of ColoradoN124QQDJI PHANTOM 2 · S/N PH646010280Cancelled Feb 7, 2019 · Registration expired, pending cancellation · Biz Uas CorpN148AEAgribotix ENDURO · S/N 00707Cancelled Feb 6, 2019 · Registration expired, pending cancellation · Agribotix LLCN163AEAgribotix ENDURO · S/N 00708Cancelled Feb 6, 2019 · Registration expired, pending cancellation · Agribotix LLC
Back to Boulder, CO