Guardian Flight LLC

Registered aircraft · 66

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

N1068KRaytheon C90A · S/N LJ-1448Built 1996 · Lewisville, TXN1076KRaytheon C90A · S/N LJ-1461Built 1996 · Lewisville, TXN1079DRaytheon C90A · S/N LJ-1462Built 1996 · Lewisville, TXN1083SRaytheon C90A · S/N LJ-1443Built 1996 · Lewisville, TXN124UVPilatus PC-12 · S/N 124Lewisville, TXN12531Cessna 172M · S/N 17262046Built 1973 · South Jordan, UTN129TNRaytheon C90A · S/N LJ-1742Built 2005 · Lewisville, TXN13GZRaytheon C90A · S/N LJ-1590Built 2000 · South Jordan, UTN145XLLearjet 45 · S/N 106Built 2000 · Lewisville, TXN147LJRaytheon C90A · S/N LJ-1476Lewisville, TXN1544VBeech C90A · S/N LJ-1366Built 1994 · Lewisville, TXN170SERaytheon C90A · S/N LJ-1708Built 2004 · Lewisville, TXN199CGRaytheon C90A · S/N LJ-1661Built 2002 · Lewisville, TXN203DHRaytheon B200 · S/N BB-1845First renewal noticeLewisville, TXN211VMPiper PA-28R-201 · S/N 2837030Built 1989 · South Jordan, UTN212PBPilatus PC-12/45 · S/N 212Lewisville, TXN238VMPilatus PC-12/45 · S/N 238Built 1998 · Lewisville, TXN2486UPiper PA-34-200T · S/N 34-7970446South Jordan, UTN266RDRaytheon C90A · S/N LJ-1633Built 2001 · Lewisville, TXN273SMPilatus PC-12/45 · S/N 475Built 2002 · South Jordan, UTN299RPRaytheon C90A · S/N LJ-1537Built 1996 · Lewisville, TXN311VMPilatus PC-12/45 · S/N 619Lewisville, TXN3221MRaytheon C90A · S/N LJ-1621Built 2000 · Lewisville, TXN3263NRaytheon C90A · S/N LJ-1563Built 1999 · Lewisville, TXN348PCPilatus PC-12/45 · S/N 348Lewisville, TXN351SABeech B200 · S/N BB1423Built 1992 · Lewisville, TXN35HDRaytheon C90A · S/N LJ-1731Lewisville, TXN377LPilatus PC-12/45 · S/N 346Built 2000 · Lewisville, TXN378HHPilatus PC-12/45 · S/N 378Built 2001 · Lewisville, TXN385MHLearjet 45 · S/N 346Built 2007 · Lewisville, TXN392WCPilatus PC-12/45 · S/N 392Lewisville, TXN399WSRaytheon C90A · S/N LJ-1547Built 1999 · Lewisville, TXN400EMRaytheon C90A · S/N LJ-1601Built 2000 · Lewisville, TXN411WABeech B200 · S/N BB-1294Built 1988 · Lewisville, TXN412CUPilatus PC-12/45 · S/N 469Built 2002 · Lewisville, TXN435DCLearjet 45 · S/N 249Built 2004 · Lewisville, TXN447DBRaytheon C90A · S/N LJ-1656Built 2001 · Lewisville, TXN456VPilatus PC-12/45 · S/N 201Built 1997 · Lewisville, TXN477PTRaytheon C90A · S/N LJ-1600Built 2000 · Lewisville, TXN485JRCessna 208 · S/N 20800264Built 1997 · Lewisville, TXN53ARRaytheon B200 · S/N BB-1629Built 1998 · Lewisville, TXN597PRaytheon C90A · S/N LJ-1597Built 2000 · Lewisville, TXN5DMPilatus PC-12/45 · S/N 355Built 2000 · Lewisville, TXN607FJRaytheon B200 · S/N BB-1963Built 2006 · Lewisville, TXN60VPRaytheon C90A · S/N LJ-1516Built 1998 · Lewisville, TXN61GNBeech C90A · S/N LJ-1421Lewisville, TXN6728HBeech B200 · S/N BB-1193Built 1984 · Lewisville, TXN68MNRaytheon B200 · S/N BB-1962Built 2006 · Lewisville, TXN692WRaytheon C90A · S/N LJ-1692Built 2003 · Lewisville, TXN734CBRaytheon C90A · S/N LJ-1508Built 1998 · Lewisville, TX
Back to Guardian Flight LLC