Mustang Leasing LLC
Registered aircraft · 38
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 = 'MUSTANG LEASING LLC' OR list_contains(g.other_registrant_names, 'MUSTANG LEASING LLC') 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 = 'MUSTANG LEASING LLC' OR list_contains(g.other_registrant_names, 'MUSTANG LEASING LLC') 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.
N152AEKeystone Helicopter S-76C · S/N 760714N816MHEurocopter EC 130 B4 · S/N 4038N817MHEurocopter EC 130 B4 · S/N 4125N818MHEurocopter EC 130 B4 · S/N 4131N821MHEurocopter EC 130 B4 · S/N 4134N822MHEurocopter EC 130 B4 · S/N 4142N823MHEurocopter EC 130 B4 · S/N 4158N824MHEurocopter EC 130 B4 · S/N 4173N846MHEurocopter EC 130 B4 · S/N 4248N847MHEurocopter EC 130 B4 · S/N 4266N848MHEurocopter EC 130 B4 · S/N 4290N849MHEurocopter EC 130 B4 · S/N 4313N850MHEurocopter EC 130 B4 · S/N 4327N851MHEurocopter France EC 130 B4 · S/N 4340N852MHEurocopter EC 130 B4 · S/N 4356N853MHEurocopter EC 130 B4 · S/N 4417N854MHEurocopter EC 130 B4 · S/N 4433N856MHEurocopter EC 130 B4 · S/N 4437N857MHEurocopter EC 130 B4 · S/N 4457N858MHEurocopter EC 130 B4 · S/N 4503N862MHEurocopter EC 130 B4 · S/N 4545N863MHEurocopter EC 130 B4 · S/N 4570N864MHEurocopter EC 130 B4 · S/N 4616N867MHEurocopter France EC 130 B4 · S/N 4770N868MHEurocopter EC 130 B4 · S/N 4797N872MHEurocopter EC 130 T2 · S/N 7355N873MHEurocopter EC 130 T2 · S/N 7532N875MHEurocopter EC 130 T2 · S/N 7592N876MHEurocopter EC 130 T2 · S/N 7621N877MHEurocopter EC 130 T2 · S/N 7637N878MHEurocopter EC 130 T2 · S/N 7779N879MHAirbus Helicopters EC 130 T2 · S/N 7805N880MHAirbus Helicopters EC 130 T2 · S/N 7852N881MHAirbus Helicopters EC 130 T2 · S/N 7898N882MHAirbus Helicopters EC 130 T2 · S/N 7913N884MHAirbus Helicopters EC 130 T2 · S/N 7979N885MHAirbus Helicopters EC 130 T2 · S/N 8057N886MHAirbus Helicopters EC 130 T2 · S/N 8060
Back to Mustang Leasing LLC