Registered aircraft · 16

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

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 = 'VERTOL SYSTEMS COMPANY INC' OR list_contains(g.other_registrant_names, 'VERTOL SYSTEMS COMPANY INC') ORDER BY g.n_number

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 = 'VERTOL SYSTEMS COMPANY INC' OR list_contains(g.other_registrant_names, 'VERTOL SYSTEMS COMPANY INC')
  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 = 'VERTOL SYSTEMS COMPANY INC' OR list_contains(g.other_registrant_names, 'VERTOL SYSTEMS COMPANY INC')
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.

N109LBMcdonnell Douglas Helicopter 369E · S/N 0455EBuilt 1991 · Destin, FL N132TJPacific Aerospace 750XL · S/N 173Built 2011 · Destin, FL N192VSHughes 369 · S/N 1000786DBuilt 1980 · Destin, FL N194VSHughes 369 · S/N 800-767DDestin, FL N196VSHughes 369 · S/N 900787DBuilt 1980 · Destin, FL N20195Cessna 172M · S/N 17261087Built 1972 · Destin, FL N2502NMil MI-8MTB-1 · S/N 96138Built 1993 · Destin, FL N261VSMD Helicopters 600N · S/N RN061First renewal noticeDestin, FL N266VSMD Helicopters 600N · S/N RN066Built 2002 · Destin, FL N303VSBell 212 · S/N 31303Destin, FL N407FHBell 407 · S/N 53026First renewal noticeDestin, FL N421VSHughes Helicopters HUGHES 369D · S/N 1090592DDestin, FL N500VSHughes Helicopters HUGHES 369D · S/N 170072DBuilt 1977 · Destin, FL N70378Cessna 172M · S/N 17267207Built 1976 · Destin, FL N783NDPiper PA-44-180 · S/N 4496398Built 2016 · Destin, FL N8062ZMil MI-8-MTV-1 · S/N 95458Destin, FL

Back to Vertol Systems Company Inc