OpenAirDocs.org
Provo, UT

Cancelled registrations · 130

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 = 'UT' AND d.registrant_city = 'PROVO'
  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.

N7569JPiper PA-28R-180 · S/N 28R-30949Cancelled Feb 28, 1972 · Interwest CorpN7209ECessna 182B · S/N 182-52209Cancelled Feb 3, 1971 · Davis Chester LN3438Duste ZINA III · S/N DZ 302Cancelled Jan 18, 1971 · Duste LeonN8654SCessna 150F · S/N 15061954Cancelled Apr 9, 1969 · Exported to Canada · Built 1966 · Central Utah Aviation IncN8461EBell 47G-3 · S/N 2640Cancelled Mar 8, 1967 · Exported to Canada · Built 1961 · Mountain West Helicopters IncN3974VCessna 170 · S/N 18293Cancelled Aug 11, 1965 · Earl Lewis FarleyN4804BCessna 310 · S/N 35104Cancelled May 21, 1965 · John Hoover CoN53323Convair BT-13A · S/N 9106Cancelled Jul 24, 1963 · Hippach HarveyN3715VCessna 140 · S/N 14992Cancelled Nov 17, 1960 · Exported to Canada · Provo Flying Service IncN605BBeech A35 · S/N D-1626Cancelled Sep 26, 1960 · Provo Flying Service IncN1672KLuscombe 8E · S/N 4399Cancelled Mar 15, 1955 · Walker C FN99491Ercoupe 415-C · S/N 2114Cancelled Sep 28, 1954 · Built 1946 · Provo Flying Service IncN1898KLuscombe 8E · S/N 4625Cancelled Dec 4, 1952 · Centralutah Avation IncN89300Cessna 140 · S/N 8326Cancelled May 23, 1952 · Provo Squadron Pilots ClubN617YWaco RNF · S/N 3321Cancelled Feb 22, 1951 · Waco Central Utah Flying ClubN2285KLuscombe 8E · S/N 5012Cancelled Feb 13, 1951 · Central Utah AviationN93466Ercoupe 415-C · S/N 789Cancelled Feb 13, 1951 · Built 1946 · Provo Flying Service IncN99801Ercoupe 415-C · S/N 2424Cancelled Feb 13, 1951 · Christensen J W JrN14586Stinson SR-5A · S/N 9323ACancelled Dec 1, 1949 · Built 1935 · Central Utah Vocational SchoolN3077HErcoupe 415-C · S/N 3702Cancelled May 16, 1949 · Christopherson MerrillN82575Aeronca 7AC · S/N 7AC-1212Cancelled Mar 17, 1949 · Central Utah AviationN48523Cessna T-50 · S/N 5872Cancelled Nov 12, 1948 · Exported to Mexico · Christopherson MerrillN48508Fairchild M-62A · S/N T43-5735Cancelled Oct 29, 1948 · Christopherson MerrillN48836Taylorcraft DCO-65 · S/N 5350Cancelled Oct 29, 1948 · Christopherson MerrillN37799Porterfield FP-65 · S/N 996Cancelled Sep 20, 1948 · Built 1941 · Eck Samuel KN36026Taylorcraft BC12-65 · S/N 2991Cancelled Sep 5, 1948 · Built 1941 · Christopherson MerrillN34848Porterfield LP-65 · S/N 927Cancelled Aug 23, 1948 · Christopherson MerrillN28338Max Peterson/Bobbie Sward JR UTILITY GLIDER · S/N PA-13Cancelled Jul 28, 1948 · Peterson Max A & Sward Bobbie JrN11711Curtiss Wright TRAVEL AIR 12-W · S/N 12Q-2036Cancelled Apr 7, 1948 · Christopherson MerrillN720EWaco ASO · S/N A-94Cancelled Jan 22, 1939 · Carbell Charles Thomas
Back to Provo, UT