OpenAirDocs.org
Huntington, WV

Cancelled registrations · 70

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

N323BBeech G35 · S/N D-4830Cancelled Sep 21, 2024 · Sale reported, canceledN464AMMitsubishi MU-300 · S/N A090SACancelled Jun 15, 2024 · Sale reported, canceledN5250FCessna 172F · S/N 17253348Cancelled Jan 10, 2023 · Sale reported, canceled · Built 1965N201RQRemos G-3/600 · S/N 201Cancelled May 7, 2022 · Registration expired, pending cancellation · Built 2007 · Lee DonaldN3846EAeronca 11AC · S/N 11AC-S54Cancelled Feb 26, 2021 · Exported to United Kingdom · Built 1947 · Bingham William EN7772PPiper PA-24 · S/N 24-2988Cancelled Aug 7, 2020 · Sale reported, canceled · Built 1961N70251Piper J3C-65 · S/N 17228Cancelled Jan 24, 2020 · Revoked, canceled · Built 1946 · Hayes Fred MN47250Cessna 152 · S/N 15283197Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1979 · Henry Philip DN93525Bellanca 17-30A · S/N 73-30563Cancelled Jan 30, 2018 · Registration expired, pending cancellation · Built 1937 · Bowman Jonathan DN1981VCessna 120 · S/N 14192Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 1947 · Classic BuildersN512WMBeech 35-B33 · S/N CD-589Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1962 · Manning C WayneN1928PPiper PA-22-150 · S/N 22-2679Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1955 · Pacer Sports IncN76898Cessna 120 · S/N 11338Cancelled Sep 8, 2014 · Third renewal notice · Built 1946 · Bailey Carlton D JrN25434Balloon Works FIREFLY 7-15 · S/N F7-773Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 1992 · Bond Enterprises IncN9050FSmith Stephen D FISHER AERO YOUNGSTR · S/N BO52Cancelled Aug 23, 2013 · Sale reported, canceledN3989ALane-Whittman Tailwind WC-8 · S/N 28Cancelled Aug 19, 2013 · Sale reported, canceledN6336LAmerican AA-1B · S/N AA1B-0036Cancelled Aug 6, 2013 · Revoked, canceled · Built 1972 · Tri Av Enterprises IncN4043ZBalloon Works FIREFLY 7 · S/N 7872Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1979 · West Virginia Balloons IncN9164FMarshall Ronald A MONARCH · S/N 1Cancelled Jun 5, 2013 · Sale reported, canceled · Built 1989N8533GCessna 150F · S/N 15062633Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1965 · Sammons Donald LN60246Cessna 150J · S/N 15070167Cancelled Feb 8, 2013 · Sale reported, canceled · Built 1969N4810DCessna 182A · S/N 34910Cancelled Dec 13, 2012 · Registration expired, pending cancellation · Built 1958 · West Virginia Skydiver'SN4230MPiper PA-12 · S/N 12-3127Cancelled Jun 14, 2012 · Revoked, canceled · Built 1947 · Cruiser ClubN6170KJones Emmett E FISHER AVENGER-V · S/N A0102Cancelled Jan 23, 2007 · Triennial form not returned · Built 1997 · Jones Emmett EN6584FCessna 150F · S/N 15063184Cancelled Oct 16, 2001 · Built 1966 · Bowen Clinton RN35GHBell 222U · S/N 47570Cancelled Nov 16, 1995 · Exported to Turkey · General Helicopters Intl IncN36897Balloon Works FIREFLY 7 · S/N F7080Cancelled Aug 29, 1995 · Triennial form not returned · Bond Enterprises IncN5757MBell 206B · S/N 3668Cancelled Aug 24, 1995 · Exported to South Africa · General Helicopters Intl IncN3189TBell 206B · S/N 3814Cancelled Jul 25, 1995 · Exported to Austria · General Helicopters Intl IncN27GHBell 206B-III · S/N 4095Cancelled May 11, 1994 · Exported to South Africa · General Helicopters Intl IncN281CBell 206B · S/N 1761Cancelled Feb 18, 1994 · Exported to Ireland · General Helicopters Intl IncN1069QBell Helicopter Textron 206L-1 · S/N 45341Cancelled Dec 15, 1993 · Exported to South Africa · General Helicopters InternationalN251EVBell 206L-3 · S/N 51392Cancelled Jan 20, 1993 · Exported to South Africa · General Helicopters Intl IncN8303ZCessna 210-5(205) · S/N 2050303Cancelled Mar 26, 1991 · Triennial form not returned · Thompson William FN99461Chalmers EASYRISER · S/N ER-HWV-9Cancelled Oct 20, 1981 · Chalmers Robert AN5737ACessna 172 · S/N 28337Cancelled May 8, 1981 · Neighborgall C R IIIN1822PPiper PA-22-150 · S/N 22-2602Cancelled Nov 26, 1974 · Willodene BlairN2685LCessna 172H · S/N 17255885Cancelled Jan 3, 1973 · Exported to Canada · Huntington Airport IncN2243PPiper PA-23 · S/N 23-853Cancelled Jul 14, 1971 · General Construction CoN110RPiper PA-18-150 · S/N 18-5201Cancelled Sep 1, 1970 · Travel Air IncN7472YPiper PA-30 · S/N 30-537Cancelled Jun 30, 1970 · Sisco Investment SecuritiesN4464CCessna 195B · S/N 16049Cancelled Apr 13, 1970 · Baker David MN5534RCessna 172F · S/N 17253115Cancelled Sep 15, 1969 · Adventurers IncN377YCessna 210E · S/N 21058686Cancelled Nov 14, 1967 · Huntington Arpt IncN3210PPiper PA-23 · S/N 23-1151Cancelled Oct 27, 1965 · Exported to Canada · Built 1957 · Bartlett David MN39722Waco UPF-7 · S/N 5855Cancelled Jul 1, 1965 · Built 1942 · Davis Robert Hunter & Newlong Robert HN92599Piper PA-12 · S/N 12-132Cancelled Jan 21, 1960 · Simonton R LN6986BPiper PA-18A 150 · S/N 18-5108Cancelled Nov 27, 1959 · Exported to Suriname · Aerial Recon IncN1918VCessna 140 · S/N 14112Cancelled Nov 25, 1959 · Huntington Flying ClubN3640NPiper J3C-65 · S/N 22899Cancelled Mar 23, 1956 · Built 1947 · Aero Seaplane Base
Back to Huntington, WV