OpenAirDocs.org
Heritage Asset Leasing LLC

Registered aircraft · 17

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

N105HFCessna 172S · S/N 172S8724Ronkonkoma, NYN108HFCessna 172S · S/N 172S9049Built 2002 · Ronkonkoma, NYN124HFCessna 172S · S/N 172S9632Built 2004 · Ronkonkoma, NYN126HFCessna 172S · S/N 172S9053Built 2002 · Ronkonkoma, NYN127HFCessna 172S · S/N 172S9532Built 2003 · Ronkonkoma, NYN129HFCessna 172S · S/N 172S9667Built 2004 · Ronkonkoma, NYN136HFCessna 172S · S/N 172S9711Built 2004 · Ronkonkoma, NYN145HFCessna 172S · S/N 172S8745Built 2001 · Ronkonkoma, NYN174HFCessna 172S · S/N 172S8257Ronkonkoma, NYN210HFCessna 172S · S/N 172S9040Built 2002 · Ronkonkoma, NYN223HFCessna 172R · S/N 17281112Built 2002 · Ronkonkoma, NYN71HFCessna 172S · S/N 172S9758Built 2004 · Ronkonkoma, NYN87HFCessna 172S · S/N 172S8022Built 1998 · Ronkonkoma, NYN92HFCessna 172S · S/N 172S8642Built 2000 · Ronkonkoma, NYN93HFCessna 172S · S/N 172S8643Built 2000 · Ronkonkoma, NYN96HFBeech 76 · S/N ME-30Built 1978 · Ronkonkoma, NYN99HFCessna 172S · S/N 172S8222Built 1999 · Ronkonkoma, NY
Back to Heritage Asset Leasing LLC