Skip to content

Cancelled registrations · 32

Query with SQL

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 = 'WA' AND d.registrant_city = 'PROSSER' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 = 'WA' AND d.registrant_city = 'PROSSER'
  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 = 'WA' AND d.registrant_city = 'PROSSER'
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.

N17VSStanderfer HEADWIND 17 · S/N 2098V1ACancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1975 · Thompson Cormac C Jr N70177Piper J3C-65 · S/N 17162Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1946 · Thompson Cormac C Jr N26965Piper J4A · S/N 4-974Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1940 · Thompson Cormac C Jr N94843Engineering & Research ERCOUPE 415-E · S/N 4957Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1948 · Thompson Cormac C Jr N70795Piper J3C-65 · S/N 17813Cancelled Jun 5, 2020 · Revoked, canceled · Built 1946 · Hargreaves Philip N42683Mains Ronald O SR7XL · S/N 2676Cancelled May 4, 2019 · Registration expired, pending cancellation · Nelson William R N3151BStinson 10A · S/N 7768Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Boast Lynn R N32283Stinson 10A · S/N 7931Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Built 1941 · Boast Lynn R N37145Engineering & Research ERCOUPE 415-C · S/N 112Cancelled Apr 24, 2018 · Registration expired, pending cancellation · Built 1942 · Musselman William J N3862XAero Commander 100 · S/N 158Cancelled Mar 1, 2018 · Registration expired, pending cancellation · Built 1967 · Prosser Flying Club Inc N2640CCessna 310 · S/N 35040Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Boast Lynn N86308Aeronca 11AC · S/N 11AC-116Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1946 · Philip Philip J N9199DPiper PA-22-160 · S/N 22-6258Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1958 · Philip Philip J N4304Sailplane TERN · S/N GRI/WTM-14-71Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1971 · Thompson Cormac C III N7680XCessna 172B · S/N 17248180Cancelled Aug 28, 2013 · Registration expired, pending cancellation · Built 1960 · Conmy Scott D N9912PPiper PA-36-285 · S/N 36-7560020Cancelled Feb 13, 2013 · Third renewal notice · Built 1975 · Aircraft Applicators Inc N6576EWestern Ultralight RANS S-12 XL · S/N 06950610Cancelled Jul 27, 2011 · Built 1996 · Nelson William R N9887WPiper PA-28-140 · S/N 28-23407Cancelled Aug 24, 2009 · Triennial form not returned · Built 1967 · Thompson Cormac C N4059HHelio H-700 · S/N H-9Cancelled Jan 10, 2000 · Exported to Ecuador · May John C N1812GChampion 7GCBC · S/N 96Cancelled May 5, 1995 · Triennial form not returned · Anderson Kirk M N21916Cessna 150L · S/N 15074533Cancelled Nov 23, 1983 · Administratively canceled · Stewart Elane N9016Thompson CHIPPER · S/N CCT-1Cancelled Oct 15, 1981 · Thompson Cormac C Sr N7709QCessna 310Q · S/N 310Q0209Cancelled Sep 21, 1977 · B & K Inc N49215Consolidated Vultee BT-13A · S/N 3460Cancelled Jan 18, 1971 · Aircraft Applicators Inc N6873ZPiper PA-25-235 · S/N 25-2593Cancelled Jun 24, 1966 · Aircraft Applicators Inc N4455VBeech 35 · S/N D-1270Cancelled Jun 19, 1957 · Exported to Canada · Wiley John N7165KPiper PA-18 · S/N 18-384Cancelled Aug 10, 1953 · Tresham Emery N36668Aeronca 65-TAL · S/N 1311Cancelled Apr 4, 1951 · Built 1941 · L And D Flying Service N54303Cessna T-50 · S/N 5971Cancelled Apr 3, 1951 · Ratcliffe Lyle R N25105Luscombe 8A · S/N 1029Cancelled Feb 1, 1951 · Built 1939 · Thompson Harold N N49460Fairchild PT-23 · S/N H0202Cancelled Jun 6, 1949 · L & D Flying Service N2747Eaglerock LONG WING EAGLEROCK · S/N 149Cancelled Aug 23, 1936 · Built 1926 · Thompson Cormac

Back to Prosser, WA