Skip to content

Weyers Cave, VA

Cancelled registrations · 34

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 = 'VA' AND d.registrant_city = 'WEYERS CAVE' 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 = 'VA' AND d.registrant_city = 'WEYERS CAVE'
  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 = 'VA' AND d.registrant_city = 'WEYERS CAVE'
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.

N3480PPiper PA-23-160 · S/N 23-1454Cancelled Aug 10, 2024 · Sale reported, canceled · Built 1958 N7265ADJI PHANTOM 3 ADVANCED · S/N P76DDB01B26766Cancelled Mar 15, 2023 · Registration expired, pending cancellation · Blue Ridge Community College N727QADJI PHANTOM 3 ADVANCED · S/N P76DDB01B26736Cancelled Mar 15, 2023 · Registration expired, pending cancellation · Blue Ridge Community College N727VADJI PHANTOM 3 ADVANCED · S/N P76DDB01B26756Cancelled Mar 15, 2023 · Registration expired, pending cancellation · Blue Ridge Community College N827PCDJI PHANTOM 3 ADVANCED · S/N P76DDB01B26741Cancelled Mar 13, 2023 · Registration expired, pending cancellation · Blue Ridge Community College N33VDDJI PHANTOM 3 PROFESSION · S/N P76DCF09016596Cancelled Aug 31, 2021 · First renewal notice · Van Vickle Stephen E N3014PPiper PA-23 · S/N 23-923Cancelled Sep 21, 2020 · Select Aerospace Industries Inc N5494ACessna 310B · S/N 35694Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Built 1958 · Select Airparts N310BCessna 310C · S/N 35951Cancelled Sep 17, 2019 · Built 1959 · Select Airparts N22263Cessna 150H · S/N 15068176Cancelled Sep 11, 2019 · Built 1968 · Select Airparts N6KGBeech V35B · S/N D-9760Cancelled Aug 16, 2019 · Sale reported, pending cancellation · Built 1975 N606KRCessna 500 · S/N 500-0306Cancelled May 8, 2019 · Built 1975 · Select Aerospace Industries Inc N897JMDouglas DC-9-32 · S/N 47592Cancelled Feb 4, 2019 · Registration expired · Select Aerospace Industries Inc N4514DBeech G35 · S/N D-4656Cancelled Jan 16, 2019 · Registration expired, pending cancellation · Built 1956 · Select Aerospace Industries Inc N48VFCessna U-3B · S/N 60-06048Cancelled May 30, 2018 · Sale reported, canceled N5420YPiper PA-23-250 · S/N 27-2498Cancelled May 30, 2018 · Sale reported, canceled · Built 1964 N636TMRaytheon G36 · S/N E-3746Cancelled Mar 27, 2018 · Sale reported, pending cancellation N7194HRobinson Helicopter R44 · S/N 0941Cancelled Mar 19, 2018 · Registration expired, pending cancellation · Built 2000 · Shenandoah Agricultrual Spray Service Inc N3614WPiper PA-32-260 · S/N 32-515Cancelled Feb 15, 2018 · Registration expired, pending cancellation · Built 1966 · Blue Ridge Community College N20515Cessna 172M · S/N 17261353Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Built 1973 · Blue Ridge Community College N9591VCessna 172M · S/N 17264393Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Built 1974 · Blue Ridge Community College N100SHCessna 310N · S/N 310N-0122Cancelled Dec 8, 2016 · Sale reported · Built 1968 N2264FCessna 310L · S/N 310L-0064Cancelled Jul 2, 2015 · Registration pending · Built 1966 N9706YBeech 95-A55 · S/N TC-411Cancelled Jul 2, 2015 · Select Aerospace Industries Inc N77SSBeech 65-A90 · S/N LJ-230Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1966 · Blue Ridge Community College Educational Fndn Inc N3239RCessna 411 · S/N 411-0239Cancelled Jun 10, 2014 · Built 1966 · Select Aerospace Industries Inc N80512Cessna 172M · S/N 17266630Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1976 · 512 Flyers N9283LAmerican AA-1A · S/N AA1A-0183Cancelled Sep 6, 2012 · Registration pending, canceled · Built 1971 N24MBeech A35 · S/N D-2087Cancelled Aug 27, 2012 · First renewal notice · Built 1949 · Select Aerospace Industries Inc N28MSBeech E-90 · S/N LW-100Cancelled Jul 18, 2012 · Built 1974 · Select Aerospace Industries Inc N1077QCessna 310H · S/N 310H0077Cancelled Jul 1, 2011 · Sale reported, canceled · Built 1963 N686MBeech 65 · S/N LC-130Cancelled Nov 10, 2010 · Sale reported · Built 1962 N63351Cessna 150M · S/N 15077256Cancelled Mar 4, 2002 · Built 1975 · Sfs Aircraft LLC N19240Cessna 150L · S/N 15074265Cancelled Dec 15, 1992 · Triennial form not returned · Quality Flying Inc

Back to Weyers Cave, VA