OpenAirDocs.org
Training Planes LLC

Registered aircraft · 20

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 = 'TRAINING PLANES LLC' OR list_contains(g.other_registrant_names, 'TRAINING PLANES LLC')
  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.

N102MUCessna 172R · S/N 17280285Built 1997 · Tampa, FLN1302UCessna 172M · S/N 17266994Built 1976 · Tampa, FLN1986HPiper PA-28R-201 · S/N 28R-7737022Tampa, FLN24752Cessna 152 · S/N 15280355Built 1977 · Tampa, FLN3911QCessna 172L · S/N 17260011Built 1971 · Tampa, FLN46134Cessna 152 · S/N 15283003Built 1978 · Tampa, FLN48810Cessna 152 · S/N 15280976Built 1977 · Tampa, FLN5095RCessna 172M · S/N 17263333Built 1974 · Tampa, FLN5120HCessna 152 · S/N 15284063Built 1979 · Tampa, FLN5316RCessna 172RG · S/N 172RG0053Built 1979 · Tampa, FLN588BRCessna 152 · S/N 15281860Tampa, FLN64173Cessna 172M · S/N 17265065Built 1975 · Tampa, FLN64823Cessna 152 · S/N 15281438Tampa, FLN733DNCessna 172N · S/N 17268216Built 1976 · Tampa, FLN759SCessna 172M · S/N 17264166Built 1974 · Tampa, FLN8213LCessna 172H · S/N 17256413Built 1967 · Tampa, FLN87MBPiper PA-34-200 · S/N 34-7250070Built 1972 · Tampa, FLN94500Cessna 152 · S/N 15285692Built 1983 · Tampa, FLN95391Cessna 152 · S/N 15285881Built 1984 · Tampa, FLN970SECessna 152 · S/N 15283609Built 1979 · Tampa, FL
Back to Training Planes LLC