OpenAirDocs.org
Charleston, WV

Cancelled registrations · 79

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 = 'WV' AND d.registrant_city = 'CHARLESTON'
  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.

N293DWWard Daniel J DAKOTA HAWK · S/N DH15Cancelled Oct 21, 2023 · Sale reported, canceled · Built 2001N3618ZPiper PA-22-150 · S/N 22-7509Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Built 1960 · Beam Joe BN9550DPiper PA-22-160 · S/N 22-6467Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Beam JoeN2408QCessna 182J · S/N 18257608Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1966 · Smith Ralph S JrN343DR3D Robotics SOLO · S/N S111A5501035Cancelled Oct 4, 2019 · Registration expired, pending cancellation · Airpix LLCN867BMooney M20 · S/N 1029Cancelled May 21, 2018 · Revoked, canceled · Built 1956 · Fortner F DwightN596BBeech A35 · S/N D-1617Cancelled Apr 5, 2018 · Revoked, canceled · Built 1948 · Stata M EN22BPCessna 172 · S/N 46631Cancelled Oct 28, 2017 · Revoked, canceled · Built 1959 · Painter William RN161PCAmerican Champion 8KCAB · S/N 962-2004Cancelled Oct 19, 2017 · Registration expired, pending cancellation · Built 2004 · Michael S Lakin LLCN2649THy-Tek Hurricane HAULER · S/N 5111KCancelled Jul 14, 2017 · Registration expired, pending cancellation · Koch John BN36HFBell 206B · S/N 1886Cancelled Jun 14, 2017 · Registration expired, pending cancellation · Built 1975 · Helicopter Flite Service IncN82BCLowers R-1 · S/N 66-1Cancelled Feb 4, 2017 · Revoked, canceled · Built 1967 · Anare IncN911BBeech D-50 · S/N DH-124Cancelled Feb 4, 2017 · Revoked, canceled · Built 1956 · E M Frederick & Assoc IncN6238DCessna 172N · S/N 17272656Cancelled May 23, 2016 · Built 1979 · Skylane Aviation LLCN853RCRaven S55A · S/N S55A-696Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1980 · Almost Heaven Balloon Promotions IncN9460QBeech 58 · S/N TH-207Cancelled Nov 25, 2014 · Registration expired, pending cancellation · Built 1972 · Caswell BruceN4390BMccoy Earl R CHALLENGER II · S/N CH201920779Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1992 · Wilson Ernest JN701JKBeech 58P · S/N TJ-200Cancelled Aug 19, 2013 · Registration expired, pending cancellation · Built 1979 · Jackson Kelly Holt & OfarrellN6961ECessna 172N · S/N 17272077Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1978 · Cowden R M DBAN853JRaven S55A · S/N S55A-502Cancelled May 14, 2013 · Registration expired, pending cancellation · Jones Robert PN7783SSchweizer SGS 2-33A · S/N 153Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1969 · Mountaineer Soaring Association IncN4EYCessna P337H · S/N P3370320Cancelled Nov 15, 2012 · Registration expired, pending cancellation · Built 1978 · Burdette Realty Improvements IncN524LBLindstrand Balloons 25A · S/N 5038Cancelled Jul 30, 2012 · Registration expired, pending cancellation · Built 1997 · Jones Robert PN1163Smith Miniplane DSA-1 · S/N LMW-1Cancelled Jan 12, 2011 · Sale reported, pending cancellation · Built 1967N21408Cessna 182P · S/N 18261619Cancelled Jun 8, 2004 · Triennial form not returned · Built 1972 · Hunt Douglas EN680HPPiper PA-31-350 · S/N 31-8052205Cancelled Dec 9, 2002 · Triennial form not returned · Hill Peterson Carper Bee And Deitzler PllcN236GTTaylor Glen II SL · S/N 159Cancelled Aug 29, 2002 · Triennial form not returned · Taylor GlenN9388GCessna 182P · S/N 18260928Cancelled Jan 5, 2000 · Triennial form not returned · Lane James WN9395TPiper PA-38-112 · S/N 3878A0091Cancelled Aug 20, 1997 · Triennial form not returned · Chattin Charles AN3817WPiper PA-32-260 · S/N 32749Cancelled May 30, 1996 · Triennial form not returned · Metcam Aviation LtdN789HBeech 200 · S/N BB784Cancelled Jan 22, 1993 · Exported to Brazil · Executive Air Terminal IncN3189Shamblen CHEROKEE RM · S/N RS2Cancelled Nov 12, 1991 · Triennial form not returned · Shamblen Raymond LN872JBPetersen Jt/Petersen BC WOODIES PUSHER WAS-1 · S/N 872Cancelled Oct 8, 1991 · Triennial form not returned · Petersen Joe FN15234Waco YOC · S/N 4321Cancelled Oct 21, 1987 · Built 1935 · Bollinger Cramer GN7DTCessna 337A · S/N 337-0423Cancelled Nov 21, 1983 · Austin Dana EN50BMCessna 172H · S/N 17255950Cancelled Feb 26, 1982 · Robinson J CN4236RBell 47G-4A · S/N 7708Cancelled Jun 2, 1981 · Exported to Japan · Built 1970 · Joseph M Compton IncN6601SBeech 58 · S/N TH-714Cancelled May 7, 1981 · Eagle Aviation IncN18788Beech C23 · S/N M-1944Cancelled May 4, 1981 · Built 1977 · Eagle Aviation IncN91NRAero Commander 560-A · S/N 234Cancelled Jun 15, 1976 · Department Of Natural ResourcesN221MJBeech C90 · S/N LJ512Cancelled Jan 14, 1976 · Built 1971 · Mcjunkin CorpN44405Piper PA-32-300 · S/N 32-7440152Cancelled May 1, 1975 · Built 1974 · Executive Air Terminal IncN50801Cessna 150J · S/N 15069562Cancelled Apr 17, 1975 · Exported to Canada · Aircraft Services IncN5796TCessna 172E · S/N 17251696Cancelled Feb 3, 1975 · Darnold Ray W JrN43262Taylorcraft BC12-D · S/N 6921Cancelled Aug 8, 1974 · Built 1946 · Higginbotham Earl D Et AlN16618Piper J-2 · S/N 633Cancelled Jun 25, 1974 · Putnam Flying ClubN7295ECessna 182B · S/N 52295Cancelled Jun 25, 1973 · General Aviation Service IncN8GBensen Gyrocopter 8 BM · S/N 01Cancelled Dec 30, 1970 · Givens Harold ThomasN2960YCessna 182E · S/N 18253960Cancelled Aug 6, 1969 · Charleston Squadron Aero ClubN820ZBeech C-45H · S/N 52-10679ACancelled Sep 23, 1968 · Exported to South Africa · West Virginia State Aeronautics Commission
Back to Charleston, WV