OpenAirDocs.org
Unical Aviation Inc

Earlier aircraft under this name · 65

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

Query with SQL
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 = 'UNICAL AVIATION INC' OR list_contains(d.other_registrant_names, 'UNICAL AVIATION 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.

N699UABombardier DHC-8-402 · S/N 4177Cancelled Nov 13, 2023 · City Of Industry, CAN564UABoeing 757-222 · S/N 26666Cancelled Feb 23, 2023 · Built 1992 · City Of Industry, CAN566UABoeing 757-222 · S/N 26670Cancelled Feb 23, 2023 · Built 1992 · City Of Industry, CAN283UABoeing 777-237LR · S/N 36303Cancelled Feb 22, 2023 · City Of Industry, CAN284UABoeing 777-237LR · S/N 36304Cancelled Feb 22, 2023 · City Of Industry, CAN552UABoeing 757-222 · S/N 26641Cancelled Feb 22, 2023 · Built 1992 · City Of Industry, CAN554UABoeing 757-222 · S/N 26644Cancelled Feb 22, 2023 · Built 1992 · City Of Industry, CAN557UABoeing 757-222 · S/N 26653Cancelled Feb 22, 2023 · Built 1992 · City Of Industry, CAN559UABoeing 757-222 · S/N 26657Cancelled Feb 22, 2023 · Built 1992 · City Of Industry, CAN560UABoeing 757-222 · S/N 26660Cancelled Feb 22, 2023 · Built 1992 · City Of Industry, CAN563UABoeing 757-222 · S/N 26665Cancelled Feb 22, 2023 · Built 1992 · City Of Industry, CAN565UABoeing 757-222 · S/N 26669Cancelled Feb 22, 2023 · Registration expired, pending cancellation · Built 1992 · City Of Industry, CAN573UABoeing 767-300 · S/N 27313Cancelled Feb 22, 2023 · City Of Industry, CAN683UABombardier DHC-8-402 · S/N 4121Cancelled Feb 22, 2023 · City Of Industry, CAN688UABombardier DHC-8-402 · S/N 4076Cancelled Feb 22, 2023 · City Of Industry, CAN689UABombardier DHC-8-402 · S/N 4133Cancelled Feb 22, 2023 · City Of Industry, CAN690UABombardier DHC-8-402 · S/N 4072Cancelled Feb 22, 2023 · City Of Industry, CAN698UABombardier DHC-8-402 · S/N 4092Cancelled Feb 22, 2023 · City Of Industry, CAN968UABoeing 737-5L9 · S/N 28083Cancelled Feb 22, 2023 · City Of Industry, CAN969UABoeing 737-500 · S/N 28461Cancelled Feb 22, 2023 · Registration expired, pending cancellation · City Of Industry, CAN982UABoeing 767-346 · S/N 27658Cancelled Feb 22, 2023 · City Of Industry, CAN591AKSikorsky S-76B · S/N 760348Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 1989 · Walnut, CAN160AXSikorsky UH-60A · S/N 86-24520Cancelled Dec 3, 2022 · Registration expired, pending cancellation · City Of Industry, CAN160BLSikorsky UH-60A · S/N 88-26067Cancelled Dec 3, 2022 · Registration expired, pending cancellation · City Of Industry, CAN166AGSikorsky UH-60A · S/N 81-23558Cancelled Dec 3, 2022 · Registration expired, pending cancellation · City Of Industry, CAN966UABoeing 737-500 · S/N 27434Cancelled Oct 25, 2022 · City Of Industry, CAN160BFSikorsky UH-60A · S/N 83-23869Cancelled Oct 1, 2022 · Registration expired, pending cancellation · City Of Industry, CAN160BNSikorsky UH-60A · S/N 83-23881Cancelled Oct 1, 2022 · Registration expired, pending cancellation · City Of Industry, CAN160CVSikorsky UH-60A · S/N 79-23327Cancelled Sep 3, 2022 · Registration expired, pending cancellation · City Of Industry, CAN696UABombardier DHC-8-402 · S/N 4158Cancelled Jul 2, 2022 · Registration expired, pending cancellation · City Of Industry, CAN695UABoeing 737-500 · S/N 28991Cancelled Jun 4, 2022 · Registration expired, pending cancellation · City Of Industry, CAN694UABoeing 737-5L9 · S/N 28131Cancelled May 9, 2022 · Registration expired, pending cancellation · City Of Industry, CAN160CUSikorsky UH-60A · S/N 80-23451Cancelled Mar 8, 2022 · First renewal notice · Built 1980 · City Of Industry, CAN678UABoeing 737-500 · S/N 28992Cancelled Feb 5, 2022 · Registration expired, pending cancellation · City Of Industry, CAN692UABoeing 737-5L9 · S/N 28130Cancelled Feb 5, 2022 · Registration expired, pending cancellation · City Of Industry, CAN691UABombardier DHC-8-402 · S/N 4107Cancelled Jan 8, 2022 · Registration expired, pending cancellation · City Of Industry, CAN680UABoeing 737-54K · S/N 27966Cancelled Dec 10, 2021 · Registration expired, pending cancellation · City Of Industry, CAN128XXAirbus Industrie A340-300 · S/N 0128Cancelled Dec 8, 2021 · Registration expired, pending cancellation · City Of Industry, CAN160CJSikorsky UH-60A · S/N 82-23688Cancelled Nov 5, 2021 · First renewal notice · Built 1982 · City Of Industry, CAN166AQSikorsky UH-60A · S/N 82-23757Cancelled Nov 5, 2021 · Built 1982 · City Of Industry, CAN681UABoeing 737-500 · S/N 27432Cancelled Nov 5, 2021 · Registration expired, pending cancellation · City Of Industry, CAN160CESikorsky UH-60A · S/N 82-23740Cancelled Nov 4, 2021 · Built 1982 · City Of Industry, CAN160WLSikorsky EH-60A · S/N 86-24577Cancelled Nov 4, 2021 · Third renewal notice · City Of Industry, CAN320UAAirbus Industrie A320-232 · S/N 1723Cancelled Nov 4, 2021 · First renewal notice · City Of Industry, CAN693UABoeing 737-5L9 · S/N 28128Cancelled Nov 4, 2021 · Second renewal notice · City Of Industry, CAN967UABoeing 737-500 · S/N 28990Cancelled Nov 4, 2021 · City Of Industry, CAN280UABoeing 777-237LR · S/N 36300Cancelled Sep 13, 2021 · First renewal notice · City Of Industry, CAN281UABoeing 777-237LR · S/N 36301Cancelled Sep 13, 2021 · City Of Industry, CAN679UABoeing 737-54K · S/N 27433Cancelled Sep 4, 2020 · Registration expired, pending cancellation · City Of Industry, CAN515UABombardier DHC-8-402 · S/N 4111Cancelled Aug 2, 2020 · Registration expired, pending cancellation · City Of Industry, CA
Back to Unical Aviation Inc