Helena, MT
Cancelled registrations · 154
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 = 'MT' AND d.registrant_city = 'HELENA' 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 = 'MT' AND d.registrant_city = 'HELENA' 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.
N564XLLiberty Aerospace LIBERTY XL-2 · S/N 0050N9166YNorth American T-39A · S/N 61-0677N652CTEmbraer EMB-120ER · S/N 120.199N899THBoeing 747-200 · S/N 20929N898THBoeing 747-300 SERIES · S/N 23639N50928WSK PZL Mielec M-18A · S/N 1Z023-06N388MBell UH-1B · S/N 62-4568N11900Clarke Allan J DRAGON FLY · S/N 11796N152XGulfstream AM Corp Comm Div 690C · S/N 11692N855JFCessna 210L · S/N 21059862N94142Ercoupe 415-C · S/N 1465N8091JPiper AEROSTAR 601P · S/N 61P05777963252N87338Cessna 310R · S/N 310R0518N1103KHughes 269C · S/N 700945N7925GCessna 172L · S/N 17259625N664GMaule M-6-235 · S/N 7502CN2ALStarke RAND KR-2 · S/N 1023N92GWWeiland Garold QB148-M · S/N 0092N100WXPiper PA-28-236 · S/N 287911062N9410BCessna 175 · S/N 55210N30355Piper PA-28-161 · S/N 28-7816541N93471Bell H-13E · S/N 51-13995N93476Bell H-13E · S/N 51-14198N93470Bell H-13E · S/N 51-13890N24873Bell H-13E · S/N 13773N22195Cessna 210L · S/N 21059715N9047North American F-86 · S/N 53-1396N13106Cessna 172M · S/N 17262500N20569Cessna 172M · S/N 17261402N8383ZCessna 210-5(205) · S/N 205-0383N9995XCessna 185 · S/N 1850195N6447XCessna 180D · S/N 18050947N89878Cessna 140 · S/N 8923N8226ACessna 170B · S/N 25078N3565MPiper PA-12 · S/N 12-2413N2329EAeronca 7AC · S/N 7AC-5906N2494EAeronca 7AC · S/N 7AC-6076N48839Fairchild PT-19A · S/N T41-789N48926Taylorcraft DCO-65 · S/N L-5429N50178Fairchild M-62A · S/N T42-3524N85737Aeronca 7AC · S/N 7AC-4484N2055EAeronca 7AC · S/N 7AC-5625N69545Cessna T-50 · S/N 1214N85736Aeronca 7AC · S/N 7AC-4483N85734Aeronca 7AC · S/N 7AC-4481N70904Piper J3C-65 · S/N 17921N9481KStinson 108-2 · S/N 108-2481N33822Aeronca 65-CA · S/N CA13681N10667Lay Brothers LT-1 · S/N 106N330NFokker SUPER UNIVERSAL · S/N 867
Back to Helena, MT