OpenAirDocs.org
Hyannis, MA

Registered aircraft · 103

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

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_state = 'MA' AND g.registrant_city = 'HYANNIS'
  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.

N106CACessna 402C · S/N 402C1020Built 1985 · Hyannis Air Service IncN119PACessna 402B · S/N 402B0610Ricciardi Brian PN120PCCessna 402C · S/N 402C0079Built 1979 · Hyannis Air Service Inc DBAN133CACostruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 003/USBuilt 2019 · Hyannis Air Service IncN135CACostruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 034/USBuilt 2021 · Hyannis Air Service IncN160PBCessna 402C · S/N 402C0493Built 1981 · Hyannis Air Service IncN196CACessna 402C · S/N 402C0116Built 1979 · Hyannis Air Service Inc DBAN205CACessna 402C · S/N 402C0207Built 1979 · Hyannis Air Service Inc DBAN223PBCessna 402C · S/N 402C0105Built 1979 · Hyannis Air Service IncN244CACostruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 004/USHyannis Air Service IncN247GSCessna 402C · S/N 402C0637Built 1982 · Hyannis Air Service Inc DBAN255CACostruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 005/USBuilt 2019 · Hyannis Air Service IncN256CACessna 402C · S/N 402C0606Hyannis Air Service IncN258PBCessna 402C · S/N 402C0336Built 1980 · Hyannis Air Service IncN2611XCessna 402C · S/N 402C0072Built 1979 · Hyannis Air Service Inc DBAN26156Cessna 402C · S/N 402C0112Built 1979 · Hyannis Air Service IncN2615GCessna 402C · S/N 402C0101Built 1979 · Hyannis Air Service Inc DBAN2649ZCessna 402C · S/N 402C0333Built 1980 · Hyannis Air Service IncN26514Cessna 402C · S/N 402C0344Built 1980 · Hyannis Air Service IncN2651SCessna 402C · S/N 402C0342Built 1980 · Hyannis Air Service IncN266CACostruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 006/USBuilt 2019 · Hyannis Air Service IncN267CACessna 402C · S/N 402C0030Built 1979 · Hyannis Air Service Inc DBAN288CACostruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 007/USBuilt 2019 · Hyannis Air Service IncN290CACessna 402C · S/N 402C0297Built 1980 · Hyannis Air Service IncN318BXCirrus Design SR22 · S/N 3833Built 2012 · Longshore Aviation LLCN3249MCessna 402C · S/N 402C0296Hyannis Air Service IncN3292MCessna 402C · S/N 402C0304Hyannis Air Service IncN335CACostruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 035/USBuilt 2021 · Hyannis Air Service IncN345CACostruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 036/USBuilt 2021 · Hyannis Air Service IncN357CACostruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 037/USBuilt 2021 · Hyannis Air Service IncN36911Cessna 402C · S/N 402C0314Built 1980 · Hyannis Air Service IncN375RCessna 402C · S/N 402C0468Built 1981 · Hyannis Air Service Inc DBAN385CACessna 402C · S/N 402C0111Built 1979 · Hyannis Air Service IncN396CACostruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 040/USBuilt 2021 · Hyannis Air Service IncN401SXCessna 402C · S/N 402C0447Hyannis Air Service IncN401TJCessna 402C · S/N 402C0109Built 1979 · Hyannis Air Service IncN402HGCessna 402C · S/N 402C1016Built 1985 · Hyannis Air Service Inc DBAN402VNCessna 402C · S/N 402C0488Built 1981 · Hyannis Air Service IncN406GACessna 402C · S/N 402C0329Built 1980 · Hyannis Air Service IncN409BKCessna 402C · S/N 402C0651Built 1982 · Hyannis Air Service Inc DBAN411CACostruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 008/USBuilt 2019 · Hyannis Air Service IncN443CACostruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 031/USBuilt 2021 · Hyannis Air Service IncN44583Piper PA-28-151 · S/N 28-7415674Built 1974 · Griffin Avionics IncN4630NCessna 402C · S/N 402C0001Built 1978 · Hyannis Air Service IncN466CACessna 402C · S/N 402C0428Built 1980 · Hyannis Air Service Inc DBAN494BCCessna 402C · S/N 402C0308Hyannis Air Service IncN499CACessna 402C · S/N 402C1006Built 1985 · Hyannis Air Service IncN508CACostruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 038/USBuilt 2021 · Hyannis Air Service IncN50976Cessna 172P · S/N 17274243Cape Aviation Services LLCN510BNPilatus Britten-Norman BN2B-20 · S/N 2239Built 1991 · Hyannis Air Service Inc DBA
Back to Hyannis, MA