OpenAirDocs.org
Geophysical Institute

Registered aircraft · 28

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 = 'GEOPHYSICAL INSTITUTE' OR list_contains(g.other_registrant_names, 'GEOPHYSICAL INSTITUTE')
  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.

N235UAAeromao AEROMAPPER · S/N 0406Fairbanks, AK · Co-owner with University Of Alaska FairbanksN236UAAeromao AEROMAPPER · S/N 0407Fairbanks, AK · Co-owner with University Of Alaska FairbanksN239UANorthern Embedded Solutions LC PTARMIGAN · S/N PTAR 001Fairbanks, AK · Co-owner with University Of Alaska FairbanksN240UANorthern Embedded Solutions LC PTARMIGAN · S/N PTAR 002Fairbanks, AK · Co-owner with University Of Alaska FairbanksN241UANorthern Embedded Solutions LC PTARMIGAN · S/N PTAR 003Fairbanks, AK · Co-owner with University Of Alaska FairbanksN242UANorthern Embedded Solutions LC PTARMIGAN · S/N PTAR 004Fairbanks, AK · Co-owner with University Of Alaska FairbanksN243UANorthern Embedded Solutions LC PTARMIGAN · S/N PTAR 005Fairbanks, AK · Co-owner with University Of Alaska FairbanksN244UAInsitu SCANEAGLE · S/N 09-875Fairbanks, AK · Co-owner with University Of Alaska FairbanksN245UAInsitu SCANEAGLE · S/N 09-876Fairbanks, AK · Co-owner with University Of Alaska FairbanksN246UAInsitu SCANEAGLE · S/N 09-912Fairbanks, AK · Co-owner with University Of Alaska FairbanksN248UAING Robotic RESPONDER · S/N R-004Fairbanks, AK · Co-owner with University Of Alaska FairbanksN249UAING Robotic RESPONDER · S/N R-008Fairbanks, AK · Co-owner with University Of Alaska FairbanksN268UAXag V40 · S/N 8102227311LJFairbanks, AK · Co-owner with University Of Alaska FairbanksN270UADJI MATRICE 30T · S/N 1581F5BKD236500DT784Fairbanks, AK · Co-owner with University Of Alaska FairbanksN271UAFreefly Systems ALTA X · S/N AXA427808Fairbanks, AK · Co-owner with University Of Alaska FairbanksN272UAFreefly Systems ALTA X · S/N AX383482Fairbanks, AK · Co-owner with University Of Alaska FairbanksN301UADRS Technologies SENTRY HP · S/N HP-27Fairbanks, AK · Co-owner with University Of Alaska FairbanksN302UADRS Technologies SENTRY HP · S/N HP-28Fairbanks, AK · Co-owner with University Of Alaska FairbanksN303UADRS Technologies SENTRY HP · S/N HP-30Fairbanks, AK · Co-owner with University Of Alaska FairbanksN304UADRS Technologies SENTRY HP · S/N HP-31Fairbanks, AK · Co-owner with University Of Alaska FairbanksN306UADRS Technologies SENTRY HP · S/N HP-33Fairbanks, AK · Co-owner with University Of Alaska FairbanksN307UADRS Technologies SENTRY HP · S/N HP-35Fairbanks, AK · Co-owner with University Of Alaska FairbanksN309UAAlaska CTR For Unmanned Acft X6A · S/N 21-342-1Fairbanks, AK · Co-owner with University Of Alaska FairbanksN351UAHybrid Project SUPERVOLO GEN 4 · S/N SV4-00-034Fairbanks, AK · Co-owner with University Of Alaska FairbanksN352UAHybrid Project SUPERVOLO GEN 4 · S/N SV4-00-036Fairbanks, AK · Co-owner with University Of Alaska FairbanksN972UASkyfront PERIMETER · S/N SKFP011913Fairbanks, AK · Co-owner with University Of Alaska FairbanksN980UAAutel EVO II · S/N HV6920141601Fairbanks, AK · Co-owner with University Of Alaska FairbanksN981UASkyfront PERIMETER 8 · S/N S080100332006Fairbanks, AK · Co-owner with University Of Alaska Fairbanks
Back to Geophysical Institute