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

N12108Digby Doll STOLP SA-300 · S/N 200Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Built 1970 · Digby Larry G N224AHCirrus Design SR22 · S/N 1531Cancelled Sep 15, 2021 · Exported to Canada · Built 2005 · Von Seggern Wesley N49MRBell 47G-3B-2 · S/N 6828Cancelled May 13, 2015 · Registration expired, pending cancellation · Vanderhoff Doulgas S N3997GGreat Lakes Skycycles CONDOR III+2 · S/N 83-113-3-2Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Great Lakes Skycycles Inc N5505ZPiper PA-22-108 · S/N 22-9291Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1962 · Plainview Aviation Inc N47412Cessna 152 · S/N 15283223Cancelled Dec 13, 2012 · Registration expired, pending cancellation · Built 1979 · Plainwell Aviation Inc N171MAMitsubishi MU-2B-40 · S/N 431 S.A.Cancelled Jun 26, 2009 · Triennial form not returned · Built 1980 · Drug And Laboratory Disposal Inc N1022ZSawyer TINY ACE SPECIAL · S/N 1Cancelled Aug 10, 2007 · Triennial form not returned · Built 1961 · Carlson Roy A N36940Aeronca 65-TAC · S/N C2471TACancelled Jul 23, 2002 · Triennial form not returned · Built 1941 · Morehouse Merle G N42DFFroelich Del QUICKIE Q-2 · S/N 2492Cancelled Sep 15, 2000 · Triennial form not returned · Froelich Del N109RSchreder HP-14 · S/N 6Cancelled Apr 15, 1982 · Administratively canceled · Whitmore Charles H N7685JPiper PA-28R-180 · S/N 28R-31086Cancelled Apr 24, 1975 · Exported to Canada · Becker John A N2981CJupiter J 1 · S/N KRC-1Cancelled Apr 21, 1975 · Schiffer Albert E N86624Bellanca 7GCBC · S/N 675-74Cancelled Jul 23, 1974 · Digby Larry G & Otto Eddie T N24220Aeronca 65-TC · S/N C6847Cancelled Oct 7, 1970 · Built 1939 · Plainwell Aviation Inc N2593APiper PA-20 · S/N 20-940Cancelled Jul 13, 1970 · Schmitt Elden N29629Taylorcraft BL-65 · S/N 2471Cancelled Jul 13, 1970 · Plainwell Aviation Inc N5023NConsolidated Vultee BT-13A · S/N 10424Cancelled Feb 15, 1956 · Cooper Jack N69868Fairchild M-62C · S/N 4113AECancelled Oct 14, 1955 · Otsego-Plainwell Flying Service N2407EAeronca 7AC · S/N 7AC-5986Cancelled Feb 19, 1952 · Green Howard E

Back to Plainwell, MI