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 = 'OH' AND d.registrant_city = 'MASSILLON' 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 = 'OH' AND d.registrant_city = 'MASSILLON'
  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 = 'OH' AND d.registrant_city = 'MASSILLON'
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.

N111GBBreitsprecher BUSHBY MUSTANG II · S/N 182Cancelled Nov 4, 2023 · Sale reported, canceled · Built 1975 N688HHDJI PHANTOM 3 PROFESSION · S/N P77DCF1Cancelled Sep 3, 2022 · Registration expired, pending cancellation · What'S Up Ohio LLC N43DPParsons Dennard C HATZ BIPLANE CB-1 · S/N 492Cancelled May 9, 2022 · Registration expired, pending cancellation · Built 1996 · Newell Ryan A N577SKPiper PA-34-200T · S/N 34-8070087Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Mitchell James D N47208Taylorcraft DCO-65 · S/N 0-4550Cancelled Nov 18, 2017 · Revoked, canceled · Built 1942 · Hostetler Lloyd Cletes N66633Cessna 150M · S/N 15076169Cancelled Dec 19, 2015 · Third renewal notice · Built 1974 · Jackson William T N19950Cessna 172M · S/N 17260880Cancelled Jun 7, 2013 · Sale reported, canceled · Built 1972 N5143RGalaxy Balloons GALAXY 11 · S/N GLX-10311Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Built 1998 · Russell Marc D N25344Cessna 152 · S/N 15280606Cancelled Aug 21, 2012 · Sale reported, canceled · Built 1977 N19171Cessna 150L · S/N 15074211Cancelled Aug 6, 2012 · Sale reported, canceled · Built 1972 N3475QPiper PA-32R-300 · S/N 32R-7780316Cancelled Sep 9, 2008 · Exported to Canada · Built 1977 · Aircraft Sales Inc N280TMFisher Flying Products R80 TIGER MOTH · S/N TM001Cancelled Feb 21, 2008 · Exported to United Arab Emirates · Built 1993 N126RLPiper PA-32R-301 · S/N 32R-8013005Cancelled Nov 26, 2007 · Exported to Canada · Built 1979 · Aircraft Sales Inc N3838NBeech 35 · S/N D-1075Cancelled Feb 11, 2002 · Triennial form not returned · Built 1947 · Fraelich Reno W N3676MPiper PA-12 · S/N 122626Cancelled Mar 21, 1991 · Triennial form not returned · Eggleston Archa F N555RMCessna 310Q · S/N 310Q0995Cancelled Mar 3, 1978 · Marsh Ronald E N4178MPiper PA-12 · S/N 12-3070Cancelled Jan 12, 1971 · Built 1947 · Moll Frank J Jr N47063Fairchild M-62A · S/N T42-3919Cancelled Nov 18, 1955 · Williams Merle Virgil Nussbaum & Harry Sibila N8066Spartan C3-120 · S/N 98Cancelled Jul 27, 1951 · Riesbeck Wilbur S & Graber Richard H N5529Grant Stephen G-4 · S/N 101Cancelled Feb 26, 1935 · Goembel Phil N2764Curtiss JN4D · S/N 222Cancelled Dec 19, 1932 · Marshall R A

Back to Massillon, OH