Cancelled registrations · 17

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 = 'MI' AND d.registrant_city = 'GROSSE POINTE' 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 = 'MI' AND d.registrant_city = 'GROSSE POINTE'
  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 = 'MI' AND d.registrant_city = 'GROSSE POINTE'
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.

N853CZCzech Aircraft Works Spol Sro MERMAID · S/N 06MM008Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 2007 · Michigan Sport Aviation LLC N124ACRepublic RC-3 · S/N 60Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1946 · Bamc Inc N87624Interplane Spol.S.R.O SKYBOY · S/N 79/2003 JABIRU 2200-22A1932Cancelled Dec 27, 2016 · Third renewal notice · Interplane LLC N5988LAmerican AA-1 · S/N AA1-0288Cancelled Dec 16, 2014 · Registration pending, canceled · Built 1969 N4044CCessna T310R · S/N 310R1354Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1978 · K & Gt LLC N30MSCessna U206G · S/N U206-03573Cancelled Nov 26, 2013 · Built 1977 · Flying Medical Service Inc N69689Interplane S R O SKYBOY · S/N 079/2003Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Interplane LLC N69877Interplane S R O SKYSTAR · S/N P01/2003Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 2003 · Interplane LLC N3872VCessna 195 · S/N 7333Cancelled Sep 21, 2012 · Sale reported, canceled · Built 1949 N36MSCessna U206F · S/N U20601827Cancelled Oct 18, 2007 · Triennial form not returned · Built 1972 · Flying Medical Service N252YXMooney M20K · S/N 25-1092Cancelled Jan 25, 2002 · Built 1986 · Smaug Air Corp N8594HNorth American NAVION · S/N NAV-4-635Cancelled Aug 13, 1971 · Carey Michael M N86068Aeronca 11AC · S/N 11AC-491Cancelled Sep 9, 1970 · Built 1946 · Hanley Thomas J N97890Consolidated Vultee BT-13A · S/N 9840Cancelled Feb 15, 1957 · Bull Arthur W N3814VCessna 170 · S/N 18672Cancelled Nov 16, 1951 · Hickey William S N9934HNorth American SNJ-2 · S/N 2554Cancelled Jul 23, 1951 · Built 1947 · Spring Frank S N283YFolkerts-Fordon And Neumann FOLKERTS · S/N 1Cancelled May 29, 1938 · Built 1936 · Fordon Georgia E

Back to Grosse Pointe, MI