OpenAirDocs.org
Cp Aviation Inc

Registered aircraft · 16

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

N1603GChampion 7ECA · S/N 609Built 1968 · Santa Paula, CAN172EPCessna 172N · S/N 17267932Built 1976 · Santa Paula, CAN21YCessna 180 · S/N 30837Built 1954 · Santa Paula, CAN30184Cessna 172M · S/N 17264125Built 1974 · Santa Paula, CAN3946Boeing A75N1(PT17) · S/N 75-1910Built 1942 · Santa Paula, CAN5035NBellanca 8KCAB · S/N 470-79Built 1978 · Santa Paula, CAN5443LCessna 152 · S/N 15284315Built 1980 · Santa Paula, CAN5503HBellanca 8KCAB · S/N 413-78Built 1978 · Santa Paula, CAN57404Bellanca 7ECA · S/N 940-73Built 1973 · Santa Paula, CAN6900HPiper J3C-65 · S/N 20129Built 1946 · Santa Paula, CAN704UTCessna 150M · S/N 15078891Built 1976 · Santa Paula, CAN714JPCessna 150G · S/N 15065030Built 1966 · Santa Paula, CAN747PPCessna R182 · S/N R18201587Built 1980 · Santa Paula, CAN80914Cessna 172M · S/N 17266799Built 1976 · Santa Paula, CAN989WBAmerican Champion 8KCAB · S/N 1120-2012Built 2012 · Santa Paula, CAN99JPPitts Aerobatics S-2B · S/N 5101Santa Paula, CA
Back to Cp Aviation Inc