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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N530GAGulfstream American G-1159 · S/N 247N3044XThrush S2R-H80 · S/N H80-128DCN821SBCessna T210J · S/N T210-0414N9379SAgusta Aerospace AW119 MKII · S/N 14756N9379KAgusta Aerospace AW119 MKII · S/N 14760N770SFBeech 200 · S/N BB-916N120TXEurocopter EC120B · S/N 1029N345BSCirrus Design SR20 · S/N 2059N18ZLGulfstream Aerospace G-1159A · S/N 434N95AZCessna 650 · S/N 650-0017N61122Cessna U206F · S/N U20602064N3GJCessna T210G · S/N T210-0199N455BKHawker Siddeley HS.125 SERIES 700A · S/N NA 0256N250LMPiper PA-23-250 · S/N 27-2464N25TGCessna 650 · S/N 650-0013N49882Bell 47G-3 · S/N 2612N16PPPoberezny Paul H POBER JR ACE · S/N 1N51FKCessna 550 · S/N 550-0012N6025NCessna T210M · S/N 21062893N1233GCessna 402C · S/N 402C0801N4850CCessna T210N · S/N 21063645N303NNCessna T303 · S/N T30300268N206YHCessna U206G · S/N U20606074N4611QCessna T210L · S/N 21059511N36132Piper PA-34-200T · S/N 34-7870296N7782HRobinson Helicopter R22 BETA · S/N 3962N5903MCessna T-310P · S/N 310P0203N702RMButler Max D ZENITH CH701 · S/N 7-3698N994RACessna 210M · S/N 21062649N500KDBeech B100 · S/N BE-79N706AMHawker Siddeley HS.125 SERIES 700A · S/N NA0206N15HEGulfstream American G-1159A · S/N 369N69489Cessna 340 · S/N 340-0330N998BACessna T210M · S/N 21061710N732XQCessna 210M · S/N 21061860N812DPBeech 200 · S/N BB-69N54TSBeech 200 · S/N BB515N711RADassault-Breguet FALCON 50 · S/N 80N310ZZCessna 310P · S/N 310P-0229N29216Cessna T210L · S/N 21059835N35531Piper PA-31-350 · S/N 31-8052046N380ACGulfstream American G-1159 · S/N 241N5769CCessna 170B · S/N 19723N2508UPiper PA-34-200T · S/N 34-7970451N800TDGulfstream American G-1159A · S/N 452N5997FCessna 210H · S/N 21058997N804DFRobinson Helicopter R44 II · S/N 11265N904JRBritish Aerospace BAE 125 SERIES 800A · S/N 258018N465BCRockwell International NA-265-65 · S/N 465-53N619PKAviat A-1B · S/N 2206
Back to Cheyenne, WY