OpenAirDocs.org
Top Aces Corp

Registered aircraft · 32

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 = 'TOP ACES CORP' OR list_contains(g.other_registrant_names, 'TOP ACES 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.

N481TADassault-Breguet/Dornier ALPHA JET MODEL A · S/N 040Mesa, AZN482TADassault-Breguet/Dornier ALPHA JET MODEL A · S/N 069Mesa, AZN483TADassault-Breguet/Dornier ALPHA JET MODEL A · S/N 057Mesa, AZN847TALockheed Martin F-16B · S/N 78-0362Built 1978 · Mesa, AZN848TALockheed Martin F-16B · S/N 78-0358Mesa, AZN849TAGeneral Dynamics F-16A · S/N 78-0357Mesa, AZN852TALockheed Martin F-16B · S/N 78-0360Built 1978 · Mesa, AZN853TAGeneral Dynamics F-16A · S/N 78-0355Mesa, AZN854TALockheed Martin F-16A · S/N 78-0322Built 1978 · Mesa, AZN856TALockheed Martin F-16A · S/N 78-0335Built 1978 · Mesa, AZN857TALockheed Martin F-16A · S/N 78-0327Built 1978 · Mesa, AZN858TALockheed Martin F-16A · S/N 78-0352Built 1978 · Mesa, AZN859TALockheed Martin F-16A · S/N 78-0315Built 1978 · Mesa, AZN860TALockheed Martin F-16A · S/N 78-0346Built 1978 · Mesa, AZN861TALockheed Martin F-16A · S/N 78-0326Built 1978 · Mesa, AZN862TAGeneral Dynamics F-16A · S/N 78-0312Built 1978 · Mesa, AZN865TALockheed Martin F-16A · S/N 80-0662Built 1980 · Mesa, AZN866TALockheed Martin F-16A · S/N 80-0666Mesa, AZN868TAGeneral Dynamics F-16A · S/N 80-0659Mesa, AZN870TAGeneral Dynamics F-16A · S/N 78-0353Mesa, AZN871TAGeneral Dynamics F-16A · S/N 80-0661Built 1980 · Mesa, AZN872TAGeneral Dynamics F-16A · S/N 80-0665Mesa, AZN873TAGeneral Dynamics F-16A · S/N 78-0321Mesa, AZN875TAGeneral Dynamics F-16A · S/N 80-0653Built 1980 · Mesa, AZN876TALockheed Martin F-16A · S/N 78-0320Mesa, AZN877TAGeneral Dynamics F-16A · S/N 80-0663Mesa, AZN878TAGeneral Dynamics F-16A · S/N 78-0308Mesa, AZN879TAGeneral Dynamics F-16A · S/N 78-0336Mesa, AZN882TAGeneral Dynamics F-16A · S/N 78-0334Mesa, AZN883TAGeneral Dynamics F-16A · S/N 78-0313Mesa, AZN885TALockheed Martin F-16A · S/N 78-0341Mesa, AZN886TALockheed Martin F-16A · S/N 78-0347Mesa, AZ
Back to Top Aces Corp