Skip to content

Columbia Falls, MT

Cancelled registrations · 22

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 = 'MT' AND d.registrant_city = 'COLUMBIA FALLS' 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 = 'MT' AND d.registrant_city = 'COLUMBIA FALLS'
  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 = 'MT' AND d.registrant_city = 'COLUMBIA FALLS'
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.

N343BHExtra Flugzeugbau EA 300/L · S/N 037Cancelled May 27, 2023 · Sale reported, canceled · Built 1996 N980GSFreefly Systems ALTA · S/N ALTA225772Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Gravityshots.Com Inc N513DWJustin Sands DIAMOND WING · S/N 15-001Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Built 2018 · Diamond Ventures 1 LLC N4722TMaule M-4 · S/N 65Cancelled Apr 19, 2018 · Registration expired, pending cancellation · Built 1964 · Dettwiler John E N917SNDestiny 2000 · S/N 4X3UU08172G000234Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Nuss Mary M N124DFJackson Jerry L AVENGER - V · S/N A0178Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 2004 · Jackson Jerry Lee N2415MPiper PA-12 · S/N 12-1529Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Lee Gary P N2466KLuscombe 8E · S/N 5193Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1947 · Lee Gary P N2473FCessna 180H · S/N 18051675Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1966 · Sands Thomas E N7587HPiper PA-12 · S/N 12-458Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Built 1946 · Lee Gary P N99925Let BLANIK L-13 · S/N 025811Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Built 1974 · Glacier Eagles Soaring Club Inc N51478Raven S-50A · S/N S50A-202Cancelled Aug 13, 2012 · Revoked, canceled · Built 1973 · Hot Air Enterprises Inc N74148Balloon Works FIREFLY 7 · S/N F7-234Cancelled Jan 10, 2012 · Registration pending, pending cancellation N3562MPiper PA-12 · S/N 12-2506Cancelled Dec 29, 2010 · Exported to South Africa · Built 1947 · Lee Gary P N206LPCessna 206H · S/N 20608021Cancelled Jun 24, 2010 · Exported to Argentina · T Air LLC N214XAviat A-1B · S/N 2028Cancelled Feb 27, 2008 · Exported to Poland · Built 1999 · Sands Thomas E N43589Taylorcraft BC12-D · S/N 7248Cancelled Apr 16, 2007 · Exported to Canada · Built 1946 · T-Air LLC N618HPHoye Henry M KOLB TWNSTR MARK III · S/N 1143Cancelled Aug 17, 2000 · Hoye Henry M N2125GCessna 182A · S/N 51425Cancelled Dec 12, 1974 · Exported to Canada · Schmidt F W N6136BCessna 182 · S/N 34136Cancelled Mar 8, 1974 · Exported to Canada · Rost Carroll J N5183ACessna 172 · S/N 28183Cancelled Oct 19, 1971 · Johnson Maurice R N82294Aeronca 7AC · S/N 7AC-923Cancelled May 21, 1965 · Speer Evan G

Back to Columbia Falls, MT