Elko, NV
Cancelled registrations · 56
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 = 'NV' AND d.registrant_city = 'ELKO' 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 = 'NV' AND d.registrant_city = 'ELKO' 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.
N3344Raytheon 1900D · S/N UE354N2828MCreek Michel W BEARHAWK · S/N 056-107/108-854N167TMAlexander Schleicher ASW 27-18 · S/N 29086N6358GCessna 150K · S/N 15071858N8052GBell 206B · S/N 4050N20620Bell 206B · S/N 3369N32385Commonwealth REARWIN 175 · S/N 1534N2817PPiper PA-22-150 · S/N 22-3110N12056Stits Playboy SA3A · S/N P-677N4892JRoberts Jack D RV-3AR · S/N 592N21TVHall Jack Hellinger SNS-7 · S/N 296N3234URobinson Helicopter R44 II · S/N 11654N31192Seyferth AEROSPORT SCAMP · S/N WT-S3/21N26842Piper J3C-65 · S/N 4229N3006GForney F-1 · S/N 5698N441DJJohnson David A GLASTAR · S/N 0055299N313DFCessna 182 · S/N 18257182N28GBBallard Glen SA-6B FLUTTERBUG · S/N P2162N51698Bell 206B · S/N 4010N3185ABell 206L-3 · S/N 51093N9690GCessna U206F · S/N U20601890N1837KBeech B-60 · S/N P-579N240JCWilson Alan TANDUM AIR BIKE · S/N AW002N344TMBoeing 737-200 · S/N 23044N789TMBoeing 737-282 · S/N 23046N233TMBoeing 737-282 · S/N 23043N7207MHying/Minton ROTORWAY EXEC · S/N 3575N571AMMueller Arthur V SKYRAIDER 1 · S/N 111N456TMBoeing 737-2H4 · S/N 20336N54006Cessna 172P · S/N 17274839N27736Bell 206B · S/N 2773N3050Beech 95-B55 (T42A) · S/N TC546N4379WSeyferth Roger C ZENAIR STOL CH-701 · S/N 71394N3913KPiper PA-28-140 · S/N 2823781N1828XCessna 182H · S/N 18255928N1442FCessna 172H · S/N 17254937N6576PPiper PA-24-180 · S/N 24-1698N99351Ercoupe 415-C · S/N 1974N1684KLuscombe 8E · S/N 4411N3333DCessna 180C · S/N 50712N1209Beech D18S · S/N A-225N8067CPiper PA-18-135 · S/N 18-3418N90TBoeing A75N1(PT17) · S/N 75-444N3149ZPiper PA-22-150 · S/N 22-7099N2287VCessna 140 · S/N 14517N5344CCessna 140A · S/N 15567N7426CNorth American AT-6C(SNJ-4) · S/N 88-13036N2427PPiper PA-22-150 · S/N 22-2798N4816VPiper J3C-65 · S/N 13253N9938ACessna 170 · S/N 19298
Back to Elko, NV