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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N1068KRaytheon C90A · S/N LJ-1448N1076KRaytheon C90A · S/N LJ-1461N1079DRaytheon C90A · S/N LJ-1462N1083SRaytheon C90A · S/N LJ-1443N124UVPilatus PC-12 · S/N 124N12531Cessna 172M · S/N 17262046N129TNRaytheon C90A · S/N LJ-1742N13GZRaytheon C90A · S/N LJ-1590N145XLLearjet 45 · S/N 106N147LJRaytheon C90A · S/N LJ-1476N1544VBeech C90A · S/N LJ-1366N170SERaytheon C90A · S/N LJ-1708N199CGRaytheon C90A · S/N LJ-1661N203DHRaytheon B200 · S/N BB-1845First renewal noticeN211VMPiper PA-28R-201 · S/N 2837030N212PBPilatus PC-12/45 · S/N 212N238VMPilatus PC-12/45 · S/N 238N2486UPiper PA-34-200T · S/N 34-7970446N266RDRaytheon C90A · S/N LJ-1633N273SMPilatus PC-12/45 · S/N 475N299RPRaytheon C90A · S/N LJ-1537N311VMPilatus PC-12/45 · S/N 619N3221MRaytheon C90A · S/N LJ-1621N3263NRaytheon C90A · S/N LJ-1563N348PCPilatus PC-12/45 · S/N 348N351SABeech B200 · S/N BB1423N35HDRaytheon C90A · S/N LJ-1731N377LPilatus PC-12/45 · S/N 346N378HHPilatus PC-12/45 · S/N 378N385MHLearjet 45 · S/N 346N392WCPilatus PC-12/45 · S/N 392N399WSRaytheon C90A · S/N LJ-1547N400EMRaytheon C90A · S/N LJ-1601N411WABeech B200 · S/N BB-1294N412CUPilatus PC-12/45 · S/N 469N435DCLearjet 45 · S/N 249N447DBRaytheon C90A · S/N LJ-1656N456VPilatus PC-12/45 · S/N 201N477PTRaytheon C90A · S/N LJ-1600N485JRCessna 208 · S/N 20800264N53ARRaytheon B200 · S/N BB-1629N597PRaytheon C90A · S/N LJ-1597N5DMPilatus PC-12/45 · S/N 355N607FJRaytheon B200 · S/N BB-1963N60VPRaytheon C90A · S/N LJ-1516N61GNBeech C90A · S/N LJ-1421N6728HBeech B200 · S/N BB-1193N68MNRaytheon B200 · S/N BB-1962N692WRaytheon C90A · S/N LJ-1692N734CBRaytheon C90A · S/N LJ-1508
Back to Guardian Flight LLC