Cancelled registrations · 20

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 = 'KY' AND d.registrant_city = 'ASHLAND' 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 = 'KY' AND d.registrant_city = 'ASHLAND'
  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 = 'KY' AND d.registrant_city = 'ASHLAND'
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.

N3040MPiper PA-34-200T · S/N 34-7970105Cancelled May 29, 2020 · Sale reported, canceled · Built 1979 N760QKDJI PHANTOM 3 PROFESSION · S/N P77DCG2016989Cancelled May 2, 2020 · Registration expired, pending cancellation · Kentucky Educational Development Corp N1433Volmer Sportsman VJ22 · S/N VJ381Cancelled Sep 6, 2019 · Revoked, canceled · Built 1967 · Bradley Virgil L N5571HRaven S55A · S/N S55A-552Cancelled Oct 28, 2014 · Registration expired, pending cancellation · Built 1980 · E Jay Enterprises N5080MTaylorcraft BC12-D · S/N 10380Cancelled Jan 31, 2013 · Registration pending, canceled · Built 1946 N444PDDegelia Phil 1 · S/N PD-1Cancelled Jul 10, 2012 · Built 2004 · Degelia Samuel P N9326PPiper PA-24-260 · S/N 24-4823Cancelled Sep 16, 2009 · Registration revoked · Built 1969 · Flying Inc N1THHauck BD-4 · S/N 477Cancelled Jun 11, 2003 · Second triennial mailing, no response · Built 1976 · Moss Dick M N292TWilliams David C TITAN (11) TORNADO · S/N D97503SOHK0256Cancelled Jan 3, 2001 · Triennial form not returned · Willliams David C N35AGAerospatiale AS350B · S/N 2006Cancelled Apr 19, 2000 · Registration pending N26MWWarner Marvin G SIDEWINDER · S/N 482885Cancelled Jan 6, 1999 · Sale reported N58445Cessna 182P · S/N 18262068Cancelled Aug 9, 1993 · Justice Oren W N5466RCessna 172F · S/N 17253025Cancelled Mar 12, 1991 · Triennial form not returned · Linville Robert D N25BHGulfstream American G-1159 · S/N 237Cancelled Feb 10, 1982 · Exported to Mexico · Built 1979 · Ashland Oil Inc N918TRBell 206B · S/N 1396Cancelled Apr 21, 1978 · Exported to Canada · Kentucky Road Oiling Inc N2102TPiper PA-28R-200 · S/N 28R-7135046Cancelled Sep 7, 1973 · Armstrong Constructors Inc N9710MMooney M20C · S/N 670117Cancelled Mar 3, 1971 · Built 1967 · Hogg George M N1000FLockheed 18-56 · S/N 2463Cancelled Nov 5, 1963 · Ashland Oil & Refining Co N3030EAeronca 7AC · S/N 7AC-6616Cancelled Jun 17, 1949 · Rutledge Flying Service N11388Ashland Glider Club RR-1 · S/N G-516Cancelled May 15, 1935 · Built 1931 · Ashland Glider Club

Back to Ashland, KY