OpenAirDocs.org
Alba Leasing Services LLC

Registered aircraft · 29

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 = 'ALBA LEASING SERVICES LLC' OR list_contains(g.other_registrant_names, 'ALBA LEASING SERVICES 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.

N100NJBell 206B · S/N 3992Built 1987 · Scottsdale, AZN14QARobinson Helicopter R44 II · S/N 11370Built 2006 · Scottsdale, AZN158SFCessna 172S · S/N 172S10368Built 2006 · Scottsdale, AZN179UCostruzioni Aeronautiche Tecna P2008 · S/N 179Scottsdale, AZN200UHRobinson Helicopter R22 BETA · S/N 4634Built 2014 · Scottsdale, AZN202UCostruzioni Aeronautiche Tecna P2008 · S/N 167Built 2019 · Scottsdale, AZN300UHRobinson Helicopter R44 II · S/N 13964Built 2016 · Scottsdale, AZN303UCostruzioni Aeronautiche Tecna P2008 · S/N 168Built 2019 · Scottsdale, AZN3125URobinson Helicopter R44 II · S/N 11369Built 2006 · Scottsdale, AZN3255HRobinson Helicopter R44 II · S/N 11686Built 2007 · Scottsdale, AZN333UHRobinson Helicopter R44 II · S/N 13626Built 2013 · Scottsdale, AZN393DMRobinson Helicopter R44 II · S/N 10834Built 2005 · Scottsdale, AZN404UCostruzioni Aeronautiche Tecna P2010 · S/N 075/USBuilt 2019 · Scottsdale, AZN418UCostruzioni Aeronautiche Tecna P2008 · S/N 180Built 2020 · Scottsdale, AZN422UCostruzioni Aeronautiche Tecna P2006T · S/N 292/USBuilt 2019 · Scottsdale, AZN44UHRobinson Helicopter R22 · S/N 4677Built 2015 · Scottsdale, AZN456UCostruzioni Aeronautiche Tecna P2008 · S/N 171Built 2019 · Scottsdale, AZN456UHRobinson Helicopter R22 · S/N 4655Built 2014 · Scottsdale, AZN501UCostruzioni Aeronautiche Tecna P2010 · S/N 101/USBuilt 2020 · Scottsdale, AZN503UCostruzioni Aeronautiche Tecna P2010 · S/N 103/USBuilt 2019 · Scottsdale, AZN505UCostruzioni Aeronautiche Tecna P2010 · S/N 093/USBuilt 2019 · Scottsdale, AZN509UCostruzioni Aeronautiche Tecna P2010 · S/N 109/USBuilt 2020 · Scottsdale, AZN55UPBell 206B · S/N 3750Built 1983 · Scottsdale, AZN567UCostruzioni Aeronautiche Tecna P2008 · S/N 172Built 2019 · Scottsdale, AZN606UCostruzioni Aeronautiche Tecna P2010 · S/N 094/USBuilt 2019 · Scottsdale, AZN77UHRobinson Helicopter R22 BETA · S/N 4398Built 2008 · Scottsdale, AZN788UCostruzioni Aeronautiche Tecna P2006T · S/N 295/USBuilt 2019 · Scottsdale, AZN909UCostruzioni Aeronautiche Tecna P2010 · S/N 095/USBuilt 2019 · Scottsdale, AZN944PCRobinson Helicopter R44 II · S/N 10292Built 2004 · Phoenix, AZ
Back to Alba Leasing Services LLC