OpenAirDocs.org
Corpat Inc

Registered aircraft · 19

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

N125TTAirbus Helicopters MBB-BK117 D-3 · S/N 21329Missoula, MTN19WGBell 206 · S/N 162821Missoula, MTN212HPBell 212 · S/N 30951Built 1979 · Missoula, MTN22WGCessna P210N · S/N P21000733Built 1981 · Missoula, MTN27WLSikorsky UH-60A · S/N 83-23845Missoula, MTN39MTHelicopteres Guimbal CABRI G2 · S/N 1411Missoula, MTN401GHSikorsky UH-60L · S/N 85-24401Built 1985 · Missoula, MTN43WLAirbus Helicopters MBB-BK117 D-3 · S/N 21383Built 2025 · Missoula, MTN61WLEurocopter AS 350 B3 · S/N 7752Built 2013 · Missoula, MTN63WLAirbus Helicopters Deutschland MBB-BK117 D-3 · S/N 21201Built 2023 · Missoula, MTN74WLAirbus Helicopters AS 350B3 · S/N 8763Built 2019 · Missoula, MTN82WLPickering UH-60A · S/N 80-23484Built 1980 · Missoula, MTN83WLSikorsky UH-60A · S/N 87-24600Built 1987 · Missoula, MTN84WLSikorsky UH-60L · S/N 84-23961Built 1984 · Missoula, MTN869AWEclipse EA500 · S/N 000233Built 2008 · Missoula, MTN86WLSikorsky UH-60L · S/N 83-23906Built 1983 · Missoula, MTN87WLSikorsky UH-60L · S/N 87-24629Built 1987 · Missoula, MTN89WLSikorsky UH-60L · S/N 83-23888Built 1983 · Missoula, MTN99WLBell 205A-1 · S/N 30086Built 1970 · Missoula, MT
Back to Corpat Inc