Skip to content

Cancelled registrations · 127

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 = 'VT' AND d.registrant_city = 'SWANTON' 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 = 'VT' AND d.registrant_city = 'SWANTON'
  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 = 'VT' AND d.registrant_city = 'SWANTON'
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.

N154SRCoy George MURPHY SUPER REBEL · S/N 154SRCancelled Nov 13, 2003 · Exported to Canada · Gesoco Industries Inc N48171Fairchild M-62A · S/N 5823AECancelled Aug 12, 2003 · Triennial form not returned · Built 1943 · Coy George S N274LPiper PA-34-200T · S/N 34-7970332Cancelled Apr 25, 2000 · Exported to Germany · Gafner Rey N10913Cessna 150L · S/N 15075128Cancelled Aug 6, 1998 · Triennial form not returned · Champlain Valley Aviation Inc N2808LCessna 172H · S/N 17256008Cancelled Aug 12, 1997 · Triennial form not returned · Champlain Valley Aviation Inc DBA N714CXCessna 150M · S/N 15079084Cancelled May 16, 1997 · Triennial form not returned · Champlain Valley Aviation Inc DBA N1202HCessna 172L · S/N 17259309Cancelled Nov 19, 1996 · Exported to Hungary · Gesoco Industries Inc N8272XCessna 172C · S/N 17248772Cancelled Oct 22, 1996 · Exported to Hungary N4587Ayres S-2R · S/N 2465RCancelled Jun 3, 1994 · Exported to Canada · Altair Inc N704KECessna 150M · S/N 15078665Cancelled Oct 23, 1984 · Bovat Lawerence B N4813HPiper PA-17 · S/N 17-111Cancelled Aug 13, 1980 · Exported to Canada · Gagne Norman D N3714MPiper PA-12 · S/N 12-2540Cancelled Aug 12, 1976 · Exported to Canada · Gagne Normand D N11890Cessna 150L · S/N 15075690Cancelled Mar 7, 1975 · Exported to Canada · Built 1974 · Swangate Air Service Inc N13518Cessna 172M · S/N 17262814Cancelled Mar 7, 1975 · Exported to Canada · Swangate Air Service Inc N1486VCessna 172M · S/N 17263620Cancelled Mar 7, 1975 · Exported to Canada · Built 1974 · Swangate Air Service Inc N13545Cessna 172M · S/N 17262838Cancelled Mar 5, 1975 · Exported to Canada · Swangate Air Service Inc N7423HPiper J3C-65 · S/N 20684Cancelled Feb 27, 1975 · Exported to Canada · Gagne Normand D N51045Cessna 150J · S/N 15069725Cancelled Jan 20, 1975 · Exported to Canada · Swangate Air Service Inc N9920YChampion AERONCA 7FC · S/N 7FC-448Cancelled Jun 28, 1974 · Exported to Canada · Cagne Normand D N87850Piper J3C-65 · S/N 15468Cancelled Apr 6, 1973 · Exported to Canada · Sunderland John H Fournier Rene Jo N1293EAeronca 7AC · S/N 7AC-4854Cancelled Sep 16, 1963 · Exported to Canada · Built 1946 · Smith Earl B N9389EAeronca 11AC · S/N 11AC-1026Cancelled Jun 2, 1962 · Exported to Canada · Smith Earl B N6545HPiper J3C-65 · S/N 19737Cancelled Oct 21, 1960 · Exported to Canada · Built 1946 · Smith Earl B N1073EAeronca 7AC · S/N 7AC-4625Cancelled Jul 22, 1959 · Exported to Canada · Built 1946 · Smith Earl B N7153HPiper J3C-65 · S/N 20408Cancelled Apr 17, 1958 · Exported to Canada · Smith Earl B N11892Curtiss Wright/Woodhurst JR CW-1 · S/N 1262Cancelled Jan 24, 1936 · Charles U Price N58031Aeronca 0-58B · S/N 058B-12163 (43-27079)ARMYCancellation date not recorded · Built 1943 · Viens Arthur A

Back to Swanton, VT