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.

N1170Bell Helicopter Textron Canada 407 · S/N 53478Built 2001 · Broussard, LAN127APBell 206B · S/N 4460Built 1997 · Broussard, LAN141APBell 407 · S/N 53441Built 2000 · Broussard, LAN1612Bell 407 · S/N 53044Built 1996 · Broussard, LAN161SFBell 206-L4 · S/N 52335Built 2006 · Broussard, LAN1751Bell 206B · S/N 3284Built 1981 · Broussard, LAN1807Bell 206-L4 · S/N 52361Built 2007 · Broussard, LAN1821Bell 206-L4 · S/N 52366Built 2007 · Broussard, LAN184SFBell 407 · S/N 53087Built 1996 · Broussard, LAN205FCBell 206L-3 · S/N 51130Built 1985 · Broussard, LAN294VMBell 407 · S/N 53781Built 2007 · Broussard, LAN3180LBell 206L-3 · S/N 51055Built 1983 · Broussard, LAN3191Bell 407 · S/N 53211Built 1997 · Broussard, LAN338AEBell 206-L4 · S/N 52087Built 1994 · Broussard, LAN369PABell 407 · S/N 53015Built 1996 · Broussard, LAN377RSBell 407 · S/N 53584Built 2003 · Broussard, LAN405LPBell Helicopter Textron Canada 206L-4 · S/N 52085Built 1994 · Broussard, LAN406MPBell 206-L4 · S/N 52086Built 1994 · Broussard, LAN40WHKeystone Helicopter S-76C · S/N 760756Built 2009 · Broussard, LAN4833Bell 206L-3 · S/N 51285Built 1989 · Broussard, LAN48AHBell 407 · S/N 53204Built 1997 · Broussard, LAN5843Bell 206L-3 · S/N 51467Built 1991 · Broussard, LAN591PABell Helicopter Textron Canada 407 · S/N 54456Built 2013 · Broussard, LAN611PABell 407 · S/N 53573Built 2003 · Broussard, LAN613PABell 407 · S/N 53627Built 2004 · Broussard, LAN6160YBell 206L-3 · S/N 51609Built 1992 · Broussard, LAN616PABell Helicopter Textron Canada 407 · S/N 53723Built 2006 · Broussard, LAN723SFBell 407 · S/N 53264Built 1998 · Broussard, LAN762MHSikorsky S-76A · S/N 760233Broussard, LAN763MHSikorsky S-76A · S/N 760230Broussard, LAN764MHSikorsky S-76 · S/N 760181Broussard, LAN765MHSikorsky S-76A · S/N 760236Built 1983 · Broussard, LAN768MHSikorsky S-76A · S/N 760189Built 1981 · Broussard, LAN769MHSikorsky S-76A · S/N 760278Broussard, LAN851HCBell 407 · S/N 53179Built 1997 · Broussard, LAN891BGSikorsky S-76C · S/N 760679Built 2007 · Broussard, LA
Back to Gm Leasing Co LLC