Skip to content

Cancelled registrations · 277

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

N53XPScoda Aeronautica Ltda SUPER PETREL XP · S/N S0412Cancelled Sep 14, 2026 · Registration pending, canceled · Built 2024 N98HCCollins/Gottschang GLASAIR SH-2 · S/N 329Cancelled Jul 11, 2026 · Sale reported, canceled N2613VCessna 170 · S/N 18123Cancelled Jan 31, 2026 · Sale reported, canceled · Built 1948 N480NABritish Aerospace BAE 146 SERIES 200A · S/N E2055Cancelled Dec 2, 2025 · Neptune Aviation Services Inc N6736KGrumman/Schweizer G-164D · S/N 31CCancelled Jun 23, 2025 · Sale reported, canceled · Built 1978 N599TCLearjet 60 · S/N 261Cancelled Mar 12, 2025 · Built 2002 · 599tc LLC N41685Bellanca 7GCBC · S/N 589-73Cancelled Dec 28, 2024 · Registration pending, canceled · Built 1973 N514BBIsrael Aircraft Industries 1125 WESTWIND ASTRA · S/N 032Cancelled Jul 24, 2024 · Built 1989 · D & E Aviation LLC N617VMoth 60-GMW · S/N 179Cancelled Jul 13, 2024 · Registration pending, canceled N3707HMooney M20J · S/N 24-0907Cancelled Mar 1, 2024 · Sterling Silver Flyers LLC N36WLBell Helicopter Textron 212 · S/N 31302Cancelled Nov 29, 2023 · Exported to Canada · Built 1988 · Corpat Inc N12VVJames C Geyman RV-9A · S/N 93267Cancelled Sep 20, 2023 · Built 2022 · Geyman James C N4875BCessna 310 · S/N 35175Cancelled Sep 3, 2023 · Built 1955 · Weatherproof Montana LLC N162NHHisserich Nicholas S JETEXEC · S/N 109Cancelled May 16, 2023 · Built 2019 · Tass LLC N64976Boeing B75N1 · S/N 75-6904Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1943 · Motorstyle Aero LLC N5099BBeech G35 · S/N D-4392Cancelled Jan 14, 2023 · Sale reported, canceled · Built 1955 N122HPLockheed P2V-7 · S/N 148341Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Neptune Aviation Services N128HPLockheed P2V-7 · S/N 140972Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Neptune Aviation Services N2216SLockheed P2V-7 · S/N 148346Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Neptune Aviation Services N2218ELockheed P2V-7 · S/N 148356Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Neptune Aviation Services Inc N2218QLockheed P2V-7 · S/N 148359Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Neptune Aviation Services N655HSSigmon Harvey E BUSHBY MUSTANG II · S/N 719Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 1981 · N Ranch LLC N84343Cessna 172K · S/N 17258430Cancelled Dec 3, 2022 · Registration expired, pending cancellation · N Ranch LLC N908CHSikorsky S-61N · S/N 61776Cancelled Aug 4, 2022 · Built 1977 · Heligroup Fire LLC N57477Bellanca 7GCBC · S/N 517-73Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Built 1973 · Hulla Richard W N2126YPiper PA-44-180 · S/N 44-7995286Cancelled May 23, 2022 · Exported to Canada · Built 1979 · Air Fleet Holdings LLC N303ADTroy Woodland JA35 SUPERSTOL STRET · S/N JA 303-06-13Cancelled May 21, 2022 · Registration ineffective or invalid · Built 2014 · De Cadenet Motor Racing Ltd N9933RCessna U206G · S/N U20606987Cancelled May 9, 2022 · Registration expired, pending cancellation · Btp Inc N14WMPiper PA-18A 150 · S/N 18-6695Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Built 1977 · Interpol Security LLC N64RARichards Heavylift Helo UH-1B · S/N 65-12854Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 1965 · Iron Eagle Helicopter Inc N621PGPiper PA-31-350 · S/N 31-7652049Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 1975 · Dakota Territory Tours Inc N3103WMiller Jan David 01 · S/N 1003Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Gray Ghost LLC N3704UCessna 182G · S/N 18255104Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Built 1963 · Btp Inc N7723TCessna 172A · S/N 47323Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Built 1960 · Stensatter Gary A N175SRCessna 650 · S/N 650-0175Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Built 1989 · Montana Bizjets LLC N807NALockheed P2V-5 · S/N 131424Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1954 · Neptune Aviation Services Inc N96264Lockheed P2V-5F · S/N 128346Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Neptune Aviation Services Inc N96278Lockheed P2V-5F · S/N 131459Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1953 · Neptune Aviation Services N9855FLockheed P2V-5F · S/N 131445Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1953 · Neptune Aviation Services Inc N172LHCessna 172F · S/N 17253194Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Built 1965 · Oso Air LLC N7718XCessna 172B · S/N 17248218Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Oso Air LLC N422WMMccloskey Bruce M FLIGHTSTAR II SC · S/N 401Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 2013 · Mccloskey Bruce M N891DCAviat A-1C-180 · S/N 3202Cancelled Nov 6, 2020 · Built 2014 · Ccs Logistics LLC N401HPBell 206B · S/N 3314Cancelled Sep 24, 2020 · Registration expired · Built 1981 · Dakota Territory Tours Acc N8218JLockheed L100-30 · S/N 5056Cancelled May 2, 2020 · Registration expired, pending cancellation · Ruftberg LLC N203EVLockheed P2V-5F · S/N 128382Cancelled May 1, 2020 · Registration expired, pending cancellation · Built 1953 · Neptune Aviation Services Inc N443NALockheed P2V-7 · S/N 145906Cancelled May 1, 2020 · Registration expired, pending cancellation · Built 1958 · Neptune Aviation Services Inc N445NALockheed P2V-7 · S/N 140443Cancelled May 1, 2020 · Registration expired, pending cancellation · Built 1954 · Neptune Aviation Services Inc N6311WPiper PA-28-140 · S/N 28-20370Cancelled Dec 16, 2019 · Sale reported, pending cancellation · Built 1964 N50MPHughes 369A · S/N 1180860Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Built 1968 · Lyft LLC

Back to Missoula, MT