OpenAirDocs.org
Aersale Inc

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 = 'AERSALE INC' OR list_contains(g.other_registrant_names, 'AERSALE INC')
  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.

N111ASBoeing 757-2G5 · S/N 29488Coral Gables, FLN158ASAirbus A320-214 · S/N 1578Coral Gables, FLN182ANBoeing 757-223 · S/N 29592Built 1999 · Coral Gables, FLN199ANBoeing 757-223 · S/N 32393Built 2001 · Doral, FLN272AYAirbus Industrie A330-323 · S/N 0333Built 2000 · Coral Gables, FLN30ASBoeing 737-76N · S/N 30050Built 1999 · Doral, FLN353ASAirbus Industrie A320-214 · S/N 553Coral Gables, FLN353PABoeing 727-225 · S/N 20622Coral Gables, FLN400ASBoeing 737-82R · S/N 30658Doral, FLN489BRBoeing 757-2G5 · S/N 29489Doral, FLN692AABoeing 757-223 · S/N 26972Built 1993 · Doral, FLN726WNBoeing 757-2Q8 · S/N 27623Coral Gables, FLN818NHBoeing 757-256 · S/N 29311Built 2000 · Doral, FLN827AVAirbus A319-115 · S/N 4287Coral Gables, FLN834ASBoeing 757-204 · S/N 28834Coral Gables, FLN835ASBoeing 757-28A · S/N 28835Coral Gables, FLN939UWBoeing 757-2B7 · S/N 27303Built 1994 · Coral Gables, FL
Back to Aersale Inc