Cancelled registrations · 18

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 = 'MA' AND d.registrant_city = 'LYNN' 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 = 'MA' AND d.registrant_city = 'LYNN'
  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 = 'MA' AND d.registrant_city = 'LYNN'
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.

N58042Taylorcraft DC-65 · S/N 5656Cancelled Dec 20, 2019 · Revoked, canceled · Built 1943 · Tansey Ruth C N3062KCulver V · S/N V281Cancelled Dec 9, 2019 · Revoked, canceled · Built 1946 · Bates Wallace T N158GBDJI PHANTOM 3 PROFESSION · S/N P76DCI15A21480Cancelled Nov 1, 2019 · Registration expired, pending cancellation · Alcantara Leandro N6472VAerostar International RAVEN S-55A · S/N S55A-3026Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1987 · Easton Thomas P N808HBHanold A D/Rascal Indstry EXEC 162-F · S/N 6800Cancelled Feb 15, 2011 · Exported to Canada · Built 2004 · Heliboss LLC N9389HBallard BALLARD · S/N 1Cancelled Sep 18, 2009 · Registration revoked · Built 1950 · Ballard Aircraft Co N5610RCessna 172F · S/N 17253221Cancelled May 6, 1997 · Triennial form not returned · Bedford Kenneth L N1836Cessna Ector 305A · S/N 2008Cancelled May 7, 1975 · Northeastern Light Aircraft Inc N93708Engineering & Research ERCOUPE 415-C · S/N 1031Cancelled May 17, 1974 · Marvin Peter N844APiper PA-22 · S/N 22-143Cancelled Jun 25, 1973 · Built 1955 · West David M N3299GNorth American T-28A · S/N 50-262ACancelled Jul 19, 1971 · Built 1950 · Alfred Hunter Jr N69153Timm N2T-1 · S/N 219Cancelled Jun 24, 1970 · Spanks Arthur G N20667Luscombe 8A · S/N 830Cancelled Jun 17, 1959 · Exported to Canada · Hudson Herman L N19801Taylorcraft A · S/N 308Cancelled May 21, 1948 · Built 1937 · Miga Michael E N21050Aeronca KM · S/N KM-7Cancelled Sep 29, 1947 · Dudley William G & Arthur W Nichols N3765Waco GXE/ASO · S/N 774Cancelled Jul 11, 1940 · Built 1927 · Ryan Charles Etal N376VKeystone K84 COMMUTER · S/N 315Cancelled Oct 29, 1935 · Built 1929 · Pine Tree Airways Inc N6508Waco GXE · S/N 1650Cancelled Oct 13, 1932 · Walter H Southwick

Back to Lynn, MA