Cancelled registrations · 19

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 = 'MN' AND d.registrant_city = 'ROSEAU' 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 = 'MN' AND d.registrant_city = 'ROSEAU'
  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 = 'MN' AND d.registrant_city = 'ROSEAU'
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.

N638JMMeriwether Jon ARION LIGHTNING · S/N 00098Cancelled May 6, 2023 · Sale reported, canceled · Built 2010 N873LAAnderson Matthew Osberg CHALLENGER II · S/N CH2-0800-1998Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Built 2001 · Anderson Matthew O N6758Schultz CASSUTT III M 2 · S/N 001Cancelled Nov 25, 2014 · Registration expired, pending cancellation · Built 1978 · Schultz Leon F N81688Aeronca 7AC · S/N 7AC-307Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1945 · Johnson James P N5865GCessna A188B · S/N 18801158TCancelled Nov 18, 2010 · Exported to Dominican Republic · Built 1973 · Roseau Ag Inc N9220RCessna A188B · S/N 18802164TCancelled Mar 9, 1998 · Second triennial mailing, no response · Schultz Leon F N7465VMooney M20C · S/N 201159Cancelled Sep 15, 1992 · Triennial form not returned · Lee Jim N9207RCessna A188B · S/N 18802152TCancelled Apr 16, 1982 · Schultz Leon N9846VCessna 188 · S/N 188-0096Cancelled Jul 25, 1977 · Schultz Leon N4835XCessna 150G · S/N 15064885Cancelled Dec 9, 1974 · Exported to Canada · Built 1966 · Northland Flying Club N2577FChampion 7GCAA · S/N 32Cancelled Mar 25, 1974 · Hedlund Emil O N7800ACessna 180A · S/N 32697Cancelled Aug 14, 1972 · Exported to Canada · O K Machine Company N1872NCessna 120 · S/N 12116Cancelled Aug 19, 1970 · Exported to Canada · Built 1947 · Roseau Flying Club N96411Taylorcraft BC12-D · S/N 8711Cancelled May 11, 1970 · Exported to Canada · Built 1946 · Dahl C E N85484Aeronca 7AC · S/N 7AC-4224Cancelled Nov 24, 1965 · Exported to Canada · Bodenhamer Wayne N6119HPiper J3C-65 · S/N 19280Cancelled Jul 10, 1962 · Grahn Hilding N79249Fairchild M-62A-3 · S/N T42-4293Cancelled Nov 24, 1959 · Roseau Flying Club N2140EAeronca 7DC-CONV · S/N 7AC-5711Cancelled Jul 21, 1959 · Exported to Canada · Built 1946 · Carver D L N35561Piper J3C-65 · S/N 6467Cancelled May 18, 1959 · Exported to Canada · D L Carver

Back to Roseau, MN