Gm Leasing Co LLC
Registered aircraft · 36
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 = 'GM LEASING CO LLC' OR list_contains(g.other_registrant_names, 'GM LEASING CO 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 = 'GM LEASING CO LLC' OR list_contains(g.other_registrant_names, 'GM LEASING CO 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.
N1170Bell Helicopter Textron Canada 407 · S/N 53478N127APBell 206B · S/N 4460N141APBell 407 · S/N 53441N1612Bell 407 · S/N 53044N161SFBell 206-L4 · S/N 52335N1751Bell 206B · S/N 3284N1807Bell 206-L4 · S/N 52361N1821Bell 206-L4 · S/N 52366N184SFBell 407 · S/N 53087N205FCBell 206L-3 · S/N 51130N294VMBell 407 · S/N 53781N3180LBell 206L-3 · S/N 51055N3191Bell 407 · S/N 53211N338AEBell 206-L4 · S/N 52087N369PABell 407 · S/N 53015N377RSBell 407 · S/N 53584N405LPBell Helicopter Textron Canada 206L-4 · S/N 52085N406MPBell 206-L4 · S/N 52086N40WHKeystone Helicopter S-76C · S/N 760756N4833Bell 206L-3 · S/N 51285N48AHBell 407 · S/N 53204N5843Bell 206L-3 · S/N 51467N591PABell Helicopter Textron Canada 407 · S/N 54456N611PABell 407 · S/N 53573N613PABell 407 · S/N 53627N6160YBell 206L-3 · S/N 51609N616PABell Helicopter Textron Canada 407 · S/N 53723N723SFBell 407 · S/N 53264N762MHSikorsky S-76A · S/N 760233N763MHSikorsky S-76A · S/N 760230N764MHSikorsky S-76 · S/N 760181N765MHSikorsky S-76A · S/N 760236N768MHSikorsky S-76A · S/N 760189N769MHSikorsky S-76A · S/N 760278N851HCBell 407 · S/N 53179N891BGSikorsky S-76C · S/N 760679
Back to Gm Leasing Co LLC