OpenAirDocs.org
Huntsville, AL

Cancelled registrations · 227

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 = 'AL' AND d.registrant_city = 'HUNTSVILLE'
  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.

N696PBWyatt PLAYBOY SA3A · S/N J.J.1Cancelled Oct 5, 2026 · Registration pending, canceledN256FDWilson Ethan J KR-2S · S/N 001Cancelled Nov 14, 2025 · Built 2025 · Wilson Ethan JN755GWWeaver G/Quad City Ultralight CHALLENGER II · S/N 12042561Cancelled Sep 19, 2024 · Built 2005 · Zimmerman Luke GN950UAUniv Of Alabama AT Huntsville PEGASUS · S/N MAE 2016-005Cancelled Apr 1, 2023 · Registration expired, pending cancellation · University Of Alabama In HuntsvilleN4762ADewberry Jay H CHALLENGER II · S/N 1188Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 2012 · Merchant David EN7843HRotomotion SR-20 · S/N 237Cancelled Feb 4, 2023 · Registration expired, pending cancellation · University Of Alabama In HuntsvilleN784RADJI FLAMEWHEEL F450 · S/N RC2016-001Cancelled Feb 4, 2023 · Registration expired, pending cancellation · University Of Alabama In HuntsvilleN793TADJI PHANTOM 3 STANDARD · S/N P5AJDC01020862Cancelled Feb 4, 2023 · Registration expired, pending cancellation · University Of Alabama In HuntsvilleN794AHUniv Of Alabama IN Huntsville FLAMEWHEEL 550 · S/N RC2016-003Cancelled Feb 4, 2023 · Registration expired, pending cancellation · University Of Alabama In HuntsvilleN784QADJI FLAMEWHEEL F450 · S/N RC2016-002Cancelled Dec 3, 2022 · Registration expired, pending cancellation · University Of Alabama HunstvilleN784WADJI INSPIRE 1 · S/N W 130DN12060151Cancelled Dec 3, 2022 · Registration expired, pending cancellation · University Of Alabama In HuntsvilleN784XZRotomotion SR-20 · S/N 188Cancelled Dec 3, 2022 · Registration expired, pending cancellation · University Of Alabama In HuntsvilleN990HPAviat A-1B · S/N 2109Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 2000 · Dotson Brandon NN845RLBell Helicopter Textron 212 · S/N 30845Cancelled Oct 13, 2022 · Built 1977 · Axxeum IncN682VHDJI INSPIRE 1 · S/N CD20113720849CCancelled Sep 3, 2022 · Registration expired, pending cancellation · Huntsville City SchoolsN613RWPiper PA-32R-301T · S/N 3257295Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Fastmetrix International LLCN858FADJI SPREADING WINGS S900 · S/N 0380066569Cancelled Mar 5, 2022 · Registration expired, pending cancellation · University Of Alabama In HuntsvilleN858HADJI SPREADING WINGS S900 · S/N 0380066587Cancelled Mar 5, 2022 · Registration expired, pending cancellation · University Of Alabama In HuntsvilleN855UQDJI MATRICE 200 · S/N EH261644184398Cancelled Jan 8, 2022 · Registration expired, pending cancellation · University Of Alabama In HuntsvilleN855VDDJI INSPIRE 2 · S/N OAOLDBS00302CFCancelled Jan 8, 2022 · Registration expired, pending cancellation · University Of Alabama In HuntsvilleN855WGDJI INSPIRE 2 · S/N OAOLDCS003006KCancelled Jan 8, 2022 · Registration expired, pending cancellation · University Of Alabama In HuntsvilleN94644T.E.A.M. AIR-BIKE · S/N 187Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Built 2007 · Ford Robert E JrN550FADJI PHANTOM 2 · S/N UA1SCancelled Jul 31, 2021 · Registration expired, pending cancellation · University Of AlabamaN551BMDJI PHANTOM 2 · S/N UA2SCancelled Jul 31, 2021 · Registration expired, pending cancellation · University Of Alabama In HuntsvilleN9078NRobinson Helicopter R22 · S/N 0283Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1982 · Barnes Gary AN571RDSchempp-Hirth VENTUS C · S/N 355Cancelled Jul 27, 2021 · Built 1987 · Dutch Charles PN6745ECessna 175A · S/N 56245Cancelled Jul 19, 2021 · Revoked, canceled · Built 1959 · Jenkins Frank MN7847ECessna 150 · S/N 17647Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1959 · Pride Robert RN84CRSchleicher ASW-17 · S/N 17045Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1976 · Ford Robert E JrN62050Maule M-5-210C · S/N 6084CCancelled Dec 5, 2020 · Sale reported · Built 1975N833GDDJI SPREADING WINGS S900 · S/N 02Cancelled Sep 28, 2020 · First renewal notice · Digital Fusion Solutions IncN18VMRobert Shane Klase VELOCITY · S/N DM0183Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Klase Robert ShaneN668ADDJI PHANTOM 3 PROFESSION · S/N P76DCF27013971Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Sellers James MN798QUUniv Of Alabama IN Huntsville FLAMEWHEEL 550 · S/N RC2016-004Cancelled May 2, 2020 · Registration expired, pending cancellation · University Of Alabama In HuntsvilleN806NUUniversity Of Alabama IN Hunts ATLAS · S/N MAE 2016-006Cancelled May 2, 2020 · Registration expired, pending cancellation · University Of Alabama In HuntsvilleN4592MPiper PA-11 · S/N 1195Cancelled Feb 21, 2020 · Revoked, canceled · Built 1947 · Rocket City Dusting Service IncN750ZMDJI PHANTOM 3 PROFESSION · S/N P76DCL26B26822Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Nasa MsfcN501DY3D Robotics IRIS+ · S/N IRS1532800194Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Dynetics IncN502DY3D Robotics IRIS+ · S/N 153280024Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Dynetics IncN503DY3D Robotics X8+ · S/N X815032870024Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Dynetics IncN504DYDJI PHANTOM 3 ADVANCED · S/N P76DCL14B26933Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Dynetics IncN505DYDJI PHANTOM 3 STANDARD · S/N P5AUCJ150702JNCancelled Jan 6, 2020 · Registration expired, pending cancellation · Dynetics IncN506DYDynetics SKYWALKER X8 · S/N OHG6Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Dynetics IncN6276QCessna 401A · S/N 401A0076Cancelled Sep 6, 2019 · Sale reported, canceled · Built 1969N668DA3D Robotics SOLO · S/N 111A5900922Cancelled Sep 6, 2019 · Registration expired, pending cancellation · University Of Alabama In HuntsvilleN668KADJI PHANTOM 2 · S/N PH646059392Cancelled Sep 6, 2019 · Registration expired, pending cancellation · University Of Alabama In HuntsvilleN668RADJI PHANTOM 2 · S/N PH646059400Cancelled Sep 6, 2019 · Registration expired, pending cancellation · University Of Alabama In HuntsvilleN742EADJI FLAMEWHEEL F550 · S/N MAE 2016-004Cancelled Sep 6, 2019 · Registration expired, pending cancellation · University Of Alabama In HuntsvilleN742HADJI PHANTOM 3 STANDARD · S/N P5ADCF300100N6Cancelled Sep 6, 2019 · Registration expired, pending cancellation · University Of Alabama In HuntsvilleN742LADJI FLAMEWHEEL F450 · S/N MAE 2016-003Cancelled Sep 6, 2019 · Registration expired, pending cancellation · University Of Alabama In Huntsville
Back to Huntsville, AL