Cancelled registrations · 17

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 = 'CT' AND d.registrant_city = 'NEW BRITAIN' 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 = 'CT' AND d.registrant_city = 'NEW BRITAIN'
  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 = 'CT' AND d.registrant_city = 'NEW BRITAIN'
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.

N550QCPinnacl X CHAMELEON PRO · S/N PX-CHP-0001Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Central Connecticut State University N550UC3D Robotics IRIS · S/N 8705Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Central Connecticut State University N550WQPinnacl X CHAMELEON · S/N PX-CH-0001Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Central Connecticut State University N2317RProxee Peter/Claudia P. JAY · S/N 1Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1983 · Proxee Peter J N8REElmer Ralph E KR-2 · S/N 922Cancelled Mar 11, 2013 · Sale reported, pending cancellation N2007Mcgee BENSEN B8M · S/N 1Cancelled Oct 16, 2012 · Registration expired, pending cancellation · Built 1976 · Schultz James J N76543Cessna 140 · S/N 10979Cancelled Sep 6, 2012 · Revoked, canceled · Built 1946 · Dornan Weston E N6574Douglas DC-3A-S1C3G · S/N 4388Cancelled Sep 4, 1973 · Arute International Air Inc N97515Stinson 108 · S/N 108-515Cancelled Jul 22, 1970 · Built 1946 · Oskinis Bruno A/Mastrianni Alfred R N51841Fairchild M-62A · S/N T42-3554Cancelled Mar 23, 1953 · Built 1945 · Maranda Francis N35673Piper J3F-65 · S/N 6533Cancelled May 15, 1952 · Built 1941 · Martin Stanley J N93315Ercoupe 415-C · S/N 638Cancelled Dec 29, 1950 · Kitson Joseph N93957Ercoupe 415-C · S/N 1280Cancelled May 2, 1949 · Dimeo William E N300HMoth 60-GM · S/N 3-ACancelled Nov 15, 1936 · Schmidt Clarence J N852WSwift Leon M SWIFT MEAD PRIM GLDR · S/N 2001Cancelled Sep 1, 1936 · Andrews John R N2827Nelson / Driscoll FLEET WING · S/N 25Cancelled Mar 15, 1936 · Driscoll Benjamin B N584Bellanca CH300 PACEMAKER · S/N 130Cancelled Apr 11, 1933 · Carey George

Back to New Britain, CT