Casper, WY

Cancelled registrations · 218

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 = 'WY' AND d.registrant_city = 'CASPER'
  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.

N5851CBeech C35 · S/N D-2803Cancelled Apr 8, 1955 · Casper Air ServiceN73762Consolidated Vultee BT-13A · S/N 6901Cancelled Sep 23, 1954 · John B ShawN9042ACessna 170A · S/N 18797Cancelled Nov 21, 1951 · Woodward R HN3584VCessna 120 · S/N 14853Cancelled Jan 26, 1951 · James E Jones JrN74633Aeronca 7AC · S/N 7AC-3340Cancelled Mar 20, 1950 · Lord KayeN18544Commonwealth REARWIN 9000-L · S/N 553Cancelled Oct 6, 1949 · Built 1937 · Griffith Maurice FN71430Luscombe 8A · S/N 2857Cancelled May 2, 1949 · Reina AlN2598EAeronca 7AC · S/N 7AC-6180Cancelled Nov 18, 1947 · Elmore And Miller Aviation EnterprisesN17060Beech C17B · S/N C17B-111Cancelled May 12, 1944 · Built 1936 · Inland Air Lines IncN11007Star CAVALIER E · S/N 133Cancelled May 7, 1943 · Richard O ShermanN10225Boeing MONOMAIL 221-A · S/N 1154Cancelled May 14, 1937 · Built 1930 · Wyoming Air Service IncN13749Lockheed ORION 9D · S/N 207Cancelled Oct 24, 1936 · Built 1933 · Wyoming Air Service IncN725WBoeing MONOMAIL 221-A · S/N 1153Cancelled Jul 15, 1935 · Wyoming Air Service IncN846KGreat Lakes 2T-1A · S/N 110Cancelled Dec 5, 1930 · Built 1930 · Wyoming Air ServiceN1900Alexander COMBINATION EAGLEROC · S/N 301Cancelled Oct 30, 1928 · Built 1927 · Wyoming Airways IncN17655Spartan 7W · S/N 24Cancellation date not recorded · Built 1939 · Meece C StewartN2883Alexander LONG WING EAGLEROCK · S/N 160Cancellation date not recorded · Wyoming Airways CorpN64255Cessna UC-78B · S/N 5646Cancellation date not recorded · Thompson Ernest E
Back to Casper, WY