Aircraft Instrument Corp

Earlier aircraft under this name · 32

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 = 'AIRCRAFT INSTRUMENT CORP' OR list_contains(d.other_registrant_names, 'AIRCRAFT INSTRUMENT CORP')
  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.

N9562CConsolidated Vultee PBY-6A · S/N BU46679Cancelled Sep 2, 2023 · Revoked, canceled · Miami, FLN9563CConsolidated Vultee PBY-6A · S/N 64008Cancelled Aug 16, 2023 · Revoked, pending cancellation · Miami, FLN9520CConsolidated Vultee PBY-6A · S/N 64053Cancelled Nov 21, 2017 · Revoked, canceled · Miami, FLN9531CConsolidated Vultee PBY-6A · S/N 46685Cancelled Nov 21, 2017 · Revoked, canceled · Miami, FLN9532CConsolidated Vultee PBY-6A · S/N 46666Cancelled Nov 21, 2017 · Revoked, canceled · Miami, FLN9533CConsolidated Vultee PBY-6A · S/N 64042Cancelled Nov 21, 2017 · Revoked, canceled · Miami, FLN9553CConsolidated Vultee PBY-6A · S/N 46642Cancelled Nov 21, 2017 · Revoked, canceled · Miami, FLN9554CConsolidated Vultee PBY-6A · S/N 64044Cancelled Nov 21, 2017 · Revoked, canceled · Miami, FLN7877BConsolidated Vultee PBY-6A · S/N 46659Cancelled Feb 4, 2017 · Revoked, canceled · Miami, FLN7878BConsolidated Vultee PBY-6A · S/N 46650Cancelled Feb 4, 2017 · Revoked, canceled · Miami, FLN7880BConsolidated Vultee PBY-6A · S/N 46639Cancelled Feb 4, 2017 · Revoked, canceled · Miami, FLN7883BConsolidated Vultee PBY-6A · S/N 64005Cancelled Feb 4, 2017 · Revoked, canceled · Miami, FLN7884BConsolidated Vultee PBY-6A · S/N 64033Cancelled Feb 4, 2017 · Revoked, canceled · Miami, FLN6465CConsolidated Vultee PBY-6A · S/N 64104Cancelled Aug 6, 2013 · Revoked, canceled · Miami, FLN9556CConsolidated Vultee PBY-6A · S/N 46643Cancelled Nov 14, 2012 · Revoked, canceled · Miami, FLN7885BConsolidated Vultee PBY-6A · S/N 64047Cancelled Feb 10, 1971 · Miami, FLN9586CConsolidated Vultee PBY-6A · S/N 64105Cancelled Jan 4, 1971 · Miami, FLN7881BConsolidated Vultee PBY-6A · S/N 46667Cancelled Oct 7, 1970 · Miami, FLN7882BConsolidated Vultee PBY-6A · S/N 63995Cancelled Oct 7, 1970 · Miami, FLN7786BConsolidated Vultee PBY-6A · S/N 46683Cancelled Sep 23, 1970 · Miami, FLN7858BConsolidated Vultee PBY-6A · S/N 64099Cancelled Sep 23, 1970 · Miami, FLN7875BConsolidated Vultee PBY-6A · S/N 46673Cancelled Sep 23, 1970 · Miami, FLN7876BConsolidated Vultee PBY-6A · S/N 46663Cancelled Sep 23, 1970 · Miami, FLN7879BConsolidated Vultee PBY-6A · S/N 46647Cancelled Sep 23, 1970 · Miami, FLN7861BConsolidated Vultee PBY-6A · S/N 64007Cancelled Sep 11, 1970 · Miami, FLN7781BConsolidated Vultee PBY-6A · S/N 64016Cancelled Sep 10, 1970 · Miami, FLN7782BConsolidated Vultee PBY-6A · S/N 64010Cancelled Sep 10, 1970 · Miami, FLN7783BConsolidated Vultee PBY-6A · S/N 64013Cancelled Sep 10, 1970 · Miami, FLN7784BConsolidated Vultee PBY-6A · S/N 64001Cancelled Sep 10, 1970 · Miami, FLN7785BConsolidated Vultee PBY-6A · S/N 46687Cancelled Sep 10, 1970 · Miami, FLN7787BConsolidated Vultee PBY-6A · S/N 46680Cancelled Sep 10, 1970 · Miami, FLN7443CConsolidated Vultee PBY-6A · S/N 46654Cancelled Jun 22, 1961 · Exported to Colombia · Miami, FL
Back to Aircraft Instrument Corp