Nevada Helicopter Leasing LLC
Registered aircraft · 24
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 = 'NEVADA HELICOPTER LEASING LLC' OR list_contains(g.other_registrant_names, 'NEVADA HELICOPTER 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 = 'NEVADA HELICOPTER LEASING LLC' OR list_contains(g.other_registrant_names, 'NEVADA HELICOPTER 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.
N11EQEurocopter EC 130 T2 · S/N 7485N11MQAirbus Helicopters EC 130 T2 · S/N 7879N11NQAirbus Helicopters EC 130 T2 · S/N 7950N11QAEurocopter EC 130 B4 · S/N 3887N11QCEurocopter France EC 130 B4 · S/N 3358N11QEEurocopter EC 130 · S/N 3381N11QFEurocopter EC 130 B4 · S/N 3482N11QGEurocopter EC 130 B4 · S/N 3534N11QHEurocopter EC 130 B4 · S/N 3561N11QJEurocopter EC 130 B4 · S/N 4528N11QKEurocopter EC 130 B4 · S/N 3639N11QLEurocopter EC 130 B4 · S/N 3738N11QMEurocopter EC 130 B4 · S/N 3751N11QNEurocopter EC 130 B4 · S/N 3758N11QPEurocopter EC 130 B4 · S/N 4715N11QREurocopter EC 130 B4 · S/N 3992N11QUEurocopter EC 130 B4 · S/N 4758N11QWEurocopter EC 130 B4 · S/N 4929N11QXEurocopter EC 130 B4 · S/N 7198N11QYEurocopter EC 130 B4 · S/N 7229N11QZEurocopter EC 130 B4 · S/N 4663N11TQAirbus Helicopters EC 130 T2 · S/N 8044N197BHEurocopter AS 350 B2 · S/N 2666N732YZCessna U206G · S/N U20604741
Back to Nevada Helicopter Leasing LLC