OpenAirDocs.org
Beckley, WV

Cancelled registrations · 33

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

N779EHHilbert CORBIN JR. ACE MOD. · S/N 1-73-76-ACancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 1974 · Hilbert Eugene R SrN27BCCottle & Frilen BEDE 5 · S/N 146Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Built 1975 · Cottle Clarence RN13CFCottle VARIEZE · S/N 466Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 1978 · Cottle Clarence RN127CSCessna 182 · S/N 33331Cancelled Apr 28, 2021 · Revoked, canceled · Built 1956 · Carpenter Max SN32CCAgusta AW139 · S/N 31112Cancelled Jan 9, 2021 · Registration expired, pending cancellation · Built 2008 · Challenger Management LLCN28596Luscombe 8A · S/N 1425Cancelled Sep 14, 2019 · Revoked, canceled · Built 1940 · Wood RonaldN66426Smith Homer E H S EXEC · S/N 234RWCancelled Sep 30, 2013 · Registration expired, pending cancellation · Built 1991 · Smith Homer EN71392Silvaire LUSCOMBE 8A · S/N 2819Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1946 · Spisiak William JrN1010TRichmond BD-5B · S/N 3076Cancelled Jun 17, 2009 · Registration revoked · Built 1975 · Richmond Silas EN91061Giles Charles W MUSTANG II · S/N M-II-255Cancelled Dec 2, 2005 · Triennial form not returned · Built 2001 · Burgess David LN3851WPiper PA-32-260 · S/N 32-791Cancelled Apr 22, 2004 · Exported to Canada · Built 1966 · Donovan Donald DN122BBCessna 310P · S/N 310P0072Cancelled Nov 24, 1976 · Exported to Canada · Built 1968 · Clemens Jack DN1742WBeech 95-B55 (T42A) · S/N TC-1494Cancelled Nov 15, 1973 · Sheffield W H JrN988GMBeech D55 · S/N TE-589Cancelled Jun 27, 1973 · Sheffield William H JrN524WMonocoupe 110 · S/N 5W68Cancelled Feb 17, 1956 · Richardson Oscar GN2311HErcoupe 415-C · S/N 2936Cancelled Nov 21, 1955 · Built 1946 · Farrer J JN52896Cessna T-50 · S/N 3528Cancelled Oct 21, 1955 · Felix Coal Co IncN66436Consolidated Vultee BT-13A · S/N 3557Cancelled Oct 13, 1955 · Edward Ray LillyN49817Cessna T-50 · S/N 5989Cancelled Mar 4, 1955 · Sessler H LN4625HPiper PA-17 · S/N 17-40Cancelled May 13, 1953 · Fletcher Homer DaleN9101HConsolidated Vultee BT-13A · S/N 9858Cancelled Nov 21, 1951 · Sessler Robert GN2366EAeronca 7AC · S/N 7AC-5943Cancelled Jul 15, 1951 · Hurt R C & Weikle M LN7995HPiper PA-12 · S/N 12-893Cancelled May 25, 1951 · Keatley HowardN4424NBoeing B75N1 · S/N 75-1296Cancelled Apr 5, 1951 · Beckley Flying SchoolN9109HNorth American SNJ-4 · S/N 88-12008Cancelled Sep 8, 1949 · Mountain Truck Sales Co IncN18545Commonwealth REARWIN 9000-L · S/N 566DCancelled May 4, 1948 · Built 1938 · Raleigh Flyers IncN158MNew Standard D-29A · S/N 1010Cancelled Feb 4, 1948 · Built 1929 · Beckley Air Transport IncN29981Waco UPF-7 · S/N 5478Cancelled Apr 3, 1943 · Beckley Air Transport IncN15751Nash NASH CORBEN BABY ACE · S/N 27Cancelled May 15, 1939 · Built 1936 · Nash JohnN11654Via Harold R VIA-CHURCH JC-2 · S/N 1Cancelled Mar 7, 1935 · Built 1931 · Via Harold RN4906Standard J-1 · S/N 4337Cancelled Feb 16, 1933 · Mccaffrey F MN5596Standard J-1 · S/N 1 SUBSTITUTEDCancelled Jul 14, 1930 · Mccaffrey F MN1184Standard J-1 · S/N 5490Cancelled May 2, 1930 · Mccaffrey F M
Back to Beckley, WV