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 = 'DETROIT LAKES' 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 = 'DETROIT LAKES'
  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 = 'DETROIT LAKES'
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.

N229GREa Vision EA J100 · S/N 85394Cancelled May 16, 2026 · Sale reported, canceled N61SCCashen SUPER ACRO SPORT · S/N 572Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Built 1977 · Kiebke Theodore M N8398TKiebke Theodore M SNB · S/N 001Cancelled Oct 24, 2019 · Built 2011 · Kiebke Theodore M N2838VPiper PA-28-161 · S/N 28-7916466Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1979 · Ede Aire Inc N3977VNorthland QUICKSILVER MX II · S/N 1346Cancelled Aug 28, 2013 · Registration expired, pending cancellation · Built 1983 · Northland Aviation Inc N1197RRaven S55A · S/N S55A-330Cancelled Aug 17, 2011 · First renewal notice · Built 1977 · Tollefson Tom G N391CAviat A-1A · S/N 1467Cancelled Jul 19, 2011 · Exported to Australia · Built 2000 · Druitt David T N2156YCessna 172D · S/N 17249656Cancelled Apr 30, 2008 · Second triennial mailing, no response · Built 1962 · Peterson Collin C N256JBellanca 7GCBC · S/N 1212-80Cancelled Oct 25, 2003 · Triennial form not returned · Built 1980 · White Paul W Jr N9511XCessna 210A · S/N 21057811Cancelled May 14, 2001 · Exported to Mexico · Horizon Aircraft Sales Inc N19172Cessna 150L · S/N 15074212Cancelled Mar 24, 2000 · Exported to Canada · Oberg Roger A N7761PPiper PA-24-250 · S/N 24-2978Cancelled Feb 27, 1986 · Exported to Canada · Beaton James R N2487MPiper PA-12 · S/N 12-1560Cancelled Aug 22, 1985 · Exported to Canada · Built 1947 · North Country Flyers Inc N8215FCessna 150F · S/N 15064315Cancelled Oct 13, 1981 · Resort Region Flying Club N6126ECessna 172 · S/N 46226Cancelled Oct 29, 1974 · Resort Region Flying Club N72606Cessna 120 · S/N 9778Cancelled Apr 23, 1974 · Fevig Gordon O N50324Cessna T-50 · S/N 5373Cancelled Jun 23, 1970 · Lund Robert L N86894Bellanca 14-13 · S/N 1256Cancelled Mar 9, 1961 · Exported to Canada · Schaleben Lee V N908Curtiss JN-4 (CANADIAN) · S/N L-1Cancelled May 1, 1930 · Built 1927 · Hamblin Donald C

Back to Detroit Lakes, MN