OpenAirDocs.org
Arctic One LLC

Registered aircraft · 17

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

N146QTBritish Aerospace BAE 146-300 · S/N E3168Fairbanks, AKN208CECessna 208B · S/N 208B0466Built 1995 · Fairbanks, AKN246QTBritish Aerospace BAE 146-300 · S/N E3182Built 1990 · Fairbanks, AKN346QTBritish Aerospace BAE 146-300 · S/N E3186Fairbanks, AKN408RETextron 408 · S/N 408-0022Built 2023 · Fairbanks, AKN482AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49675Built 1988 · Fairbanks, AKN483AMcdonnell Douglas DC-9-82(MD-82) · S/N 49676Built 1988 · Fairbanks, AKN575JDCessna 208B · S/N 208B0595Built 1997 · Fairbanks, AKN777CQPilatus PC-12/47 · S/N 754Fairbanks, AKN961CEMcdonnell Douglas DC-9-82(MD-82) · S/N 49470Built 1987 · Fairbanks, AKN962CEMcdonnell Douglas MD 83 · S/N 53471Built 1996 · Fairbanks, AKN963CEMcdonnell Douglas DC-9-83(MD-83) · S/N 53450Built 1994 · Fairbanks, AKN964CEMcdonnell Douglas DC-9-83(MD-83) · S/N 53078Built 1992 · Fairbanks, AKN965CEMcdonnell Douglas DC-9-83(MD-83) · S/N 53079Built 1992 · Fairbanks, AKN966CEMcdonnell Douglas MD-88 · S/N 53266Built 1991 · Fairbanks, AKN967CEMcdonnell Douglas DC-9-83(MD-83) · S/N 49855Built 1996 · Fairbanks, AKN994DLMcdonnell Douglas MD-88 · S/N 53346Fairbanks, AK
Back to Arctic One LLC