Bozeman, MT

Cancelled registrations · 127

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

N4400XRaven Industries S-66A · S/N S66A-147Cancelled Mar 15, 2001 · Triennial form not returned · Stelmak Thomas BN447RAS+ AC 4 · S/N 047Cancelled Aug 18, 2000 · Exported to Canada · Russia Sailplanes IncN693SBChristen Industries PITTS S-2B · S/N 5108Cancelled Sep 12, 1998 · Gier Jim CN158RAS+ AC 4 · S/N 027Cancelled Aug 22, 1998 · Russia Sailplanes IncN9169FHughes 369HS · S/N 140556SCancelled Dec 13, 1995 · Exported to Canada · Ars IncN5522CCessna T210N · S/N 21063778Cancelled Feb 1, 1995 · Exported to Mexico · Terrell Bill MN1011NSwearingen SA226TC · S/N TC382Cancelled Nov 18, 1994 · Exported to Canada · Mountain Pacific Airways IncN28EFPiper PA-28-140 · S/N 2824908Cancelled Mar 28, 1991 · Triennial form not returned · Johns Flying Service IncN1941ZCessna 150C · S/N 15059741Cancelled Mar 20, 1991 · Exported to Canada · Butts Melvin AN4996PPiper PA-18-150 · S/N 18-8581Cancelled May 20, 1981 · Exported to Canada · Built 1967 · Cadwell Philip CN16821Bell 206B · S/N 2232Cancelled Jan 17, 1979 · Exported to Canada · Central Helicopters IncN2611NCessna 140 · S/N 12871Cancelled Aug 6, 1976 · Built 1947 · Michels Kirk DN11682Bellanca 7KCAB · S/N 312-72Cancelled May 31, 1974 · Exported to Canada · Edsall Construction CoN2250VCessna 140 · S/N 14481Cancelled Jun 10, 1969 · Exported to Canada · Robert C SeifertN4400KRyan NAVION · S/N NAV-4-1400Cancelled Oct 25, 1965 · Heiser Harold EN4644HPiper PA-17 · S/N 17-56Cancelled May 20, 1965 · Exported to Canada · Dolan DonN9791BCessna 180A · S/N 50089Cancelled Jul 7, 1964 · Exported to Canada · Stapleton Arthur MN7218BBeech J35 · S/N D-5536Cancelled Jan 2, 1959 · Community Television Systems Of Colorado IncN4169CStinson 108-3 · S/N 108-5169Cancelled Sep 2, 1958 · Exported to Canada · Atkinson Dale EN2530NCessna 120 · S/N 12786Cancelled Dec 12, 1955 · Student Flying Co-OpN76666Cessna 120 · S/N 11106Cancelled Dec 12, 1955 · Montana State CollegeN1734KLuscombe 8E · S/N 4461Cancelled Jun 30, 1955 · Exported to Canada · Student Flying Co OpN97146Stinson 108 · S/N 108-146Cancelled Aug 18, 1953 · Built 1946 · Corkins J.P.N1387BLuscombe 8F · S/N 6014Cancelled Jan 22, 1952 · Bozeman Aviation ServiceN95032Taylorcraft BC12-D · S/N 9432Cancelled Nov 13, 1950 · Miller Ernest And/Or Miller Charles NN2391BTemco GC-1B · S/N 3691Cancelled Aug 5, 1949 · Bozeman Aviation ServiceN49455Fairchild PT-23-HO · S/N 307H0Cancelled Feb 3, 1949 · Bozeman Aero Club
Back to Bozeman, MT