OpenAirDocs.org
Team Aero LLC

Registered aircraft · 27

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 = 'TEAM AERO LLC' OR list_contains(g.other_registrant_names, 'TEAM AERO 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.

N106VPCessna 560 · S/N 560-0628Built 2002 · Shawnee, KSN138TAIsrael Aircraft Industries GULFSTREAM 200 · S/N 134Shawnee, KSN161PBCanadair CL-601-3A · S/N 5069Olathe, KSN171TACessna 550 · S/N 550-0951Built 2000 · Shawnee, KSN197ECLearjet 45 · S/N 197Shawnee, KSN2286DLearjet 45 · S/N 2091Shawnee, KSN247CSRockwell International NA-265-65 · S/N 465-27Built 1994 · Shawnee, KSN269JASchweizer 269C · S/N S1914Built 2008 · Shawnee, KSN319PMRaytheon G36 · S/N E-3695Shawnee, KSN430TACessna 560 · S/N 560-0533Olathe, KSN440TARaytheon 400A · S/N RK-353Shawnee, KSN45RKBeech 400A · S/N RK-43Shawnee, KSN475CWCessna 560XL · S/N 560-5080Built 2000 · Shawnee, KSN509DMHawker Beechcraft BAE 125-800B · S/N 258056Shawnee, KSN535PSLearjet 31A · S/N 087Built 1999 · Olathe, KSN54TACessna 560XL · S/N 560-5128Shawnee, KSN564TACessna 560XL · S/N 560-5249Shawnee, KSN605SBLearjet 60 · S/N 156Built 1999 · Olathe, KSN650CZCessna 650 · S/N 650-7050Built 1995 · Shawnee, KSN702SMCessna 650 · S/N 650-0135Olathe, KSN752JCDassault-Breguet FALCON 50 · S/N 28Built 1980 · Shawnee, KSN888UPRockwell International NA-265-65 · S/N 465-68Built 1981 · Shawnee, KSN894NTCessna 550 · S/N 550-0827Olathe, KSN903TACessna 750 · S/N 750-0162Built 2001 · Olathe, KSN911GUIsrael Aircraft Industries 1124A · S/N 343Built 1981 · Olathe, KSN954SGDassault-Breguet FALCON 50 · S/N 54Built 1981 · Olathe, KSN964VRCessna 750 · S/N 750-0164Built 2001 · Shawnee, KS
Back to Team Aero LLC