Parkersburg, WV

Cancelled registrations · 35

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

N86017Infinity Power Parachutes INFINITY 2001 · S/N IPP1-038Cancelled May 2, 2020 · Registration expired, pending cancellation · Built 2001 · Wilson Charles DanielN6296HPiper J3C-65 · S/N 19477Cancelled Aug 5, 2013 · Revoked, canceled · Built 1946 · Highland Larry EN47134Brush BABY ACE D · S/N 1Cancelled Mar 24, 2011 · Registration pending, pending cancellation · Built 1977N16969Bell 206B · S/N 2368Cancelled Sep 21, 2009 · Registration revoked · Church Raymond EN5433SCessna 337B · S/N 337-0533Cancelled Aug 1, 2008 · Exported to Sweden · Built 1966 · Varney Carl JN6403KCessna 150M · S/N 15077684Cancelled Jun 2, 2005 · Exported to Slovak Republic · Built 1975 · Treharne IncN124SFRoberts Paul M WINDROSE · S/N 286Cancelled Apr 17, 2002 · Triennial form not returned · Roberts Paul MN82824Piper PA-28RT-201 · S/N 28R-8118017Cancelled Jan 12, 2000 · Triennial form not returned · Rambar Aviation IncN3203RCessna 411 · S/N 4110203Cancelled Nov 19, 1997 · Triennial form not returned · Bruffey Flying IncN974DPBeech V35B · S/N D-9689Cancelled Jul 21, 1977 · Summers Karl BN4766ZPiper PA-22-108 · S/N 22-8324Cancelled Sep 9, 1975 · Exported to Canada · Huntsman Aubrey P And Jones Conrad ON1820GChampion 7GCAA · S/N 181Cancelled Nov 14, 1972 · Built 1968 · Bunner James MN871MPBeech G18S · S/N BA-610Cancelled Feb 17, 1972 · Rambar Aviation IncN9835WPiper PA-28-140 · S/N 28-23341Cancelled Jun 25, 1970 · Built 1967 · Industrial Aviation CorporationN4294UCessna 150D · S/N 150-60294Cancelled Jan 27, 1969 · Rambar Aviation IncN2030PPiper PA-23 · S/N 23-605Cancelled Jul 11, 1958 · Exported to Canada · Parkersburg-Aetna CorpN61706Cessna T-50 · S/N 1496Cancelled Feb 15, 1956 · Lewis Guinn JrN4114KRyan NAVION · S/N NAV-4-1115Cancelled Jan 25, 1954 · Exported to Canada · Gilmore SaraN91602North American NAVION · S/N NAV-4-373Cancelled Mar 7, 1951 · Rawlings Wilfred L And Rawlings Orville AN88487Piper J3C-65 · S/N 16111Cancelled Jan 29, 1951 · Stewart Aviation CoN81865Aeronca 7AC · S/N 7AC-488Cancelled Jun 30, 1949 · Wings Service IncN85477Aeronca 7AC · S/N 7AC-4217Cancelled Jun 16, 1949 · Wings Service IncN4439HPiper PA-15 · S/N 15-226Cancelled Jun 6, 1949 · Stewart Aviation CoN29977Waco UPF-7 · S/N 5474Cancelled Aug 20, 1948 · Built 1940 · Delaney Ronald CN1045Laird LCB · S/N 151Cancelled Aug 3, 1948 · Creel Spencer KN2199KLuscombe 8A · S/N 4926Cancelled Jan 5, 1948 · Guinns AirportN926VNew Standard D-29A · S/N 1031Cancelled May 21, 1943 · Ramey Robert DN13013Aeronca C-3 · S/N A-228Cancelled Nov 3, 1940 · Cottrell George Homer Westfall Robert Ramey ConradN12409Aeronca C-3 · S/N A-175Cancelled Jan 25, 1938 · Hanlon ForrestN5320American Eagle A-1 · S/N 168Cancelled Dec 1, 1935 · Thomas BeaversN5865Mono-Aircraft MONOCOUPE · S/N 44Cancelled Dec 25, 1934 · Built 1928 · Airvia Flying ClubN67KAmerican Aeronautical SAVOIA MARCHETTI S56 · S/N 52Cancelled Sep 13, 1934 · Built 1931 · Life RichardN5473Waco 10 · S/N 1522Cancelled Jun 28, 1929 · Parkersburg Aero CorpN1736Waco 9 · S/N 370Cancellation date not recorded · Built 1927 · Morris RoyN17936Piper J-2 · S/N 1536Cancellation date not recorded · Mulligan Johnny L & Forest Joseph Uhl
Back to Parkersburg, WV