OpenAirDocs.org
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.

N2266RLystlund William L LYSTLUND KR-1 · S/N 334409677Cancelled Jan 23, 1997 · Lystlund William LN5938KRockwell International 690C · S/N 11686Cancelled Oct 1, 1996 · Triennial form not returned · Casper Flying ServiceN4456TCartier Kerry L DBL AIRPLANE · S/N 1Cancelled Jun 19, 1996 · Second triennial mailing, no response · Cartier Kerry LN9618BCessna 172RG · S/N 172RG0923Cancelled Feb 3, 1995 · Exported to India · Casper Air ServiceN96JPMitsubishi MU-2B-35 · S/N 556Cancelled Jul 13, 1994 · Triennial form not returned · Casper Air ServiceN51866Cessna 172P · S/N 17274363Cancelled Dec 29, 1993 · Exported to Indonesia · Casper Air ServiceN62288Cessna 172P · S/N 17275248Cancelled Dec 29, 1993 · Exported to Indonesia · Casper Air ServiceN21434Piper PA-32RT-300T · S/N 32R7887209Cancelled Jul 12, 1993 · Triennial form not returned · Savage Larry MN81TRRockwell International 690C · S/N 11690Cancelled Feb 9, 1993 · Triennial form not returned · Casper Air ServiceN51054Cessna 172P · S/N 17274260Cancelled Jul 6, 1992 · Exported to Netherlands · Casper Air ServiceN53000Cessna 172P · S/N 17274656Cancelled May 15, 1992 · Exported to Ireland · Casper Air ServiceN5446KCessna 172P · S/N 17274113Cancelled May 15, 1992 · Exported to Ireland · Casper Air ServiceN756WHCessna TR182 · S/N R18201178Cancelled Jul 25, 1991 · Pc Transport IncN53943Cessna 172P · S/N 17274830Cancelled Jul 17, 1991 · Exported to Japan · Casper Air ServiceN54464Cessna 172P · S/N 17274980Cancelled Jul 17, 1991 · Exported to Japan · Casper Air ServiceN52845Cessna 172P · S/N 17274620Cancelled Feb 19, 1991 · Exported to Japan · Casper Air ServiceN6718DBeech 76 · S/N ME332Cancelled Jan 23, 1991 · Exported to Portugal · Casper Air ServiceN558BQMooney M20C · S/N 2980Cancelled Aug 23, 1985 · Rocky Mountain Leasing CoN8422UPiper PA-28-181 · S/N 28-8190297Cancelled May 26, 1984 · Administratively canceled · Huckeby Donald PN5356PPiper PA-24-250 · S/N 24404Cancelled Mar 30, 1984 · Beans Robert BN1381GCessna 340A · S/N 340A0080Cancelled Nov 23, 1983 · Administratively canceled · Casper Air Service IncN2168DPiper PA-32RT-300T · S/N 32R-7987054Cancelled Jul 28, 1982 · Built 1978 · Wyoming Central Aero Ways IncN6405Woynowski LITTLE BIRD · S/N 001Cancelled May 8, 1981 · Woodward John HN7309XCessna R182 · S/N R18200070Cancelled May 29, 1980 · Exported to United Kingdom · Casper Air Svc IncN202PSDehavilland BEAVER U-6A · S/N 53-7911Cancelled Jan 9, 1980 · Exported to Canada · Built 1953 · Natrona County Disaster & Civil Def AgcyN4948FPiper PA-34-200T · S/N 34-7770003Cancelled Jul 19, 1977 · Built 1976 · S S & H CompanyN4237KRyan NAVION · S/N NAV-4-1237Cancelled May 22, 1975 · Dick Reed IncN2803HEngineering & Research ERCOUPE 415-C · S/N 3428Cancelled Dec 24, 1974 · Breuillette Lawrence J WN20371Cessna 172M · S/N 17261232Cancelled Dec 9, 1974 · Exported to Canada · Casper Air Service IncN91855Cessna 182M · S/N 18259935Cancelled Oct 23, 1974 · Exported to Canada · Caspar Air Service IncN1985DBeech C35 · S/N D-3210Cancelled Jul 18, 1974 · Hickman W B JrN9596CGrumman TBM-3E · S/N 69361Cancelled Feb 20, 1974 · Exported to Canada · Firetankers IncN17930Grumman TBM-3E · S/N 69531Cancelled Jan 11, 1974 · Exported to Canada · Firetankers IncN9545TCessna 210 · S/N 57345Cancelled Jun 25, 1973 · Kirkpatrick Robert FN7395ZPiper PA-25-235 · S/N 25-3356Cancelled Jun 4, 1973 · Seeley Flying Service IncN7671GCessna 172L · S/N 17259371Cancelled Jan 11, 1973 · Exported to Canada · Casper Air Service IncN8654YPiper PA-30 · S/N 30-1796Cancelled Aug 14, 1972 · Sing Well Servicing Co IncN1668APiper PA-22 · S/N 22-433Cancelled May 8, 1972 · Norman D WeisN3864DCessna 182A · S/N 34564Cancelled Feb 28, 1972 · Wehrli RobertN9559CGrumman TBM-3E · S/N 6728Cancelled Aug 24, 1971 · Air Tankers IncN7196TCessna 172A · S/N 46796Cancelled Sep 24, 1970 · Castfel NathelN68590Aeronca 7BCM · S/N 7BCM-229Cancelled Jun 24, 1970 · Wyoming Wing Civil Air Patrol IncN29170Cessna TU206C · S/N U206-1137Cancelled Jun 18, 1970 · Automation And ElectronicsN384CBeech S35 · S/N D-7525Cancelled Oct 19, 1965 · Casper Air ServiceN5831ACessna 172 · S/N 17228431Cancelled Apr 15, 1965 · Western FlyersN9337BCessna 175 · S/N 55137Cancelled Sep 17, 1959 · Church Carrol LN64251Cessna T-50 · S/N 6289Cancelled Jul 6, 1959 · Harris Henry WN2582PPiper PA-18 · S/N 18-4324Cancelled May 1, 1958 · Casper Air ServiceN15471Cessna 310 · S/N 310Cancelled Oct 19, 1955 · Built 1936 · Davis Evan EN4368NCessna 195 · S/N 7038Cancelled Oct 6, 1955 · Built 1947 · Natrona Aircraft Service
Back to Casper, WY