Cancelled registrations · 72

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 = 'TX' AND d.registrant_city = 'LANCASTER' 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 = 'TX' AND d.registrant_city = 'LANCASTER'
  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 = 'TX' AND d.registrant_city = 'LANCASTER'
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.

N1096WBeech F33A · S/N CE-436Cancelled May 24, 2012 · Registration expired, pending cancellation · Built 1973 · Gta Air Inc N115RCMooney M20E · S/N 627Cancelled May 24, 2012 · Sale reported, canceled · Built 1965 N402Samples SCORPION TOO · S/N V424042Cancelled May 24, 2012 · Revoked, canceled · Samples Walter H N273ADPiper PA-23-250 · S/N 27-4806Cancelled Feb 6, 2012 · Exported to Philippines · Aviatour N54116Cessna 172P · S/N 17274880Cancelled Aug 4, 2009 · Exported to Indonesia · Built 1981 · Aviatour Inc N46862Cessna 152 · S/N 15283124Cancelled Jul 22, 2009 · Exported to Philippines · Built 1979 N214YASukhoi SU-26 · S/N 03-03Cancelled Jun 10, 2009 · Exported to Belarus · Built 1990 · Aerobatic Aircraft Of Texas N62166Cessna 172P · S/N 17275224Cancelled May 5, 2009 · Exported to Philippines N63959Cessna 172P · S/N 17275502Cancelled Jan 22, 2009 · Exported to Philippines · Built 1981 N53479Cessna 172P · S/N 17274759Cancelled Dec 29, 2008 · Exported to Philippines · Built 1981 · Aviatour Inc N9469SBeech 95-C55 · S/N TE-67Cancelled Jan 23, 2008 · Triennial form not returned · Built 1966 · Gta Investments N8144DPiper PA-32R-301T · S/N 32R-8029046Cancelled Apr 27, 2005 · Sale reported · Built 1979 N49275Cessna 152 · S/N 15281216Cancelled Mar 18, 1992 · Exported to Germany · Asod Flying Group N45865Musick SONERAI II · S/N 00031Cancelled Jul 18, 1979 · Built 1977 · Musick Richard W N6940VMooney M20F · S/N 22-1313Cancelled Apr 20, 1976 · Exported to Canada · Lancaster Aero Inc N9104PPiper PA-24-260 · S/N 24-4581Cancelled Jun 2, 1971 · Royder Medical Surgical Association N25716Piper J4A · S/N 4813Cancelled Feb 21, 1956 · Built 1939 · Foote Lou - Lou Foote Aernautics N59302Cessna T-50 · S/N 5958Cancelled Oct 26, 1955 · Foote Lou/DBA Lou Foote Flying Service N75982Consolidated Vultee BT-13A · S/N 1359Cancelled Aug 24, 1954 · Lou Foote/ DBA Lou Foote Flying Services N32545Piper J3L-65 · S/N 5443Cancelled Mar 1, 1950 · Foote Lou N41162Piper J3C-65 · S/N 7838Cancelled Jan 4, 1949 · Foote Lou DBA Lou Foote Flying Service N34338Meyers OTW-145 · S/N 83Cancelled Nov 24, 1948 · Foote Lou

Back to Lancaster, TX