Kalispell, MT

Cancelled registrations · 132

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

N4186RPiper PA-32-300 · S/N 3240520Cancelled Aug 2, 1995 · Second triennial mailing, no response · Stewart David GN3615UCessna 182F · S/N 18255015Cancelled Mar 16, 1994 · Triennial form not returned · Eagle Aviation IncN104MBuecker AERO Z 131 · S/N 157Cancelled Apr 17, 1992 · Galpin Henry MN4986AParson-William S-14F · S/N 087622Cancelled Dec 24, 1991 · Triennial form not returned · Parson William JN8556YPiper PA-30 · S/N 301703Cancelled Aug 9, 1991 · Triennial form not returned · Flathead Beverage CoN7915Sud SA315B LAMA · S/N 2296Cancelled May 23, 1986 · Exported to Malaysia · Aero Systems IncN234JSCessna 175 · S/N 55489Cancelled Dec 11, 1984 · Administratively canceled · Stockhill Aviation IncN738XHCessna 172N · S/N 17270314Cancelled Jan 12, 1983 · Stockhill Aviation IncN2709GCessna 182B · S/N 52009Cancelled Sep 30, 1981 · ManionsN1057UPiper PA-34-200 · S/N 34-7250041Cancelled Apr 11, 1981 · Administratively canceled · Strand Aviation IncN2087XCessna 182H · S/N 18256187Cancelled Sep 7, 1976 · Built 1965 · Stockhill Aviation IncN55388Piper PA-34-200 · S/N 347350210Cancelled Jun 4, 1974 · Exported to Canada · Strand Aviation IncN7988WPiper PA-28-180 · S/N 28-2045Cancelled Apr 22, 1974 · Exported to Canada · Stockhill Aviation IncN6031RCessna 172G · S/N 17253700Cancelled Apr 3, 1974 · Exported to Canada · Stockhill Aviation IncN60022Cessna 150J · S/N 15070009Cancelled Mar 20, 1974 · Exported to Canada · Stockhill AviationN1602CCessna 180 · S/N 30302Cancelled Aug 13, 1973 · Exported to Canada · Olsen Arden EN93316Ercoupe 415-C · S/N 639Cancelled Jul 24, 1973 · Exported to Canada · K & M Monument EnterprisesN6818PPiper PA-24-250 · S/N 24-1951Cancelled Jul 9, 1973 · Exported to Canada · Strand Aviation IncN5912WPiper PA-28-160 · S/N 28-3064Cancelled May 11, 1971 · Exported to Canada · Stockhill Aviation IncN6507JPiper PA-28-180 · S/N 28-4943Cancelled Aug 20, 1969 · Exported to Canada · Myron K And Marilyn J Strand/Strand AviationN2603MPiper PA-12 · S/N 12-1065Cancelled Mar 5, 1969 · Exported to Canada · Built 1946 · Mather Anthony D & Mather James NN5096UCessna 206 · S/N 206-0096Cancelled Jan 24, 1966 · Exported to Canada · Mountain Manufacturing Co IncN13472Stinson JR. SR · S/N 8725Cancelled May 1, 1958 · Built 1933 · Flathead Air Transport IncN4464MPiper PA-12 · S/N 12-3420Cancelled Jul 15, 1954 · Cole Eugene AN5286HPiper PA-16 · S/N 16-90Cancelled Aug 26, 1953 · Cole Eugene AN49062Interstate S-1B1 · S/N 6Cancelled Mar 29, 1951 · Roy E StewartN4077VCessna 170 · S/N 18409Cancelled Jan 23, 1950 · Flathead Air Transport IncN84346Aeronca 7AC · S/N 7AC-3043Cancelled Jun 22, 1949 · Corsair Flying ServiceN6155MStinson 108-3 · S/N 108-4155Cancelled Jun 17, 1949 · Built 1948 · Corsair Flying Service IncN21090Aeronca KCA · S/N KCA-62Cancelled May 12, 1948 · Strissel Orien MN22174Aeronca 50-C · S/N C-2769Cancelled Mar 11, 1940 · Built 1939 · Doney Vern M / King Robert FN12045Anton C Jacobson JACOBSON HEATH 1931 · S/N 101Cancelled Jun 15, 1938 · Jellison Robert Ernest
Back to Kalispell, MT