OpenAirDocs.org
Gm Leasing Company LLC

Registered aircraft · 32

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 COMPANY LLC' OR list_contains(g.other_registrant_names, 'GM LEASING COMPANY 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.

N125TABell 206B · S/N 1315Built 1974 · Broussard, LAN140HLBell 407 · S/N 53575Built 2003 · Broussard, LAN1416Bell 407 · S/N 53110Broussard, LAN153PABell Helicopter Textron Canada 407 · S/N 54455Built 2013 · Broussard, LAN173SFBell Helicopter Textron Canada 407 · S/N 53978Broussard, LAN307KHBell 407 · S/N 53172Built 1997 · Broussard, LAN376WHKeystone Helicopter S-76C · S/N 760759Built 2009 · Broussard, LAN454WHKeystone Helicopter S-76C · S/N 760802Built 2010 · Broussard, LAN509AABell 407 · S/N 53716Built 2006 · Broussard, LAN531PABell Helicopter Textron Canada 407 · S/N 53876Built 2008 · Broussard, LAN59WHBell 407 · S/N 53261Built 1998 · Broussard, LAN664RLBell 407 · S/N 53037Built 1996 · Broussard, LAN668RLBell 407 · S/N 53383Built 1999 · Broussard, LAN669RLBell Helicopter Textron Canada 407 · S/N 53550Built 2003 · Broussard, LAN670RLBell 407 · S/N 53413Built 2000 · Broussard, LAN671RLBell 407 · S/N 53480Broussard, LAN674RLBell 407 · S/N 53227Built 1997 · Broussard, LAN694PABell 407 · S/N 53482Built 2001 · Broussard, LAN715AEBell 407 · S/N 53731Built 2006 · Broussard, LAN726HBell 206L-3 · S/N 51548Built 1992 · Broussard, LAN751HCBell 407 · S/N 53308Built 1998 · Broussard, LAN781RLSikorsky S-76C · S/N 760673Built 2007 · Broussard, LAN782RLSikorsky S-76C · S/N 760666Built 2007 · Broussard, LAN783RLSikorsky S-76C · S/N 760735Built 2008 · Broussard, LAN784RLSikorsky S-76C · S/N 760721Built 2008 · Broussard, LAN785RLSikorsky S-76C · S/N 760639Built 2006 · Broussard, LAN786RLSikorsky S-76C · S/N 760618Built 2006 · Broussard, LAN787RLKeystone Helicopter S-76C · S/N 760778Built 2009 · Broussard, LAN82APBell 407 · S/N 53759Built 2007 · Broussard, LAN862YBBell Helicopter Textron Canada 407 · S/N 54837Built 2019 · Broussard, LAN87APBell 407 · S/N 53624Built 2004 · Broussard, LAN970CBell Helicopter Textron Canada 407 · S/N 54347Built 2012 · Broussard, LA
Back to Gm Leasing Company LLC