OpenAirDocs.org
Yates Electrospace Corp

Registered aircraft · 24

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 = 'YATES ELECTROSPACE CORP' OR list_contains(g.other_registrant_names, 'YATES ELECTROSPACE CORP')
  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.

N140SAYates Electrospace SILENT ARROW PG BNDL · S/N SA-PGB-00001Aliso Viejo, CAN163SAYates Electrospace SILENT ARROW PG BNDL · S/N SA-PGB-00002Aliso Viejo, CAN227SAYates Electrospace SILENT ARROW PG BNDL · S/N SA-PGB-00003Aliso Viejo, CAN232SAYates Electrospace SILENT ARROW PG BNDL · S/N SA-PGB-00004Aliso Viejo, CAN23SAYates Electrospace SILENT ARROW GD-1000 · S/N SAGD1000-00001Aliso Viejo, CAN240SAYates Electrospace SILENT ARROW PG BNDL · S/N SA-PGB-00005Aliso Viejo, CAN255SAYates Electrospace SILENT ARROW PG BNDL · S/N SA-PGB-00006Aliso Viejo, CAN261SAYates Electrospace SILENT ARROW PG BNDL · S/N SA-PGB-00007Aliso Viejo, CAN266SAYates Electrospace SILENT ARROW PG BNDL · S/N SA-PGB-00008Aliso Viejo, CAN271SAYates Electrospace SILENT ARROW PG BNDL · S/N SA-PGB-00009Aliso Viejo, CAN295SAYates Electrospace SILENT ARROW PG BNDL · S/N SA-PGB-00010Aliso Viejo, CAN416SAYates Electrospace SILENT ARROW PG BNDL · S/N SA-PGB-00011Aliso Viejo, CAN425SAYates Electrospace SILENT ARROW PG BNDL · S/N SA-PGB-00012Aliso Viejo, CAN474SAYates Electrospace SILENT ARROW PG BNDL · S/N SA-PGB-00014Aliso Viejo, CAN815SAYates Electrospace SILENT ARROW CLS-200 · S/N CLS-200-00001Aliso Viejo, CAN820SAYates Electrospace SILENT ARROW CLS-200 · S/N CLS-200-00004Aliso Viejo, CAN823SAYates Electrospace SILENT ARROW CLS-200 · S/N CLS-200-00007Aliso Viejo, CAN824SAYates Electrospace SILENT ARROW CLS-200 · S/N CLS-200-00005Aliso Viejo, CAN830SAYates Electrospace SILENT ARROW CLS-300 · S/N CLS-300-00002Aliso Viejo, CAN831SAYates Electrospace SILENT ARROW CLS-200 · S/N CLS-200-00002Aliso Viejo, CAN834SAYates Electrospace SILENT ARROW CLS-200 · S/N CLS-200-00003Aliso Viejo, CAN835SAYates Electrospace SILENT ARROW CLS-300 · S/N CLS-300-0001Aliso Viejo, CAN836SAYates Electrospace SILENT ARROW CLS-300 · S/N CLS-300-00003Aliso Viejo, CAN837SAYates Electrospace SILENT ARROW CLS-200 · S/N CLS-200-00006Aliso Viejo, CA
Back to Yates Electrospace Corp