OpenAirDocs.org
Charlotte, NC

Cancelled registrations · 580

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 = 'NC' AND d.registrant_city = 'CHARLOTTE'
  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.

N878HLBombardier BD-700-1A11 · S/N 9261Cancelled Jul 2, 2026 · Exported to Mexico · Built 2007 · Wells Fargo Equipment Finance IncN347BSDassault MYSTERE-FALCON 50 · S/N 306Cancelled May 21, 2024 · Exported to Turkey · Built 2001 · Wind Turbine And Energy Cables CorpN597ELAirbus A318 · S/N 2544Cancelled Feb 10, 2024 · Sale reported, canceled · Built 2005N598ELAirbus A318 · S/N 2552Cancelled Nov 3, 2023 · Sale reported · Built 2005N53DEBell Helicopter Textron Canada 429 · S/N 57380Cancelled May 2, 2023 · Built 2019 · Duke Energy Business Services LLCN185GKCessna A185F · S/N 18503687Cancelled Feb 11, 2023 · Built 1978 · Stearns Cheryl AN7133DAerostar International RX 8 · S/N RX8-3231Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1995 · Hand William MN4265SBeech B-55 · S/N TC-2016Cancelled Jan 6, 2023 · Exported to Argentina · Koppany Sergio AN41015Cameron Balloons US C-100 · S/N 6103Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Built 1997 · Ristaino Damien EdwardN1171YGrumman OV-1D · S/N 62-05874Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 1962 · Carolinas Aviation MuseumN230HLBell 230 · S/N 23004Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 1992 · Carolinas Aviation MuseumN700HFDJI PHANTOM 3 ADVANCED · S/N P76DDA14B26928Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Blythe Development CoN676GCDJI S1000+ · S/N 03P0013792Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Independent Mapping ConsultantsN7873VMooney M20C · S/N 2836Cancelled May 9, 2022 · Registration expired, pending cancellation · Mcnamara John FrancisN596ELAirbus A318 · S/N 2523Cancelled Apr 29, 2022 · Sale reported, canceled · Built 2005N567AHDJI PHANTOM 3 PROFESSION · S/N P77DCE18010127Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Hall Architects IncN25939Balloon Works FIREFLY 7-15 · S/N F7-840Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Built 1994 · Poore Eugene LN844NRDJI PHANTOM 4 PRO · S/N 0AXCE9L0B30112Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Unified Investigations & Sciences IncN209CMRaytheon B200 · S/N BB-1613Cancelled Jul 27, 2021 · Exported to Canada · Built 1998 · Charlotte Mecklinburg Hospital AuthorityN4623VCessna 172RG · S/N 172RG0341Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Built 1980 · Fly Carolina LLCN8292YDario Daniel FLIGHTSTAR 2 · S/N 1974883Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 2018 · Daniel Dario MN189GBDJI PHANTOM 3 PROFESSION · S/N P77DCG20017340Cancelled Jan 31, 2020 · Registration expired, pending cancellation · Delta V Forensic Engineering IncN788JETarot IRON MAN 650 · S/N PE5514-01Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Eisenhauer Philip DN7381GCessna 172K · S/N 17259081Cancelled Dec 10, 2019 · Sale reported · Built 1970N972JKColumbia Aircraft Mfg LC41-550FG · S/N 41800Cancelled Dec 2, 2019 · Registration expired, pending cancellation · Built 2007 · Jmk3 Lands LLCN754CRDJI PHANTOM 3 PROFESSION · S/N P76DCL15B27273Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Dpr ConstructionN187GBDJI PHANTOM 3 STANDARD · S/N P76DCE16011427Cancelled Nov 1, 2019 · Registration expired, pending cancellation · Delta V Forensic Engineering IncN690JSDJI INSPIRE 1 · S/N CC28160240204CCancelled Oct 5, 2019 · Registration expired, pending cancellation · Smith Dan TN718JPPilatus PC-12/45 · S/N 155Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Kent Industries LLCN756CBDJI S900 · S/N 0380063898Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Blythe Development CoN1209PGrumman OV-1D · S/N 62-05890Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1962 · Carolinas Historic Aviation CommissionN647BGCostruzioni Aeronautiche Tecna P2008 · S/N 098Cancelled Sep 6, 2019 · Sale reported, canceled · Built 2015N699YPDJI PHANTOM 3 ADVANCED · S/N P76DDA14B26790Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Blythe Development CoN190GBDJI PHANTOM 3 PROFESSION · S/N P77D6J3Cancelled Aug 26, 2019 · Second renewal notice · Delta V Forensic Engineering IncN191GBDJI PHANTOM 4 · S/N 07DDD2V0A10388Cancelled Aug 26, 2019 · Registration expired · Delta V Forensic Engineering IncN8656DPiper PA-22-160 · S/N 22-5863Cancelled Aug 8, 2019 · Revoked, pending cancellation · Built 1958 · Southern Flight Sales CoN8717ABeech B35 · S/N D-2244Cancelled Aug 5, 2019 · Revoked, canceled · Southern Flight Sales CoN25JLBritish Aerospace BAE 125-800B · S/N 258235Cancelled May 9, 2019 · Jet Logistics IncN9941SDJI S1000+ · S/N 03P0014149Cancelled May 4, 2019 · Registration expired, pending cancellation · Etak Systems LLCN627DRDJI PHANTOM 3 ADVANCED · S/N P77DCG21011267Cancelled May 1, 2019 · Registration expired, pending cancellation · Robinson Wesley BN631HSDJI PHANTOM 2 VISION + · S/N PH645267687Cancelled May 1, 2019 · Registration expired, pending cancellation · Unified Investigations & Sciences IncN611XEDJI PHANTOM 3 PROFESSION · S/N P76DCG31016348Cancelled Mar 23, 2019 · Registration expired, pending cancellation · Eich Ernest PN623QDDJI PHANTOM 3 ADVANCED · S/N P78DCH04030002Cancelled Mar 13, 2019 · Registration expired, pending cancellation · Robinson Wesley BN619BTDJI PHANTOM 3 PROFESSION · S/N P76DCE1Cancelled Mar 12, 2019 · Registration expired, pending cancellation · Croswhite Aviation LLCN565WT3D Robotics X8+ · S/N R277607406Cancelled Feb 2, 2019 · Registration expired, pending cancellation · Duke EnergyN9941PDJI INSPIRE 1 · S/N W13DCE05031752Cancelled Jan 28, 2019 · Registration expired, pending cancellation · Etak Systems LLCN9941QDJI PHANTOM 3 PROFESSION · S/N P76DCF08016054Cancelled Jan 28, 2019 · Registration expired, pending cancellation · Etak Systems LLCN354LCessna R172E · S/N R172-0016Cancelled Jan 17, 2019 · Registration expired, pending cancellation · Built 1967 · Puckett Lauren WN20835Mooney M20R · S/N 29-0214Cancelled Jan 15, 2019 · Registration expired, pending cancellation · Built 2000 · Premier Metals Recovery LLCN9941ADJI PHANTOM 2 VISION · S/N PH 645 489 530Cancelled Jan 8, 2019 · Registration expired, pending cancellation · Etak Systems
Back to Charlotte, NC