Cancelled registrations · 21

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

N319TACostruzioni Aeronautiche Tecna P2004 BRAVO · S/N 125Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 2008 · Mid-Atlantic Air Ventures Inc N115TECostruzioni Aeronautiche Tecna P92 EAGLET · S/N 1215Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 2008 · Mid Atlantic Air Ventures Inc N1064AAdams Balloon A55 · S/N 066Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Built 1980 · Simmons Richard Morgan Jr N6221HSmith Michael H MHS-100A · S/N 0809538850-1Cancelled Jan 31, 2011 · Triennial form not returned · Smith Michael H N968DStinson 108-2 · S/N 108-2968Cancelled Sep 17, 2009 · Registration revoked · Built 1947 · Koumparakis George N1185PPiper PA-23 · S/N 23-199Cancelled Jun 25, 2009 · Registration revoked · Built 1955 · Koumparakis George S N5347JCessna 172N · S/N 17273761Cancelled Apr 11, 2007 · Triennial form not returned · Heart Of Virginia Aviation N63799Smith Steve D SMITH GYRO-1 · S/N 223-94-9527-1Cancelled May 12, 2005 · Triennial form not returned · Built 1999 · Smith Steve D N17HABell 206B · S/N 2003Cancelled Dec 12, 2001 · Exported to Canada · Built 1976 · Hussey W Lee II N15728Aeronca LB · S/N 2004Cancelled Feb 19, 1997 · Triennial form not returned · Lester Morton W N16294Aeronca LB · S/N 2032Cancelled Feb 19, 1997 · Triennial form not returned · Lester Morton W N6360SCessna 150G · S/N 15067160Cancelled Jun 10, 1991 · Triennial form not returned · Allen Carroll J N107LHHussey Les ROTORWAY EXEC · S/N 225945484Cancelled Mar 22, 1991 · Triennial form not returned · Hussey Les N9054VWillwerth Clarence C VARIEZE · S/N 656Cancelled Sep 14, 1981 · Clarence C Willwerth Jr N2391HErcoupe 415-C · S/N 3016Cancelled May 19, 1965 · Built 1946 · Sutton J P Et Al N838CStinson 108-3 · S/N 108-3838Cancelled May 18, 1965 · Fisher Lawrence D Jr N46957Piper J3C-65 · S/N 10437Cancelled Oct 4, 1948 · Virginia Aircraft Sales Co Inc N9121HStinson VULTEE V-77 · S/N 77-15Cancelled Apr 29, 1948 · Turner R C N9122HStinson AT-19 · S/N 77-32Cancelled Apr 29, 1948 · Turner R J N36091Taylorcraft BL-65 · S/N 3058Cancelled Aug 12, 1943 · Built 1939 · Covington John Glen N21048Aeronca KCA · S/N KCA-25Cancelled Nov 24, 1941 · Mitchell George D

Back to Martinsville, VA