OpenAirDocs.org
Greybull, WY

Cancelled registrations · 34

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

N6252XAero Commander 500-B · S/N 500A-1114-56Cancelled Dec 11, 2023 · Sale reported, canceled · Built 1961N4103ZRaven Industries RALLY RX7 · S/N RX7-274Cancelled Nov 11, 2023 · Sale reported, canceledN14169Hawkins 1928 MONOCOUPE 70 · S/N 108-HCancelled Jan 30, 2019 · Registration expired, pending cancellation · Built 1928 · Hawkins Jean L TrusteeN173AMLockheed P2V-7 · S/N 143173Cancelled May 30, 2018 · Sale reported, canceledN8532ABeech A35 · S/N D-1954Cancelled Apr 20, 2018 · Registration expired, pending cancellation · Built 1948 · Blank Leland SN5013PHughes Helicopters HUGHES 369D · S/N 610984DCancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1981 · Hawkins & Powers Aviation IncN78609Piper PA-11 · S/N 11-1369Cancelled Jun 20, 2017 · Registration expired, pending cancellation · Built 1947 · Noyes Charles QN232HPHiller UH-12D · S/N 1155Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1959 · D&G IncN97KCBoeing KC-97G · S/N 53-218Cancelled Sep 30, 2013 · Registration expired, pending cancellation · D&G IncN183ZCessna A185F · S/N 18502671Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1975 · Alan Randolph WN47036Werbelow Brothers SCORPION TOO · S/N 1975Cancelled Dec 11, 2012 · Registration expired, pending cancellation · Built 1975 · Werbelow BrothersN2843JKaman H-43A · S/N 58-1823Cancelled Sep 24, 2012 · Registration expired, pending cancellation · Built 1959 · Hawkins And Powers Aviation IncN58247Hughes Helicopters HUGHES 369D · S/N 1080386DCancelled Jul 30, 2010 · Triennial form undeliverable · Built 1978 · Hawkins & Powers Aviation IncN2339APiper PA-22-135 · S/N 22-713Cancelled Jul 14, 2009 · Registration revoked · Built 1952 · Yates Robert BN7391CBeech C18S · S/N 44-87201ACancelled Jun 16, 2009 · Second triennial form not returned · Built 1957 · Hawkins And Powers Aviation IncN7394DPiper PA-18-150 · S/N 18-5761Cancelled Jun 16, 2009 · Second triennial form not returned · Built 1957 · Hawkins & Powers Aviation IncN6937UMooney M20E · S/N 307Cancelled Dec 12, 2008 · Triennial form undeliverable · Built 1964 · Hawkins And Powers Aviation IncN2751UBell 206B · S/N 2689Cancelled Nov 9, 2004 · Triennial form not returned · Built 1979 · Hawkins & Powers Aviation IncN7620CConsolidated Vultee P4Y-2 · S/N 66260Cancelled Dec 30, 2002 · Triennial form not returned · Built 1945 · Hawkins And Powers Aviation IncN130HPLockheed C-130A · S/N 56-538Cancelled Dec 16, 2002 · Triennial form not returned · Hawkins And Powers Aviation IncN70600Lockheed SP-2H · S/N 148342Cancelled Jun 5, 1992 · Triennial form not returned · Hawkins And Powers Aviation IncN8832Fairchild C-119G · S/N 10907Cancelled Apr 8, 1991 · Triennial form not returned · Hawkins & Powers Aviation IncN8682Fairchild C-119G · S/N 10859Cancelled Apr 5, 1991 · Triennial form not returned · Hawkins & Powers AviationN505RLockheed 18-08 · S/N 2358Cancelled Apr 26, 1984 · Hawkins & Powers Aviation IncN52056Douglas B-18 · S/N 1890Cancelled Apr 26, 1984 · Hawkins & Powers Aviation IncN9727CHiller UH-12L4 · S/N 2506Cancelled Aug 7, 1975 · Hawkins & Powers Aviation IncN27392Aeronca 65-TC · S/N 2050TCancelled Sep 21, 1970 · Wheeler Richard F & Orville E StockwellN22564Stinson HW75 · S/N 7125Cancelled Jun 3, 1960 · Big Horn Flying ServiceN69023Cessna T-50 · S/N 3138Cancelled Dec 22, 1959 · Stockwell Orville EN69024Cessna T-50 · S/N 3143Cancelled Dec 22, 1959 · Stockwell Orville EN69025Cessna T-50 · S/N 3134Cancelled Dec 22, 1959 · Stockwell Orville EN69026Cessna T-50 · S/N 3118Cancelled Dec 22, 1959 · Stockwell Orville EN3873MPiper PA-12 · S/N 12-2783Cancelled Feb 14, 1956 · Big Horn Flying ServiceN1781APiper PA-18A · S/N 18-1327Cancelled Jan 31, 1956 · Exported to Peru · Big Horn Flying Services
Back to Greybull, WY