City Of Industry, CA

Cancelled registrations · 71

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_state = 'CA' AND d.registrant_city = 'CITY OF INDUSTRY'
  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 · Unical Aviation IncN511MQAirbus A321-100 · S/N 1511Cancelled Sep 30, 2023 · Sale reported, canceledN564UABoeing 757-222 · S/N 26666Cancelled Feb 23, 2023 · Built 1992 · Unical Aviation IncN566UABoeing 757-222 · S/N 26670Cancelled Feb 23, 2023 · Built 1992 · Unical Aviation IncN283UABoeing 777-237LR · S/N 36303Cancelled Feb 22, 2023 · Unical Aviation IncN284UABoeing 777-237LR · S/N 36304Cancelled Feb 22, 2023 · Unical Aviation IncN552UABoeing 757-222 · S/N 26641Cancelled Feb 22, 2023 · Built 1992 · Unical Aviation IncN554UABoeing 757-222 · S/N 26644Cancelled Feb 22, 2023 · Built 1992 · Unical Aviation IncN557UABoeing 757-222 · S/N 26653Cancelled Feb 22, 2023 · Built 1992 · Unical Aviation IncN559UABoeing 757-222 · S/N 26657Cancelled Feb 22, 2023 · Built 1992 · Unical Aviation IncN560UABoeing 757-222 · S/N 26660Cancelled Feb 22, 2023 · Built 1992 · Unical Aviation IncN563UABoeing 757-222 · S/N 26665Cancelled Feb 22, 2023 · Built 1992 · Unical Aviation IncN565UABoeing 757-222 · S/N 26669Cancelled Feb 22, 2023 · Registration expired, pending cancellation · Built 1992 · Unical Aviation IncN573UABoeing 767-300 · S/N 27313Cancelled Feb 22, 2023 · Unical Aviation IncN683UABombardier DHC-8-402 · S/N 4121Cancelled Feb 22, 2023 · Unical Aviation IncN688UABombardier DHC-8-402 · S/N 4076Cancelled Feb 22, 2023 · Unical Aviation IncN689UABombardier DHC-8-402 · S/N 4133Cancelled Feb 22, 2023 · Unical Aviation IncN690UABombardier DHC-8-402 · S/N 4072Cancelled Feb 22, 2023 · Unical Aviation IncN698UABombardier DHC-8-402 · S/N 4092Cancelled Feb 22, 2023 · Unical Aviation IncN968UABoeing 737-5L9 · S/N 28083Cancelled Feb 22, 2023 · Unical Aviation IncN969UABoeing 737-500 · S/N 28461Cancelled Feb 22, 2023 · Registration expired, pending cancellation · Unical Aviation IncN982UABoeing 767-346 · S/N 27658Cancelled Feb 22, 2023 · Unical Aviation IncN160AXSikorsky UH-60A · S/N 86-24520Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Unical Aviation IncN160BLSikorsky UH-60A · S/N 88-26067Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Unical Aviation IncN166AGSikorsky UH-60A · S/N 81-23558Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Unical Aviation IncN966UABoeing 737-500 · S/N 27434Cancelled Oct 25, 2022 · Unical Aviation IncN160BFSikorsky UH-60A · S/N 83-23869Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Unical Aviation IncN160BNSikorsky UH-60A · S/N 83-23881Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Unical Aviation IncN160CVSikorsky UH-60A · S/N 79-23327Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Unical Aviation IncN696UABombardier DHC-8-402 · S/N 4158Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Unical Aviation IncN695UABoeing 737-500 · S/N 28991Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Unical Aviation IncN694UABoeing 737-5L9 · S/N 28131Cancelled May 9, 2022 · Registration expired, pending cancellation · Unical Aviation IncN160CUSikorsky UH-60A · S/N 80-23451Cancelled Mar 8, 2022 · First renewal notice · Built 1980 · Unical Aviation IncN678UABoeing 737-500 · S/N 28992Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Unical Aviation IncN692UABoeing 737-5L9 · S/N 28130Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Unical Aviation IncN691UABombardier DHC-8-402 · S/N 4107Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Unical Aviation IncN680UABoeing 737-54K · S/N 27966Cancelled Dec 10, 2021 · Registration expired, pending cancellation · Unical Aviation IncN128XXAirbus Industrie A340-300 · S/N 0128Cancelled Dec 8, 2021 · Registration expired, pending cancellation · Unical Aviation IncN160CJSikorsky UH-60A · S/N 82-23688Cancelled Nov 5, 2021 · First renewal notice · Built 1982 · Unical Aviation IncN166AQSikorsky UH-60A · S/N 82-23757Cancelled Nov 5, 2021 · Built 1982 · Unical Aviation IncN681UABoeing 737-500 · S/N 27432Cancelled Nov 5, 2021 · Registration expired, pending cancellation · Unical Aviation IncN160CESikorsky UH-60A · S/N 82-23740Cancelled Nov 4, 2021 · Built 1982 · Unical Aviation IncN160WLSikorsky EH-60A · S/N 86-24577Cancelled Nov 4, 2021 · Third renewal notice · Unical Aviation IncN320UAAirbus Industrie A320-232 · S/N 1723Cancelled Nov 4, 2021 · First renewal notice · Unical Aviation IncN693UABoeing 737-5L9 · S/N 28128Cancelled Nov 4, 2021 · Second renewal notice · Unical Aviation IncN967UABoeing 737-500 · S/N 28990Cancelled Nov 4, 2021 · Unical Aviation IncN280UABoeing 777-237LR · S/N 36300Cancelled Sep 13, 2021 · First renewal notice · Unical Aviation IncN281UABoeing 777-237LR · S/N 36301Cancelled Sep 13, 2021 · Unical Aviation IncN679UABoeing 737-54K · S/N 27433Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Unical Aviation IncN515UABombardier DHC-8-402 · S/N 4111Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Unical Aviation Inc
Back to City Of Industry, CA