OpenAirDocs.org
Cape Air

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

N120PCCessna 402C · S/N 402C0079Built 1979 · Hyannis, MA · Co-owner with Hyannis Air Service Inc DBAN196CACessna 402C · S/N 402C0116Built 1979 · Hyannis, MA · Co-owner with Hyannis Air Service Inc DBAN205CACessna 402C · S/N 402C0207Built 1979 · Hyannis, MA · Co-owner with Hyannis Air Service Inc DBAN247GSCessna 402C · S/N 402C0637Built 1982 · Hyannis, MA · Co-owner with Hyannis Air Service Inc DBAN258PBCessna 402C · S/N 402C0336Built 1980 · Hyannis, MA · Co-owner with Hyannis Air Service IncN2611XCessna 402C · S/N 402C0072Built 1979 · Hyannis, MA · Co-owner with Hyannis Air Service Inc DBAN267CACessna 402C · S/N 402C0030Built 1979 · Hyannis, MA · Co-owner with Hyannis Air Service Inc DBAN375RCessna 402C · S/N 402C0468Built 1981 · Hyannis, MA · Co-owner with Hyannis Air Service Inc DBAN402HGCessna 402C · S/N 402C1016Built 1985 · Hyannis, MA · Co-owner with Hyannis Air Service Inc DBAN409BKCessna 402C · S/N 402C0651Built 1982 · Hyannis, MA · Co-owner with Hyannis Air Service Inc DBAN466CACessna 402C · S/N 402C0428Built 1980 · Hyannis, MA · Co-owner with Hyannis Air Service Inc DBAN510BNPilatus Britten-Norman BN2B-20 · S/N 2239Built 1991 · Hyannis, MA · Co-owner with Hyannis Air Service Inc DBAN520BNPilatus Britten-Norman BN2B-20 · S/N 2240Built 1991 · Hyannis, MA · Co-owner with Hyannis Air Service IncN524CACessna 402C · S/N 402C0522Built 1981 · Hyannis, MA · Co-owner with Hyannis Air Service Inc DBAN530BNPilatus Britten-Norman BN2B-20 · S/N 2209Built 1989 · Hyannis, MA · Co-owner with Hyannis Air Service DBAN540BNPilatus Britten-Norman BN2B-20 · S/N 2207Built 1990 · Hyannis, MA · Co-owner with Hyannis Air Service Inc D/B/AN57PBCessna 402C · S/N 402C0300Built 1980 · Hyannis, MA · Co-owner with Hyannis Air Service Inc DBAN67886Cessna 402C · S/N 402C0435Built 1980 · Hyannis, MA · Co-owner with Hyannis Air Service Inc DBAN678JGCessna 402C · S/N 402C0266Hyannis, MA · Co-owner with Hyannis Air Service Inc DBAN67909Cessna 402C · S/N 402C0449Built 1981 · Hyannis, MA · Co-owner with Hyannis Air Service Inc DBAN6813JCessna 402C · S/N 402C0641Hyannis, MA · Co-owner with Hyannis Air Service Inc DBAN68391Cessna 402C · S/N 402C0483Built 1981 · Hyannis, MA · Co-owner with Hyannis Air Service Inc DBAN7037ECessna 402C · S/N 402C0471Built 1981 · Hyannis, MA · Co-owner with Hyannis Air Service IncN706CACessna 402C · S/N 402C0095Built 1979 · Hyannis, MA · Co-owner with Hyannis Air Service Inc DBAN83PBCessna 402C · S/N 402C0350Built 1980 · Hyannis, MA · Co-owner with Hyannis Air Service Inc DBAN890CACessna 402C · S/N 402C0006Built 1978 · Hyannis, MA · Co-owner with Hyannis Air Service Inc DBAN903CACessna 402C · S/N 402C0047Built 1979 · Hyannis, MA · Co-owner with Hyannis Air Service Inc DBAN991AACessna 402C · S/N 402C0317Built 1980 · Hyannis, MA · Co-owner with Hyannis Air Service Inc DBA
Back to Cape Air