OpenAirDocs.org
Alliance Aviation Group LLC

Registered aircraft · 34

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 = 'ALLIANCE AVIATION GROUP LLC' OR list_contains(g.other_registrant_names, 'ALLIANCE AVIATION GROUP 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.

N104EJRaytheon HAWKER 800XP · S/N 258505Built 2000 · Wilmington, DEN110SNGulfstream Aerospace G-IV · S/N 1208Built 1992 · Wilmington, DEN127GKGulfstream Aerospace G-1159A · S/N 311Wilmington, DEN171JCGulfstream Aerospace G-IV · S/N 1222Built 1993 · Wilmington, DEN188SAGulfstream Aerospace G-IV · S/N 1150Built 1990 · Wilmington, DEN225JDIsrael Aircraft Industries GULFSTREAM 200 · S/N 028Built 2000 · Wilmington, DEN238LMLearjet 45 · S/N 039Built 1999 · Providence, RI · Co-owner with Bcp Fa Ap LLCN259RHRaytheon HAWKER 800XP · S/N 258529Built 2001 · Wilmington, DEN26NJDassault FALCON 2000 · S/N 139Built 2001 · Wilmington, DEN305TCGulfstream Aerospace G-IV · S/N 1116Built 1989 · Wilmington, DEN311FLRaytheon HAWKER 800XP · S/N 258338Built 1997 · Wilmington, DEN320EJRaytheon HAWKER 800XP · S/N 258523Built 2001 · Wilmington, DEN356EJRaytheon HAWKER 800XP · S/N 258452Built 1999 · Wilmington, DEN412GJRaytheon 400A · S/N RK-412Wilmington, DEN418GJRaytheon 400A · S/N RK-418Wilmington, DEN455WGGulfstream Aerospace G-IV · S/N 1205Built 1992 · Wilmington, DEN472GJRaytheon 400A · S/N RK-481Wilmington, DEN477TMHawker Beechcraft 400A · S/N RK-519Built 2007 · Wilmington, DEN48WGBombardier BD-700-1A10 · S/N 9148Built 2004 · Wilmington, DEN492TMHawker Beechcraft 400A · S/N RK-580Wilmington, DEN502UPCessna 560XL · S/N 560-5310Built 2003 · Wilmington, DEN53WGGulfstream Aerospace G-IV · S/N 1505Built 2003 · Lawrence, KSN543WGCessna 560XL · S/N 560-5243Wilmington, DEN546DDLearjet 45 · S/N 150Built 2001 · Wilmington, DEN56WZCessna 560XL · S/N 560-5156Built 2001 · Wilmington, DEN604SNCessna 560XL · S/N 560-5181Built 2001 · Wilmington, DEN607BFLearjet 45 · S/N 016Built 1999 · Wilmington, DEN615KZRaytheon 400A · S/N RK-490Built 2006 · Wilmington, DEN70THCessna 560XL · S/N 560-5007Built 1998 · Wilmington, DEN72FCRaytheon HAWKER 800XP · S/N 258519Built 2001 · Wilmington, DEN802TDCessna 560XL · S/N 560-5153Built 2001 · Wilmington, DEN816LJLearjet 45 · S/N 011Built 1998 · Wilmington, DEN920EJRaytheon HAWKER 800XP · S/N 258705Built 2005 · Wilmington, DEN9TEDassault MYSTERE-FALCON 50 · S/N 204Built 1991 · Wilmington, DE
Back to Alliance Aviation Group LLC