Skip to content

Earlier aircraft under this name · 91

Cancelled registrations that named this owner when they ended, newest first.

Query with SQL

SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'AERSALE INC' OR list_contains(d.other_registrant_names, 'AERSALE INC') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
  WHERE d.registrant_name = 'AERSALE INC' OR list_contains(d.other_registrant_names, 'AERSALE INC')
  ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"

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.

SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
WHERE d.registrant_name = 'AERSALE INC' OR list_contains(d.other_registrant_names, 'AERSALE INC')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N195ANBoeing 757-223 · S/N 32389Cancelled Sep 10, 2026 · Exported to Kazakhstan · Built 2001 · Doral, FL N197ANBoeing 757-223 · S/N 32391Cancelled Jul 31, 2026 · Exported to Romania · Built 2001 · Doral, FL N175ANBoeing 757-223 · S/N 32394Cancelled Mar 17, 2026 · Exported to Uzbekistan · Built 2001 · Doral, FL N28833Boeing 757-28A · S/N 28833Cancelled Dec 11, 2024 · Exported to Uzbekistan · Built 1997 · Coral Gables, FL N955ASAirbus Industrie A320-214 · S/N 559Cancelled Mar 26, 2024 · Coral Gables, FL N355PABoeing 727-225 · S/N 20624Cancelled Jun 28, 2023 · Coral Gables, FL N356PABoeing 727-225 · S/N 20626Cancelled Jun 28, 2023 · Coral Gables, FL N308AEAirbus Industrie A330-223 · S/N 308Cancelled May 10, 2023 · Coral Gables, FL N109ASBoeing 737-71M · S/N 33103Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Coral Gables, FL N737ABoeing 737-7AX · S/N 30181Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 2000 · Coral Gables, FL N983AEBoeing 737-800 · S/N 27983Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Coral Gables, FL N364ASBoeing 747-446 · S/N 26343Cancelled Jul 1, 2022 · Exported to Iceland · Coral Gables, FL N807ASAirbus Industrie A320-214 · S/N 870Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Coral Gables, FL N261LFBoeing 767-352 · S/N 26261Cancelled May 7, 2022 · Registration expired, pending cancellation · Coral Gables, FL N780ASBoeing 747-4H6 · S/N 25699Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Coral Gables, FL N281ASBoeing 767-3Q8ER · S/N 28132Cancelled Oct 16, 2021 · Coral Gables, FL N402XAAirbus Industrie A340-300 · S/N 402Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Coral Gables, FL N411XAAirbus Industrie A340-300 · S/N 411Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Coral Gables, FL N415XAAirbus Industrie A340-300 · S/N 415Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Coral Gables, FL N969ASMcdonnell Douglas MD-90-30 · S/N 53496Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Coral Gables, FL N184ANBoeing 757-223 · S/N 29594Cancelled Jun 17, 2021 · Exported to Canada · Built 1999 · Coral Gables, FL N799ASBoeing 737-8Q8 · S/N 32799Cancelled Mar 5, 2021 · Exported to Canada · Built 2004 · Coral Gables, FL N452ASMcdonnell Douglas MD-90-30 · S/N 53519Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Coral Gables, FL N641ASMcdonnell Douglas MD-90-30 · S/N 53518Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Coral Gables, FL N181ASMcdonnell Douglas MD-90-30 · S/N 53509Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Coral Gables, FL N631ASMcdonnell Douglas MD-90-30 · S/N 53498Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Coral Gables, FL N901ASBoeing 737-33A · S/N 27469Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Coral Gables, FL N760AEBoeing 737-86J · S/N 37760Cancelled Aug 28, 2019 · Exported to Canada · Coral Gables, FL N758AEBoeing 737-86J · S/N 37758Cancelled Aug 12, 2019 · Exported to Canada · Coral Gables, FL N496ASMcdonnell Douglas MD-90-30 · S/N 53494Cancelled Jul 26, 2019 · Registration expired, pending cancellation · Coral Gables, FL N774ASBoeing 747-4H6 · S/N 27043Cancelled Jul 10, 2019 · Registration expired, pending cancellation · Coral Gables, FL N148ASAirbus Industrie A320-233 · S/N 1400Cancelled Jul 2, 2019 · Coral Gables, FL N949ASBoeing 747-45E · S/N 27142Cancelled Mar 16, 2019 · Registration expired, pending cancellation · Coral Gables, FL N720ASAirbus Industrie A300 B4-622R · S/N 787Cancelled Dec 18, 2018 · Registration expired, pending cancellation · Coral Gables, FL N539ASBoeing 777-200 · S/N 28507Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Coral Gables, FL N761XABoeing 767-27GER · S/N 27048Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Coral Gables, FL N894UPDouglas DC-8-73F · S/N 46094Cancelled Apr 4, 2018 · Registration expired, pending cancellation · Built 1969 · Coral Gables, FL N195ASMcdonnell Douglas MD-90-30 · S/N 53495Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Coral Gables, FL N384ASMcdonnell Douglas MD-90-30 · S/N 53514Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Coral Gables, FL N264ASBoeing 747-400 · S/N 24426Cancelled Mar 9, 2018 · Registration expired, pending cancellation · Coral Gables, FL N632ASMcdonnell Douglas MD-90-30 · S/N 53499Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Coral Gables, FL N635ASMcdonnell Douglas MD-90-30 · S/N 53500Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Coral Gables, FL N489ASBoeing 767-336 · S/N 24337Cancelled Mar 5, 2018 · Registration expired, pending cancellation · Coral Gables, FL N287ASMcdonnell Douglas MD-90-30 · S/N 53508Cancelled Mar 2, 2018 · Registration expired, pending cancellation · Coral Gables, FL N289ASMcdonnell Douglas MD-90-30 · S/N 53512Cancelled Mar 2, 2018 · Registration expired, pending cancellation · Coral Gables, FL N671ASMcdonnell Douglas MD-90-30 · S/N 53515Cancelled Mar 2, 2018 · Registration expired, pending cancellation · Coral Gables, FL N132ASMcdonnell Douglas MD-90-30 · S/N 53510Cancelled Feb 28, 2018 · Registration expired, pending cancellation · Coral Gables, FL N173ASMcdonnell Douglas MD-90-30 · S/N 53491Cancelled Feb 28, 2018 · Registration expired, pending cancellation · Coral Gables, FL N629ASMcdonnell Douglas MD-90-30 · S/N 53502Cancelled Feb 20, 2018 · Registration expired, pending cancellation · Coral Gables, FL N643ASMcdonnell Douglas MD-90-30 · S/N 53497Cancelled Feb 20, 2018 · Registration expired, pending cancellation · Coral Gables, FL

Back to Aersale Inc