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.
N6ZYFisher Jeremy F LANCAIR 360 · S/N 001N3856HEngineering & Research ERCOUPE 415-CD · S/N 4557N249SWRemos GEMINI REMOS G-3/600 · S/N 204N46812Cessna 152 · S/N 15283110N2364ZPiper PA-23-250 · S/N 27-8054025N7185YPiper PA-30 · S/N 30-209N607CDAerospatiale SA315B · S/N 2601N2192HEngineering & Research ERCOUPE 415-C · S/N 2815N22687Funk B85C · S/N 14N898Schleicher ASW-17 · S/N 17049N44876Piper PA-28-161 · S/N 28-7816034N9251CPiper PA-28-161 · S/N 28-7816453N81602Piper PA-34-220T · S/N 34-8233107N8099RAerospatiale SA316B ALOUETTE III · S/N 1761N1154LMooney M20K · S/N 25-0635N5170BAerospatiale SA316B ALOUETTE III · S/N 2206N605RAAerospatiale SA316B ALOUETTE III · S/N 1165N316TAAerospatiale SA316B ALOUETTE III · S/N 1515N327TASud SA316B ALOUETTE III · S/N 1227N67499Cessna 152 · S/N 15281869N507SLMil MI-8 · S/N 93507N6505Antonov AN-32B · S/N 3202N7703NPiper PA-28-180 · S/N 28-5150N2291SCessna T210L · S/N 21061234N6479ZAerostar International RX-7 · S/N RX7-3095N105FEBoeing 727-22C · S/N 19194N120FEBoeing 727-25C · S/N 19356N507DABoeing 727-232 · S/N 21309N501DABoeing 727-232 · S/N 21303N12231Boeing 737-217 · S/N 19885N10251Boeing 737-291 · S/N 20361N14245Boeing 737-2CO · S/N 20074N16201Boeing 737-130 · S/N 19018N14211Boeing 737-130 · S/N 19028N2883DPiper PA-34-200T · S/N 347970323N2711YBeech 95 · S/N TD36N7943XCessna 172B · S/N 17248443N8372ZPiper PA-34-220T · S/N 348133071N3617XAero Commander 100-180 · S/N 5093N82SLStueckle Lyons QUICKIE Q-2 · S/N 2207N27270Hunt Eldon W FOUR HUNDRED · S/N 101N9728JPiper PA-28-180 · S/N 283921N4880ACessna T310R · S/N 310R1394N9777MMooney M20F · S/N 680194N1980QCessna 177RG · S/N 177RG0380N4959ACessna 180 · S/N 32356N3089UCessna 172E · S/N 17250689N756LFCessna TU206G · S/N U20604170N3440QCessna 320E · S/N 320E0040N1746DCessna 170A · S/N 20189
Back to Cheyenne, WY