Skip to content

Cancelled registrations · 153

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 = 'HELENA' 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 = 'HELENA'
  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 = 'HELENA'
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.

N7565TCessna 172A · S/N 47165Cancelled May 30, 2026 · Registration pending, canceled · Built 1959 N9895MCessna 182P · S/N 18264792Cancelled Apr 4, 2026 · Sale reported, canceled · Built 1976 N305TPCessna/Air Repair 305F · S/N AR-9Cancelled Feb 23, 2026 · Exported to Canada · Built 2004 · Bofus Aviation LLC N28425Luscombe 8A · S/N 1292Cancelled Feb 7, 2026 · Sale reported, canceled N379MECessna T206H · S/N T20608229Cancelled Dec 27, 2025 · Registration pending, canceled · Built 2000 N407DRRogers D R/Rogers S B PROWLER JAGUAR · S/N 14Cancelled Apr 26, 2025 · Registration pending, canceled · Built 2006 N883PASocata TBM 700 · S/N 1036Cancelled Jul 30, 2024 · Exported to Australia · Built 2014 · Bff Enterprises LLC N91026Krupa Vernon J 5151 MUSTANG · S/N 5151-4863808Cancelled May 18, 2024 · Registration pending, canceled · Built 2001 N447SRClaridge Tommy J SKYRAIDER I · S/N 100Cancelled Mar 26, 2024 · Registration pending, canceled · Built 2013 N7890UCessna 172F · S/N 17251890Cancelled May 18, 2023 · Exported to Canada · Built 1964 · Harrington Daneil P N914CDCessna 500 · S/N 500-0150Cancelled May 13, 2023 · Sale reported, canceled N6690Bell OH-58A · S/N 68-16690Cancelled Feb 4, 2023 · Registration expired, pending cancellation · State Of Montana N4558TCameron Balloons US N-105 · S/N 5908Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Built 1993 · Elkins Justin A N24580Beech C23 · S/N M-1410Cancelled Jul 26, 2022 · Second renewal notice · Built 1972 · Tiger Capital LLC N65MYBeech B-60 · S/N P-314Cancelled May 9, 2022 · Registration expired, pending cancellation · Built 1974 · Kma Technology Solutions LLC N1138CPiper PA-22-135 · S/N 22-976Cancelled Apr 8, 2022 · Registration expired, pending cancellation · Built 1953 · Allied Research LLC N69DKKeller Donald J KELLER KRUISER · S/N 1Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Keller Donald J N2831XCessna 177 · S/N 17700231Cancelled Dec 8, 2021 · Registration pending, canceled · Built 1967 N386RVEldridge Carl P RV7A · S/N 71018Cancelled Oct 18, 2021 · Exported to New Zealand · Built 2014 · Castle Rock Services LLC N5950Ream Robert R FALCON XP-B · S/N 600043Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Built 1987 · Odland Michael D N89950Cessna 120 · S/N 9002Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Built 1946 · Mccarter Group LLC N72919Cessna 140 · S/N 10113Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1946 · Lacey Celestine A N416ASHughes Bobby J RV-10 · S/N 40116Cancelled Mar 3, 2021 · Sale reported, canceled · Built 2009 N941JMCessna 550 · S/N 550-0146Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Built 1980 · Slice Of The 406 LLC N152HPBell OH-58A · S/N 71-20363Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Montana Highway Patrol N247EBEdward M Bancker JR SONEX · S/N 0846Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 2012 · Streamline Consulting LLC N504JVGates Lear Jet 24F · S/N 350Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Aviated LLC N1428PPiper PA-23 · S/N 23-484Cancelled Jun 4, 2020 · Built 1956 · Vetter Brent E N56DPBeech 56TC · S/N TG-19Cancelled May 1, 2020 · Registration expired, pending cancellation · Built 1967 · Kma Technology Solutions LLC N929GBBrowning Gregory S ZODIAC 601XL · S/N 66785Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Built 2009 · Travis Jerry N925WPHawker Beechcraft B300 · S/N FL-711Cancelled Jan 15, 2020 · Exported to Italy · Built 2010 · L-3 Communications Advanced Aviation LLC N80RTBeech 200 · S/N BB-370Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Built 1978 · Slice Of The 406 LLC N96684Taylorcraft BC12-D · S/N 8984Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Ritter Robert L Co Ow N7608UCessna T207A · S/N 20700446Cancelled Jun 14, 2019 · Exported to Canada · Built 1978 · Air Burgundy LLC N7811CBensen-Lee S-5 · S/N 1005Cancelled Apr 22, 2019 · Revoked, canceled · Built 1959 · Showers Lemoyne Q N666EQDJI INSPIRE 1 · S/N W13DCB25020519Cancelled Apr 1, 2019 · First renewal notice · Montana Department Of Environmental Quality N7645RBeech 19A · S/N MB-436Cancelled Jan 9, 2019 · Registration expired, pending cancellation · Built 1969 · Veerkamp Billie J N654CTEmbraer EMB-120ER · S/N 120251Cancelled Dec 27, 2018 · Built 1993 · N 251yv LLC N2006ATaylorcraft F21 · S/N F-1019Cancelled May 30, 2018 · Sale reported, canceled · Built 1982 N208BBCessna 208B · S/N 208B0449Cancelled Apr 19, 2018 · Built 1995 · Worldwide Aviation Service LLC N403VPCessna 208B · S/N 208B0403Cancelled Apr 19, 2018 · Registration expired · Built 1994 · Worldwide Aviation Service LLC N8876Bellanca 7GCBC · S/N 477-73Cancelled Apr 16, 2018 · Exported to Mexico · Built 1973 · Dunlop Brian A N7938HPiper PA-12 · S/N 12-843Cancelled Apr 6, 2018 · Revoked, canceled · Built 1946 · Montana Skyways Inc N9434CCessna 180 · S/N 31832Cancelled Apr 4, 2018 · Registration expired, pending cancellation · Klugman Dale N440XRobinson Helicopter R44 II · S/N 13041Cancelled Mar 23, 2018 · Registration expired, pending cancellation · Built 2010 · Mwm Inc N957EACessna 402B · S/N 402B0809Cancelled Mar 15, 2018 · Registration expired, pending cancellation · Exec Air Montana Inc N555VHGates Learjet 25D · S/N 214Cancelled Mar 14, 2018 · Registration expired, pending cancellation · Built 1976 · N555vh LLC N3007ZPiper PA-22-150 · S/N 22-6958Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Built 1959 · Travis Beverly N5820GCessna 150K · S/N 15071320Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1969 · Lemieux David L N2495BBell 47G-2 · S/N 1476Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1956 · Ballou Monte DBA

Back to Helena, MT