Skip to content

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

N633FVJoshua Larry Vilches TAROT 650 · S/N X801Cancelled May 2, 2019 · Registration expired, pending cancellation · Vilches Joshua L N592FVJoshua Larry Vilches TAROT T18 · S/N OCTO1Cancelled Apr 19, 2019 · Registration expired, pending cancellation · Vilches Joshua L N562KVJoshua Larry Vilches ZETA BUFFALO FX-79 · S/N DELTA 1Cancelled Jan 3, 2019 · Registration expired, pending cancellation · Vilches Joshua L N5740CCessna 170A · S/N 19694Cancelled Aug 18, 2018 · Sale reported, canceled · Built 1950 N541ZVRC Hobbies & More DJI FLAME WHEEL F550 · S/N HEX1Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Vilches Joshua L N282DPPiper PA-28-140 · S/N 28-7325206Cancelled Jun 26, 2018 · Registration pending, canceled · Built 1973 N6731BPiper PA-22-150 · S/N 22-4064Cancelled Oct 24, 2017 · Registration expired, pending cancellation · Built 1956 · Dance Chauncey B N4823SPiper PA-32-260 · S/N 32-1254Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1969 · Iflight International LLC N998TCThunder & Colt Airborne Amer COLT 77A · S/N 1669USACancelled Sep 26, 2013 · Registration expired, pending cancellation · Built 1992 · Lasher Roland N6778JPiper PA-28-140 · S/N 28-24503Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1968 · Gates Thomas N7771XCessna 172B · S/N 17248271Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1961 · Clarke Michael J N1825VCessna 120 · S/N 14010Cancelled May 2, 2013 · Sale reported, pending cancellation N89243Cessna 140 · S/N 8263Cancelled Jun 25, 2008 · Exported to Australia · Built 1946 · Martin Jeffrey A N7851ZCessna 150C · S/N 15059951Cancelled Jul 1, 2004 · Triennial form not returned · Built 1963 · Goodrich Robert Paul N3983CAyers Frank SCORPION EXEC · S/N FA1Cancelled May 16, 2003 · Second triennial mailing, no response · Built 1983 · Chapel Robert Bruce N73RDRaven S-50A · S/N S50A-237Cancelled Mar 16, 2001 · Triennial form not returned · Lasher Roland D N7064QCessna 172L · S/N 17260364Cancelled Nov 18, 1993 · Oxford Flying Club Inc N51362Cessna 172P · S/N 17274302Cancelled Nov 17, 1992 · Triennial form not returned · Simonalle Eugene N49972Cessna 152 · S/N 15281421Cancelled Mar 25, 1991 · Exported to Spain · Decker Jeanne H N4625ACessna 180 · S/N 32223Cancelled Mar 31, 1977 · Exported to Canada · Carr Construction Inc

Back to Southbury, CT