Skip to content

Cancelled registrations · 25

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

N9346EJacob E Barthule L11B · S/N 001Cancelled Jul 1, 2023 · Barthule Jacob E N6022GCessna 150K · S/N 15071522Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Built 1969 · Gebhardt Kelly N N9614LAviat A-1 · S/N 1180Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Built 1991 · Kelly Kelly G N80648Cessna 172M · S/N 17266689Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Built 1976 · Gebhardt Kelly N N231DEMooney M20K · S/N 25-0138Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 1979 · Rose Wendi M N70367Piper J3C-65 · S/N 17349Cancelled Jan 31, 2020 · Revoked, canceled · Built 1946 · Stott Glenn L N31276Bellanca 7GCBC · S/N 407-72Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Kite Cattle Co N2930PPiper PA-22-150 · S/N 22-3199Cancelled Mar 16, 2019 · Registration expired, pending cancellation · Built 1955 · Waymire David O N49167Taylorcraft DCO-65 · S/N L-5984Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Built 1944 · Stahl Tobias K N3460APiper PA-22 · S/N 22-1744Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1953 · White John M N6902RCessna T210G · S/N T210-0302Cancelled Mar 2, 2018 · Registration expired, pending cancellation · Built 1967 · Gebhordt Kelly N N1659PPiper PA-22-150 · S/N 22-3088Cancelled Feb 28, 2018 · Registration expired, pending cancellation · Built 1955 · Waymire David O N76606Cessna 120 · S/N 11046Cancelled Feb 28, 2018 · Registration expired, pending cancellation · Built 1946 · Gebhardt Kelly N N755MRBuss Mike L QUICKSILVER MX · S/N 148755Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Buss Mike L N63913Spicer STEWART S-51B · S/N 001Cancelled Feb 6, 2008 · Built 1974 · Spicer Bruce W N502DRAir Tractor AT-502B · S/N 502B-0635Cancelled Dec 23, 2004 · Exported to Argentina · Built 2001 · Lemmon Darrell N4970JCessna T188C · S/N T18803792TCancelled Jul 12, 1999 · Triennial form not returned · Lemmon Darrell C N9792PPiper PA-25-260 · S/N 257556106Cancelled Jun 6, 1992 · Triennial form not returned · Moore Quality Flying Service Inc N1171MCessna 172K · S/N 17258671Cancelled Feb 19, 1975 · Exported to Canada · Albrights Flying Inc N43333Taylorcraft BC12-D · S/N 6992Cancelled Nov 13, 1970 · Exported to Canada · Albrights Flying Inc N6166CCallair A-4 · S/N 179Cancelled Jun 12, 1970 · Albrights Flying Inc N864APiper PA-22 · S/N 22-165Cancelled Jun 12, 1970 · Albrights Flying Inc N12724Comstock David 1932 · S/N 1Cancelled Mar 28, 1951 · Built 1932 · Comstock David W N84456Aeronca 7AC · S/N 7AC-3157Cancelled Jan 20, 1948 · Roundup Skyriders N1287Eaglerock LONG WING EAGLEROCK · S/N 260Cancelled Sep 10, 1929 · R D Staunton

Back to Roundup, MT