Platform Systems Inc DBA
Registered aircraft · 31
Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.
Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'PLATFORM SYSTEMS INC DBA' OR list_contains(g.other_registrant_names, 'PLATFORM SYSTEMS INC DBA') ORDER BY g.n_number"
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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'PLATFORM SYSTEMS INC DBA' OR list_contains(g.other_registrant_names, 'PLATFORM SYSTEMS INC DBA') ORDER BY g.n_number
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.
N612VUPlatform SYS Inc DBA Plat Aero VANILLA · S/N 012-VA001N613VUPlatform SYS Inc DBA Plat Aero VANILLA · S/N 013-VA001N617VUPlatform SYS Inc DBA Plat Aero VANILLA · S/N 017-VA001N618VUPlatform SYS Inc DBA Plat Aero VANILLA · S/N 018-VA001N619VUPlatform SYS Inc DBA Plat Aero VANILLA · S/N 019-VA001N620VUPlatform SYS Inc DBA Plat Aero VANILLA · S/N 020-VA001N622VUPlatform SYS Inc DBA Plat Aero VANILLA · S/N 022-VA001N623VUPlatform SYS Inc DBA Plat Aero VANILLA · S/N 023-VA001N624VUPlatform SYS Inc DBA Plat Aero VANILLA · S/N 024-VA001N625VUPlatform SYS Inc DBA Plat Aero VANILLA · S/N 025-VA001N626VUPlatform SYS Inc DBA Plat Aero VANILLA · S/N 026-VA001N627VUPlatform SYS Inc DBA Plat Aero VANILLA · S/N 027-VA001N628VUPlatform SYS Inc DBA Plat Aero VANILLA · S/N 028-VA001N629VUPlatform SYS Inc DBA Plat Aero VANILLA · S/N 029-VA001N630VUPlatform SYS Inc DBA Plat Aero VANILLA · S/N 030-VA001N631VUPlatform SYS Inc DBA Plat Aero VANILLA · S/N 031-VA001N634VUPlatform SYS Inc DBA Plat Aero VANILLA · S/N 034-VA001N635VUPlatform SYS Inc DBA Plat Aero VANILLA · S/N 035-VA001N636VUPlatform SYS Inc DBA Plat Aero VANILLA · S/N 036-VA001N637VUPlatform SYS Inc DBA Plat Aero VANILLA · S/N 037-VA001N638VUPlatform SYS Inc DBA Plat Aero VANILLA · S/N 038-VA001N639VUPlatform SYS Inc DBA Plat Aero VANILLA · S/N 039-VA001N641VUPlatform SYS Inc DBA Plat Aero VANILLA · S/N MANUFACTURERN642VUPlatform SYS Inc DBA Plat Aero VANILLA · S/N 042-VA001N643VUPlatform SYS Inc DBA Plat Aero VANILLA · S/N 043-VA001N644VUPlatform SYS Inc DBA Plat Aero VANILLA · S/N 044-VA001N645VUPlatform SYS Inc DBA Plat Aero VANILLA · S/N 045-VA001N646VUPlatform SYS Inc DBA Plat Aero VANILLA · S/N 046-VA001N647VUPlatform SYS Inc DBA Plat Aero VANILLA · S/N 047-VA001N648VUPlatform SYS Inc DBA Plat Aero VANILLA · S/N 048-VA001N649VUPlatform SYS Inc DBA Plat Aero VANILLA · S/N 049-VA001
Back to Platform Systems Inc DBA