OpenAirDocs.org
Havre, MT

Cancelled registrations · 59

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

N60692Cessna 150J · S/N 15070505Cancelled Jul 18, 2026 · Registration pending, canceled · Built 1969N8690CPiper PA-22-135 · S/N 22-1320Cancelled Jan 7, 2019 · Registration expired, pending cancellation · Built 1953 · Reitan Rodney LN8942QAero Commander S2R · S/N 1612RCancelled Feb 4, 2017 · Revoked, canceled · Built 1972 · Deterding LouisN7990BCessna 172 · S/N 29790Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1957 · Spinner Ronald JN880DWCessna 172M · S/N 17261799Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Williams Field ServiceN36558Piper PA-32RT-300T · S/N 32R-7887052Cancelled Oct 18, 2013 · Registration expired, pending cancellation · Built 1978 · Coca Cola Bottling Company Of HavreN9054TCessna 182C · S/N 52954Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1960 · Robertson William AN7201GCessna 172K · S/N 17258901Cancelled May 6, 2013 · Registration expired, pending cancellation · Built 1969 · Bunn Paul CN1811QBeech A36TC · S/N EA-239Cancelled Apr 14, 2008 · Triennial form not returned · Built 1981 · Textana IncN7239VIntermountain CALLAIR A-9 · S/N 1276Cancelled Mar 10, 1997 · Triennial form not returned · Coryell Carson L DBAN4741JBeech A23-24 · S/N MA179Cancelled Nov 13, 1995 · Triennial form not returned · Havre Flying Club IncN1299APiper PA-18-125 · S/N 181103Cancelled Jan 25, 1991 · Exported to Canada · Hensley Flying Service IncN4432YPiper PA-25-235 · S/N 25-4061Cancelled May 31, 1983 · Exported to Canada · Built 1966 · Hensley Flying Service IncN5674JCessna A188A · S/N 1880624Cancelled Apr 19, 1983 · Exported to Canada · Hensley Flying Service IncN5990PPiper PA-24-250 · S/N 24-1084Cancelled Apr 10, 1981 · Exported to Canada · Hensley Flying Service IncN2904YCessna 182E · S/N 18253904Cancelled Aug 7, 1980 · Exported to Canada · Built 1962 · Smith Veryl LN8754NPiper PA-28-140 · S/N 2825574Cancelled Apr 3, 1979 · Built 1969 · Hensley Flying Service IncN7369ZPiper PA-25-235 · S/N 25-3324Cancelled Apr 14, 1977 · Exported to Canada · Hensley Flying Service IncN8259KStinson 108-1 · S/N 108-1259Cancelled Mar 23, 1977 · Exported to Canada · Built 1946 · Richardson Keith E Kuhn BillN4406YPiper PA-25-235 · S/N 25-4014Cancelled Feb 26, 1976 · Exported to Canada · Built 1966 · Hensley Flying Service IncN82854Cessna 172M · S/N 17261236Cancelled Jan 6, 1976 · Exported to Canada · Hensley Flying Service IncN4611EChampion 7CCM · S/N 7CCM-180Cancelled Apr 26, 1973 · Exported to Canada · Hensley Dennis GN1392HAeronca 15AC · S/N 15AC-443Cancelled Jul 28, 1971 · Exported to Canada · Ernst Ira RN77278Cessna 140 · S/N 11544Cancelled Jul 14, 1971 · Exported to Canada · Hensley Walter CN7285ACessna 172 · S/N 29385Cancelled Dec 28, 1968 · Exported to Canada · Hensley Walter CN34032Taylorcraft BC12-65 · S/N 2883Cancelled Jan 17, 1968 · R Gary FlemingN1846VCessna 140 · S/N 14018Cancelled Jun 29, 1966 · Exported to Canada · Built 1947 · Clark Robert CN7080YPiper PA-30 · S/N 3094Cancelled Jul 24, 1965 · Baltrush Construction CoN88620Piper J3C-65 · S/N 16248Cancelled May 21, 1965 · Lauren SargentN1553EAeronca 7DC-CONV · S/N 7AC-5118Cancelled May 18, 1965 · Walter C HensleyN44084Taylorcraft BC12-D · S/N 9884Cancelled Oct 26, 1964 · Exported to Canada · Walter C HensleyN6471MStinson 108-3 · S/N 108-4471Cancelled May 19, 1963 · Built 1948 · Ernst Ira RN76399Cessna 140 · S/N 10825Cancelled Dec 29, 1961 · Exported to Canada · Tilleman PaulN3417NPiper J3C-65 · S/N 22922Cancelled Apr 20, 1961 · Exported to Canada · Built 1947 · Hensley Walter CN4773HPiper PA-11 · S/N 11-701Cancelled Jan 23, 1961 · Walter C HensleyN9099ACessna 170A · S/N 18858Cancelled Jan 17, 1961 · Exported to Canada · Hensley Walter CN43728Taylorcraft BC12-D · S/N 7387Cancelled Nov 15, 1960 · Exported to Canada · Hensley Walter CN7466DPiper PA-18-150 · S/N 18-5795Cancelled May 6, 1960 · Exported to Canada · Hensley Walter CN6320PPiper PA-24-180 · S/N 24-1430Cancelled May 5, 1960 · Exported to Canada · Built 1959 · Hensley Flying ServiceN93525Ercoupe 415-C · S/N 848Cancelled Dec 10, 1959 · High Line Flying ClubN4730APiper PA-18A 150 · S/N 18-4955Cancelled Nov 20, 1959 · Exported to Canada · Hensley Walter CN3638NPiper J3C-65 · S/N 22896Cancelled Nov 19, 1959 · Exported to Canada · Knudson Glen RN4494APiper PA-18A · S/N 18-4865Cancelled Nov 19, 1959 · Exported to Canada · Hensley WalterN4528EAeronca 7DC · S/N 7DC-135Cancelled Sep 29, 1959 · Exported to Canada · Hensley Walter CN4576EAeronca 7CCM · S/N 7CCM-141Cancelled Oct 31, 1958 · Exported to Canada · Built 1949 · Hensley WalterN4107NCessna 120 · S/N 13565Cancelled Oct 29, 1958 · Exported to Canada · Hensley Walter CN3923HEngineering & Research 415-CD · S/N 4624Cancelled Aug 7, 1958 · Exported to Canada · Hensley Walter CN4908MPiper PA-11 · S/N 11-1647Cancelled Aug 13, 1957 · Exported to Canada · Price Harold WN4599APiper PA-18A 150 · S/N 18-4912Cancelled Aug 5, 1957 · Hensley Walter CN9564ACessna 170A · S/N 19125Cancelled Oct 11, 1956 · Exported to Canada · Franken N A
Back to Havre, MT