Cheyenne, WY

Cancelled registrations · 299

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

N86491Lockheed B-34 · S/N 15-1496Cancelled Jun 10, 1975 · Master Equipment CompanyN7263CLockheed PV-2 · S/N 37281Cancelled Sep 18, 1974 · Master Equipment CoN5434QCessna 150L · S/N 15073334Cancelled Jul 18, 1974 · Exported to Canada · Davis James E DBA Cheyenne AirwaysN1971NCessna 140 · S/N 12207Cancelled Jun 25, 1973 · Wing Jerold DN60091Cessna 150J · S/N 15070064Cancelled Jan 14, 1972 · Exported to Canada · Dody Kim RN4510KNavion NAVION A · S/N NAV-4-1510Cancelled Dec 28, 1971 · Tankersley James EN64106Fairchild M-62C(PT-23A) · S/N 4553AECancelled Jan 6, 1971 · Dixon Warren EN123BBell 47B3 · S/N 43Cancelled Nov 23, 1970 · Pioneer Village IncN7254CLockheed PV-2 · S/N 15-1185Cancelled Nov 20, 1970 · Master Equipment CoN4660CCessna 170B · S/N 25604Cancelled Jun 17, 1970 · George B HydeN4973FCessna TU206B · S/N U206-0673Cancelled Jun 8, 1970 · Built 1966 · State Of WyomingN7827BBeech T-34A · S/N 527635Cancelled May 21, 1969 · Exported to Canada · Civil Air Patrolwyoming WingN77047Cessna 140 · S/N 11501Cancelled Jan 20, 1969 · Sky Harbor Air ServiceN87143Engineering & Research 415-D · S/N 316Cancelled Nov 15, 1968 · Exported to Canada · Klipstein Motor Sales IncN6623CBeech A45 (T-34A) · S/N G775Cancelled Jun 23, 1965 · United States Air ForceN2197ZCessna 180 · S/N 18051297Cancelled May 21, 1965 · Built 1963 · Sky Harbor Air ServiceN89315Cessna 140 · S/N 8343Cancelled Jan 5, 1959 · Sky Harbor Air ServiceN8068CPiper PA-18-135 · S/N 18-3459Cancelled Jul 11, 1958 · Exported to Canada · Jim Morton CoN7259CLockheed PV-2 · S/N 37246Cancelled Jan 20, 1958 · Exported to Mexico · Master Equipment CoN4611VDouglas B-18 · S/N 5773Cancelled Apr 16, 1957 · Exported to Mexico · Master Equipment CoN78646Piper PA-11 · S/N 11-1407Cancelled Mar 16, 1956 · Built 1947 · Sky Harbor AirportN47947Aeronca 65-CA · S/N CA15261Cancelled Nov 18, 1955 · Jones Kenneth RayN73408Waco UPF-7 · S/N 5579Cancelled Sep 7, 1955 · Wyoming Skyways IncN5900VDouglas DC3C · S/N 20244Cancelled Mar 4, 1955 · Exported to Brazil · Master Equipment CoN1303APiper PA-18 · S/N 18-1107Cancelled Nov 4, 1954 · Exploration Associates IncN4007CStinson 108-3 · S/N 108-5007Cancelled Oct 7, 1953 · Forwood DonN73422Douglas DC3A · S/N 4850Cancelled Feb 27, 1953 · Exported to Colombia · Master Equipment CompanyN73421Douglas DC-3A-S1C3G · S/N 4824Cancelled Oct 9, 1952 · Exported to Colombia · Master Equipment CoN7762HPiper PA-12 · S/N 12-659Cancelled Sep 8, 1952 · Gillam Dale L And Spencer Willard HN5077HPiper PA-11 · S/N 11-976Cancelled Jun 2, 1952 · Sky Harbor AirportN73419Piper J3C-65 · S/N 9373Cancelled Jan 24, 1952 · Wyoming Wing Civil Air PatrolN4211HPiper PA-14 · S/N 14-14Cancelled Jan 2, 1952 · Sky Harbor Air ServiceN53083Boeing D75N1 · S/N 75-3979Cancelled Dec 20, 1951 · Built 1945 · Sky Harbor AirportN4695NConsolidated Vultee BT-13 · S/N 10724Cancelled Sep 19, 1950 · Nelson Adolph JN5072HPiper PA-11 · S/N 11-971Cancelled Aug 15, 1949 · Sky Harbor AirportN4268HPiper PA-14 · S/N 14-72Cancelled Jun 14, 1949 · Hayes Walter MonroeN41217Piper J4E · S/N 4-1635Cancelled Nov 9, 1948 · State Department Of Education Wyoming Aircraft ScN237YLawrence Short LS-1 · S/N LS-1Cancelled Mar 26, 1948 · Built 1939 · Plains Airways IncN4742MPiper PA-11 · S/N 11-256Cancelled Mar 5, 1948 · Sky Harbor AirportN842MBoeing 40-B-4 · S/N 1168Cancelled Feb 18, 1948 · Built 1929 · Boeing Air Transport IncN356VVerville 104 · S/N 5Cancelled Mar 8, 1937 · Lockhart IsabellaN467WTravel Air Mfg 2000 · S/N 1410Cancelled Aug 24, 1933 · Bradshaw John PN227MBoeing 80-A1 · S/N 1085Cancelled Jul 12, 1933 · Boeing Air Transport IncN5231Travel Air 2000 · S/N 471Cancelled Nov 23, 1932 · Steinbacher Edward AN273Boeing 40B · S/N 884Cancelled Feb 25, 1932 · Boeing Air Transport IncN291Boeing 40B · S/N 902Cancelled Feb 9, 1932 · Boeing Air Transport IncN286Boeing 40B · S/N 897Cancelled Dec 11, 1931 · Boeing Air Transport IncN3072Waco 9 · S/N 345Cancelled Nov 21, 1929 · Built 1925 · Steinbacher Edward AN2634Lincoln Standard STANDARD J1 · S/N 70Cancelled Apr 20, 1927 · Garrett Robert V
Back to Cheyenne, WY