OpenAirDocs.org
Sandston, VA

Cancelled registrations · 29

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

N2447Jett-Eaa Biplane P-1 · S/N 001Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 1970 · Weaver Chad EN45807Silvaire LUSCOMBE 8A · S/N 2334Cancelled Jun 12, 2020 · Revoked, canceled · Built 1946 · Morris Alvie EN108SOrloff-Geist SPEZIO SPORT DAL-1 · S/N 314Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Built 1976 · Clarke Robert EN665WBDehavilland CHIPMUNK 22A · S/N C1-0113Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1955 · Tomlinson Robert LN866JSLearjet 23 · S/N 23-018Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1965 · Sills J KennedyN1407VCessna 172M · S/N 17263552Cancelled Nov 12, 2013 · Registration expired, pending cancellation · Built 1974 · Commonwealth Jet Service IncN6446XCessna U206G · S/N U20605891Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1980 · John Erickson Assocs IncN828BABell 206B · S/N 3426Cancelled Apr 21, 2010 · Triennial form not returned · Built 1981 · HeloairN9209UCessna 150M · S/N 15078160Cancelled Sep 15, 2009 · Registration revoked · Built 1976 · Sills Sales & Service IncN3107VCessna R172K · S/N R1722239Cancelled Jan 28, 1999 · Triennial form not returned · Martinair IncN525MAMitsubishi MU-2B-26 · S/N 340Cancelled Nov 17, 1994 · Second triennial mailing, no response · Commonwealth Jet Service IncN4433EPiper PA-38-112 · S/N 38-78A0601Cancelled Dec 12, 1984 · Built 1978 · Aero Industries IncN36739Piper PA-28R-201 · S/N 28R-7837289Cancelled Nov 16, 1982 · Built 1978 · Aero Industries IncN43594Piper PA-28-151 · S/N 28-7415533Cancelled Aug 5, 1980 · Built 1974 · Aero Industries IncN55403Piper PA-28-140 · S/N 287325396Cancelled Aug 1, 1980 · Aero Industries IncN5806GCessna 150K · S/N 150-71306Cancelled Jul 12, 1977 · Archer Kenneth LN5199BBell 47J · S/N 1733Cancelled May 8, 1975 · Hawthorne Aviation IncN3593XMooney M-20G · S/N 680162Cancelled Oct 30, 1973 · Richmond Aviation IncN6597QAlon A2 · S/N A-97Cancelled Feb 23, 1972 · Richmond Aviation IncN4199PPiper PA-23-160 · S/N 23-1688Cancelled Apr 22, 1968 · Aero IndustriesN5146WPiper PA-28-160 · S/N 28-177Cancelled Apr 22, 1968 · Aero IndustriesN71842Luscombe 8A · S/N 3269Cancelled Dec 6, 1967 · Exported to Canada · Hamm HermanN4257ABeech C-45H · S/N AF-659Cancelled Apr 14, 1967 · Virginia Wing Civil Air PatrolN2040APiper J-3C · S/N 543Cancelled Mar 13, 1967 · Virginia Wing Civil Air PatrolN1479VPiper J3C-65 · S/N 12943Cancelled Nov 19, 1963 · Civil Air Patrol IncN4246ARyan NAVION · S/N NAV4-1632Cancelled Nov 19, 1963 · Civil Air Patrol Virginia WingN6811HPiper J3C-65 · S/N 20024Cancelled Mar 6, 1962 · Civil Air Patrol Of Virginia IncN1352VPiper L-4J · S/N 13962Cancelled Oct 5, 1955 · Civil Air Patrol Virginia WingN1220MBoeing E75 · S/N 75-8176Cancelled Feb 12, 1951 · Built 1943 · Civil Air Patrol Of Va Inc
Back to Sandston, VA