Cancelled registrations · 61

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

N4516Alexander LONG WING EAGLEROCK · S/N 413Cancelled Nov 27, 1936 · Harold W Pugh N811WEconomou Arthur MODIFIED HEATH · S/N A1Cancelled Mar 15, 1935 · Economou Arthur N861YHeath RF-1 · S/N 1Cancelled Feb 2, 1933 · Built 1930 · Fluet Robert N1874Waco 9 · S/N 387Cancelled Jan 24, 1933 · Built 1919 · Neff Justin R N60248Cessna T-50 · S/N 2235Cancellation date not recorded · Richards Stephen A N60546Cessna T-50 · S/N 1253Cancellation date not recorded · Richards S A N60548Cessna T-50 · S/N 2209Cancellation date not recorded · Richards S A N60790Cessna T-50 · S/N 1284Cancellation date not recorded · Richards S A N60791Cessna T-50 · S/N 2202Cancellation date not recorded · Richards S A N69170Cessna T-50 · S/N 2287Cancellation date not recorded · Richards S A N69172Cessna T-50 · S/N 1135Cancellation date not recorded · Richards S A

Back to Burlington, VT