Bozeman, MT
Cancelled registrations · 125
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 = 'BOZEMAN' 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 = 'BOZEMAN' 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.
N781VJCirrus Design SF50 · S/N 0781N322GKBeech F90 · S/N LA-64N609RCRaytheon HAWKER 800XP · S/N 258720N634BRCirrus Design SR22T · S/N 11634N599TALearjet 45 · S/N 212N389PRPilatus PC-12/47G · S/N 3089N800EMRaytheon HAWKER 800XP · S/N 258649N454HPTextron 525 · S/N 525-1021N4725APiper PA-18A 150 · S/N 18-4946N45VALearjet 45 · S/N 301N581BBeech C90A · S/N LJ-1170N459JCirrus Design SR22 · S/N 2517N80GMCessna 550 · S/N 550-0147N713GHPiper PA46-500TP · S/N 4697626N5316BCessna 182 · S/N 33316N2519XPiper PA-31T1 · S/N 31T-8104035N91FXBombardier BD-700-1A10 · S/N 9054N1152Kaman Aerospace K-1200 · S/N A94-0027N4147Kaman Aerospace K-1200 · S/N A94-0038N59718Autel Robotics EVO II PRO · S/N HV59-2021-1528N1162Kaman Aerospace K-1200 · S/N A94-0005N92892Bensen B-8M · S/N LAB1N15VMooney M20E · S/N 826N62PCCessna P337H · S/N P337-0345N210FKCessna P210N · S/N P21000441N579MTDJI INSPIRE 1 · S/N W130CA2302020994N768PPearson STARDUSTER SA300 · S/N 191N94472Slattery Gordon C V6 STOL · S/N GS3N67587Schweizer TG3A · S/N 56N4238ZPiper PA-18-150 · S/N 188465N91352Cessna A185F · S/N 18502519N1444KLuscombe 8A · S/N 4171N406ARDJI INSPIRE 1 · S/N W13DCB16020454N6333YMitchell Derryle V RANS S-7 COURIER · S/N 0596188N137CAviat A-1A · S/N 1453N175EPFreefly Systems ALTA · S/N 974016N602YGDJI INSPIRE 1 · S/N W13DCD25030516N604JSDJI PHANTOM 3 PROFESSION · S/N P78DCE23031663N615EPNicholas H Wolcott MID-ATLANTIC X8 · S/N TRM 1610N616EPNicholas H Wolcott MID-ATLANTIC X8 · S/N TRM 1611N5818JCessna 185 · S/N 18501787N9068CCessna R182 · S/N R18200384N730TCThunder & Colt Airborne Amer AX8-105S1 · S/N 2513USAN711VBGier Jim STOLP STARDUSTER II · S/N 1N25WHRobinson Helicopter R44 II · S/N 10481N14GGRobinson Helicopter R22 · S/N 4583N2466Taylor James AIR COMMAND · S/N 1N359JMMateskon John FISHER DAKOTA HAWK · S/N DH38N5803JAerospatiale SA315B · S/N 2646N586DKKamp Danny J MAXAIR DR 503 · S/N DR-0049
Back to Bozeman, MT