Cancelled registrations · 18

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 = 'ME' AND d.registrant_city = 'TURNER' 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 = 'ME' AND d.registrant_city = 'TURNER'
  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 = 'ME' AND d.registrant_city = 'TURNER'
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.

N6542LGrumman American Avn. AA-5 · S/N AA5-0642Cancelled Aug 27, 2023 · Built 1974 · Ricker Harry N77800Bonney Richard A B-1 · S/N 01Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 1996 · Soucy Michael L N520GTCessna 180 · S/N 30064Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1953 · Twitchell Gard S N95349Taylorcraft BC12-D · S/N 9749Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Built 1946 · St Pierre Marc R N75705Cessna 172N · S/N 17267887Cancelled Oct 19, 2012 · Sale reported, pending cancellation · Built 1976 N4412FCessna 170 · S/N 18131Cancelled Sep 12, 2012 · Sale reported, canceled N2065ECessna 172N · S/N 17271140Cancelled Aug 23, 2012 · Registration expired, pending cancellation · Built 1978 · Turner Avn Co Inc N3186HFrost Howard R KITFOX III · S/N 1045Cancelled Aug 16, 2012 · Exported to Canada · Built 1992 · Twitchell Dale M N4006VCessna 170 · S/N 18325Cancelled Jul 15, 2011 · Expired dealer · Built 1948 · Turner Aviation Co Inc N475CAviat A-1B · S/N 2068Cancelled Jun 7, 2011 · Exported to Canada · Youland David R N3722JCessna 150G · S/N 15065022Cancelled Oct 29, 2010 · Exported to Canada · Built 1966 · Crosswinds Air N3483VCessna 150M · S/N 15076517Cancelled Sep 2, 2008 · Triennial form not returned · Built 1974 · Turner Aviation Co Inc N53047Cessna A185F · S/N 18502337Cancelled Mar 25, 2008 · Exported to Canada · Built 1973 · Turner Aviation Co Inc N7011YPaiement Thomas RANS S-12 AIRAILE · S/N 1092309Cancelled Jun 11, 2003 · Triennial form not returned · Built 1992 · Stevens Leslie E N8024YCessna 185B · S/N 1850568Cancelled Jun 2, 1980 · Exported to Canada · Built 1963 · Turner Aviation Co Inc N3752XAero Commander 100-180 · S/N 5065Cancelled Jun 3, 1975 · Turner Aviation Co Inc N4077HPiper PA-12S · S/N 12-3503Cancelled Dec 5, 1961 · Exported to Canada · Built 1947 · Turner Aviation Co Inc N4156VCessna 170 · S/N 18488Cancelled Apr 24, 1953 · Exported to Canada · Turner Aviation Co Inc

Back to Turner, ME