Bank Of Utah Trustee
Registered aircraft · 1,837
Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.
Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'BANK OF UTAH TRUSTEE' OR list_contains(g.other_registrant_names, 'BANK OF UTAH TRUSTEE') ORDER BY g.n_number"
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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'BANK OF UTAH TRUSTEE' OR list_contains(g.other_registrant_names, 'BANK OF UTAH TRUSTEE') ORDER BY g.n_number
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.
N100ZTTextron 525C · S/N 525C0392N101DUC Series Aircraft Ltd Ptnrsp BD-500-1A10 · S/N 50020N101FXGulfstream Aerospace GVIII-G700 · S/N 87054N101NYGulfstream Aerospace GIV-X (G450) · S/N 4221N102DUC Series Aircraft Ltd Ptnrsp BD-500-1A10 · S/N 50021N102NYGulfstream Aerospace GIV-X (G450) · S/N 4230N102XXAero L-39 ALBATROS · S/N 040002N103FXGulfstream Aerospace GVIII-G700 · S/N 87039N105DUC Series Aircraft Ltd Ptnrsp BD-500-1A10 · S/N 50024N105GKMesserschmitt-Boelkow-Blohm BO-105S · S/N S-458N105JSBoeing 737-8 · S/N 43709N105TPAir Tractor AT-502A · S/N 502A-3352N106DUC Series Aircraft Ltd Ptnrsp BD-500-1A10 · S/N 50025N106XXAero Vodochody L-39MS · S/N 140006N1073WBell 214B-1 · S/N 28012N1078NBell Helicopter Textron 206L-1 · S/N 45389N107AVCessna 750 · S/N 750-0107N107DUC Series Aircraft Ltd Ptnrsp BD-500-1A10 · S/N 50026N108DQC Series Aircraft Ltd Ptnrsp BD-500-1A10 · S/N 50027N109DUC Series Aircraft Ltd Ptnrsp BD-500-1A10 · S/N 50028N109JSBoeing 737-8 · S/N 43712N109NNAirbus Industrie A321-231 · S/N 5955N10GFHawker Beechcraft C90GTI · S/N LJ-1970N10TFAir Tractor AT-602 · S/N 602-1217N10XGGulfstream Aerospace GV-SP (G550) · S/N 5186N110DUC Series Aircraft Ltd Ptnrsp BD-500-1A10 · S/N 50029N110GDRaytheon HAWKER 800XP · S/N 258713N110HAIsrael Aircraft Industries GULFSTREAM 200 · S/N 035N110JSBoeing 737-8 · S/N 43755N111GECessna 525 · S/N 525-0661N111NGC Series Aircraft Ltd Ptnrsp BD-500-1A10 · S/N 50030N112BZEmbraer Empresa Brasileira De ERJ 190-100 IGW · S/N 19000077N112DUC Series Aircraft Ltd Ptnrsp BD-500-1A10 · S/N 50031N112SHBell 47G-3B-1 · S/N 6567N112VLBombardier CL-600-2B19 · S/N 8011N113DQC Series Aircraft Ltd Ptnrsp BD-500-1A10 · S/N 50032N114DUC Series Aircraft Ltd Ptnrsp BD-500-1A10 · S/N 50033N114WCessna 525A · S/N 525A0350N11536Embraer EMB-145LR · S/N 145520N115DUAirbus Canada Ltd Ptnrsp BD-500-1A10 · S/N 50034N115LAAir Tractor AT-402B · S/N 402B-1152N116TTBeech B300 · S/N FL-78N117DUAirbus Canada Ltd Ptnrsp BD-500-1A10 · S/N 50036N117PCBell Helicopter Textron Canada 407 · S/N 54713N117UWAirbus Industrie A320-214 · S/N 1224N118DSBoeing 777-36NER · S/N 37704N118DUAirbus Canada Ltd Ptnrsp BD-500-1A10 · S/N 50037N118USAirbus Industrie A320-214 · S/N 1264N1194RCessna 182T · S/N 18281894N119DUAirbus Canada Ltd Ptnrsp BD-500-1A10 · S/N 50038
Back to Bank Of Utah Trustee