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 = 'PA' AND d.registrant_city = 'MALVERN' 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 = 'PA' AND d.registrant_city = 'MALVERN'
  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 = 'PA' AND d.registrant_city = 'MALVERN'
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.

N395EKDJI Innovations DJI S900 · S/N 170395Cancelled Aug 19, 2020 · Registration expired, pending cancellation · Rajant Corp N397EKDJI Innovations DJI S900 · S/N 170397Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Rajant Corp N399EKDJI DJI S900 · S/N 170399Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Rajant Corp N400EKDJI SPREADING WINGS S900 · S/N 1703400Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Rajant Corp N401EKDJI SPREADING WINGS S900 · S/N 1703401Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Rajant Corp N59344Haig FW-1 · S/N FW101Cancelled Apr 5, 2018 · Revoked, canceled · Built 1967 · Haig-K Aircraft Corp N9065HHaig-K Aircraft Helicopter HK-1 · S/N 100Cancelled Nov 21, 2017 · Revoked, canceled · Built 1950 · Kurkjian Haig N203QEnstrom F-28A · S/N 271Cancelled Nov 1, 2013 · Registration expired, pending cancellation · Built 1975 · Freedom Traffic Patrol Inc N2124Stewart JD2FF · S/N 2-68Cancelled Aug 23, 2012 · Registration expired, pending cancellation · Built 1967 · Labate Aviation Inc N96822Taylorcraft BC12-D · S/N 9122Cancelled Jun 7, 2012 · Second renewal notice · Built 1946 · Bone Robert J N10809Cessna 150L · S/N 15075053Cancelled Aug 10, 2005 · Triennial form undeliverable · Built 1973 · Delaware Valley Aero Club Inc N64380Cessna 172M · S/N 17265206Cancelled Nov 15, 1995 · Triennial form not returned · Labate Aviation Inc N10LCLeopoldoff L-6 · S/N 129Cancelled Jan 19, 1995 · Exported to United Kingdom · Labate Aviation Inc N83900Piper PA-34-220T · S/N 348133106Cancelled Aug 22, 1994 · Exported to Colombia · Labate Aviation Inc N14ARJerolaman ARUP S-2 REPLICA · S/N REP1Cancelled Jul 16, 1993 N888BDCessna T210N · S/N 21063233Cancelled Sep 11, 1992 · Exported to Canada · Schreiber Michael Newton N7618MCessna 175 · S/N 55918Cancelled Jan 4, 1971 · Cirrus Flying Club Inc N9311KStinson 108-2 · S/N 1082311Cancelled May 21, 1965 · Keyes Thomas G N49876Piper J3C-65 · S/N 10623Cancelled Nov 28, 1955 · Mumma Aero Sales & Service N210MDavis V-3 · S/N 121Cancelled Feb 10, 1948 · Built 1929 · Jacob John D N559KMoth 60-GM · S/N 53Cancelled Jul 1, 1938 · Built 1929 · Gingrich Paul John

Back to Malvern, PA