OpenAirDocs.org
Miles City, MT

Cancelled registrations · 47

Query with SQL
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 = 'MILES CITY'
  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.

N162TPiper PA-18 · S/N 18-2276Cancelled Apr 6, 2024 · Sale reported, canceled · Built 1953N6205GCessna 150K · S/N 15071705Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Built 1969 · Wheatcroft John BN2101DPiper PA-25-235 · S/N 257556092Cancelled Aug 12, 2022 · Exported to Mexico · Hartman Dave RN9012PWeatherly 620B · S/N 1608Cancelled May 9, 2022 · Registration expired, pending cancellation · Hartman Dave R DBAN14323Piper PA-18-150 · S/N 18-7409083Cancelled May 7, 2022 · Registration expired, pending cancellation · Hartman Dave RN926KPiper PA-31T1 · S/N 31T8004046Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1980 · Fmr Aviation LLCN8215TCessna 175B · S/N 17556915Cancelled Jul 8, 2019 · Sale reported, canceledN8148TCessna 175B · S/N 17556848Cancelled Dec 4, 2018 · Sale reported, canceled · Built 1960N157VMVander Molen Harold AVID FLYER · S/N 0157Cancelled Oct 22, 2018 · Registration expired, pending cancellation · Built 1986 · Benti Dale LN400SQEagercraft SQ400 · S/N 400SQCancelled Aug 10, 2018 · Registration expired, pending cancellation · Built 2015 · Eagercraft LLCN9001FWeatherly 620B · S/N 1602Cancelled Apr 4, 2018 · Registration expired, pending cancellation · Built 1995 · Hartman DaveN9097CAerostar International RX-9 · S/N RX9-3001Cancelled Dec 18, 2017 · Built 1993 · High Plains Drifter Hot Air Balloons LLCN99LEHiller UH-12E · S/N HA3082Cancelled Nov 20, 2015 · Exported to Mexico · Built 1981 · Robinson Nathan KN7666DPiper PA-18-150 · S/N 18-5935Cancelled May 21, 2015 · Registration expired, pending cancellation · Built 1957 · Cyrus Chad H DBAN7456Arnold VOLKSPLANE VP-1 · S/N 1Cancelled Nov 12, 2013 · Registration expired, pending cancellation · Built 1977 · Padilla John AN1177KFelmlee George S CHALLENGER II · S/N CH209951397Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Fox Daniel WN1531APiper PA-20 · S/N 20-725Cancelled Oct 15, 2012 · Registration expired, pending cancellation · Built 1951 · Hartman Dave RN17062Cessna 150L · S/N 15073613Cancelled Jul 20, 2005 · Triennial form not returned · Built 1972 · Lund Christian JN731UACessna A188B · S/N 18803155TCancelled Dec 2, 2004 · Exported to Brazil · Built 1978 · Hartman Dave RN8347TCessna 175C · S/N 17557047Cancelled Feb 20, 2002 · Built 1961 · Stubblefield TerryN4686RPiper PA-28-140 · S/N 28-21447Cancelled Feb 6, 2002 · Triennial form not returned · Built 1966 · Mitchell Clifton GN5068SPiper PA-28R-200 · S/N 28R-35807Cancelled Mar 1, 1982 · Mann Russell LN5029NBellanca 7GCBC · S/N 106278Cancelled Jun 11, 1980 · Exported to Canada · Ramage John FN59200Cessna T210L · S/N 21060158Cancelled Jan 18, 1980 · Mathers Brothers RanchN11547Cessna 150L · S/N 150-75509Cancelled Sep 7, 1976 · Miles City Aero Service IncN1719TPiper PA-28-140 · S/N 28-7125032Cancelled Nov 17, 1975 · Exported to Canada · Kehrberg Wallace RN88331Bellanca 8GCBC · S/N 11374Cancelled Aug 21, 1975 · Exported to Canada · Built 1974 · Big Sky Bellanca Sale/Stoltz FrankN8094FCessna 150F · S/N 15064194Cancelled May 7, 1973 · Built 1966 · Miles City Aero Services IncN2369NCessna 140 · S/N 12618Cancelled Mar 31, 1972 · Exported to Canada · French LarryN4922PPiper PA-23-235 · S/N 27-513Cancelled Jun 30, 1970 · Petroleum Producers IncN2974LMooney M20F · S/N 670333Cancelled Jun 16, 1970 · Flaggemeyer ThomasN4648MPiper PA-11 · S/N 11-164Cancelled Jun 7, 1970 · Helvey Charles EN2888YCessna 182E · S/N 18253888Cancelled Jun 5, 1970 · Built 1962 · Lomac IncN81882Aeronca 7AC · S/N 7AC-505Cancelled Nov 28, 1960 · Cadf Aero Club Miles City ChapterN3355APiper PA-18A-135 · S/N 18-2995Cancelled May 21, 1960 · Montana Dakota Spraying Service IncN5401HPiper PA-14 · S/N 14-515Cancelled Jun 23, 1958 · Exported to Mexico · Lewis Paul NN1980PPiper PA-18 · S/N 18-4215Cancelled May 2, 1958 · Miles City Aero ServiceN50204Timm N2T-1 · S/N 319Cancelled Apr 25, 1952 · W A Mitchell CoN49451Piper J3C-65 · S/N G-61Cancelled Jan 3, 1952 · Askins George FN33283Piper J5A · S/N 5-483Cancelled Sep 5, 1951 · L B FosterN47378Piper J3C-65 · S/N 10398Cancelled Aug 1, 1951 · Claybrook G CN48285Fairchild PT-19A · S/N 7203AECancelled May 2, 1951 · Miles City Flying ServicesN4357HPiper PA-15 · S/N 15-142Cancelled Oct 17, 1949 · Labree CharlesN5523HPiper PA-11 · S/N 11-1025Cancelled Sep 9, 1949 · Miles City Flying ServiceN25819Piper J3C-65 · S/N 3802Cancelled Aug 18, 1948 · Etchart Flying SchoolN92746Piper PA-12 · S/N 184Cancelled Feb 10, 1948 · Miles City Flying Service IncN33761Aeronca 65-LB · S/N LB13311Cancelled Jan 27, 1943 · Built 1941 · Leighton Brud Foster
Back to Miles City, MT