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.
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
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.
N9562CConsolidated Vultee PBY-6A · S/N BU46679N9563CConsolidated Vultee PBY-6A · S/N 64008N9520CConsolidated Vultee PBY-6A · S/N 64053N9531CConsolidated Vultee PBY-6A · S/N 46685N9532CConsolidated Vultee PBY-6A · S/N 46666N9533CConsolidated Vultee PBY-6A · S/N 64042N9553CConsolidated Vultee PBY-6A · S/N 46642N9554CConsolidated Vultee PBY-6A · S/N 64044N7877BConsolidated Vultee PBY-6A · S/N 46659N7878BConsolidated Vultee PBY-6A · S/N 46650N7880BConsolidated Vultee PBY-6A · S/N 46639N7883BConsolidated Vultee PBY-6A · S/N 64005N7884BConsolidated Vultee PBY-6A · S/N 64033N6465CConsolidated Vultee PBY-6A · S/N 64104N9556CConsolidated Vultee PBY-6A · S/N 46643N7885BConsolidated Vultee PBY-6A · S/N 64047N9586CConsolidated Vultee PBY-6A · S/N 64105N7881BConsolidated Vultee PBY-6A · S/N 46667N7882BConsolidated Vultee PBY-6A · S/N 63995N7786BConsolidated Vultee PBY-6A · S/N 46683N7858BConsolidated Vultee PBY-6A · S/N 64099N7875BConsolidated Vultee PBY-6A · S/N 46673N7876BConsolidated Vultee PBY-6A · S/N 46663N7879BConsolidated Vultee PBY-6A · S/N 46647N7861BConsolidated Vultee PBY-6A · S/N 64007N7781BConsolidated Vultee PBY-6A · S/N 64016N7782BConsolidated Vultee PBY-6A · S/N 64010N7783BConsolidated Vultee PBY-6A · S/N 64013N7784BConsolidated Vultee PBY-6A · S/N 64001N7785BConsolidated Vultee PBY-6A · S/N 46687N7787BConsolidated Vultee PBY-6A · S/N 46680N7443CConsolidated Vultee PBY-6A · S/N 46654
Back to Aircraft Instrument Corp