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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N86017Infinity Power Parachutes INFINITY 2001 · S/N IPP1-038N6296HPiper J3C-65 · S/N 19477N47134Brush BABY ACE D · S/N 1N16969Bell 206B · S/N 2368N5433SCessna 337B · S/N 337-0533N6403KCessna 150M · S/N 15077684N124SFRoberts Paul M WINDROSE · S/N 286N82824Piper PA-28RT-201 · S/N 28R-8118017N3203RCessna 411 · S/N 4110203N974DPBeech V35B · S/N D-9689N4766ZPiper PA-22-108 · S/N 22-8324N1820GChampion 7GCAA · S/N 181N871MPBeech G18S · S/N BA-610N9835WPiper PA-28-140 · S/N 28-23341N4294UCessna 150D · S/N 150-60294N2030PPiper PA-23 · S/N 23-605N61706Cessna T-50 · S/N 1496N4114KRyan NAVION · S/N NAV-4-1115N91602North American NAVION · S/N NAV-4-373N88487Piper J3C-65 · S/N 16111N81865Aeronca 7AC · S/N 7AC-488N85477Aeronca 7AC · S/N 7AC-4217N4439HPiper PA-15 · S/N 15-226N29977Waco UPF-7 · S/N 5474N1045Laird LCB · S/N 151N2199KLuscombe 8A · S/N 4926N926VNew Standard D-29A · S/N 1031N13013Aeronca C-3 · S/N A-228N12409Aeronca C-3 · S/N A-175N5320American Eagle A-1 · S/N 168N5865Mono-Aircraft MONOCOUPE · S/N 44N67KAmerican Aeronautical SAVOIA MARCHETTI S56 · S/N 52N5473Waco 10 · S/N 1522N1736Waco 9 · S/N 370N17936Piper J-2 · S/N 1536
Back to Parkersburg, WV