# Registered aircraft: Hyannis, MA A list on [Hyannis, MA](https://openairdocs.org/faa-place/MA/Hyannis.md). Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses. Page 1 of 3 · 103 aircraft - [N106CA](https://openairdocs.org/aircraft/N106CA.md): Cessna 402C · S/N 402C1020 · Built 1985 · Hyannis Air Service Inc - [N119PA](https://openairdocs.org/aircraft/N119PA.md): Cessna 402B · S/N 402B0610 · Ricciardi Brian P - [N120PC](https://openairdocs.org/aircraft/N120PC.md): Cessna 402C · S/N 402C0079 · Built 1979 · Hyannis Air Service Inc DBA - [N133CA](https://openairdocs.org/aircraft/N133CA.md): Costruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 003/US · Built 2019 · Hyannis Air Service Inc - [N135CA](https://openairdocs.org/aircraft/N135CA.md): Costruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 034/US · Built 2021 · Hyannis Air Service Inc - [N160PB](https://openairdocs.org/aircraft/N160PB.md): Cessna 402C · S/N 402C0493 · Built 1981 · Hyannis Air Service Inc - [N196CA](https://openairdocs.org/aircraft/N196CA.md): Cessna 402C · S/N 402C0116 · Built 1979 · Hyannis Air Service Inc DBA - [N205CA](https://openairdocs.org/aircraft/N205CA.md): Cessna 402C · S/N 402C0207 · Built 1979 · Hyannis Air Service Inc DBA - [N223PB](https://openairdocs.org/aircraft/N223PB.md): Cessna 402C · S/N 402C0105 · Built 1979 · Hyannis Air Service Inc - [N244CA](https://openairdocs.org/aircraft/N244CA.md): Costruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 004/US · Hyannis Air Service Inc - [N247GS](https://openairdocs.org/aircraft/N247GS.md): Cessna 402C · S/N 402C0637 · Built 1982 · Hyannis Air Service Inc DBA - [N255CA](https://openairdocs.org/aircraft/N255CA.md): Costruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 005/US · Built 2019 · Hyannis Air Service Inc - [N256CA](https://openairdocs.org/aircraft/N256CA.md): Cessna 402C · S/N 402C0606 · Hyannis Air Service Inc - [N258PB](https://openairdocs.org/aircraft/N258PB.md): Cessna 402C · S/N 402C0336 · Built 1980 · Hyannis Air Service Inc - [N2611X](https://openairdocs.org/aircraft/N2611X.md): Cessna 402C · S/N 402C0072 · Built 1979 · Hyannis Air Service Inc DBA - [N26156](https://openairdocs.org/aircraft/N26156.md): Cessna 402C · S/N 402C0112 · Built 1979 · Hyannis Air Service Inc - [N2615G](https://openairdocs.org/aircraft/N2615G.md): Cessna 402C · S/N 402C0101 · Built 1979 · Hyannis Air Service Inc DBA - [N2649Z](https://openairdocs.org/aircraft/N2649Z.md): Cessna 402C · S/N 402C0333 · Built 1980 · Hyannis Air Service Inc - [N26514](https://openairdocs.org/aircraft/N26514.md): Cessna 402C · S/N 402C0344 · Built 1980 · Hyannis Air Service Inc - [N2651S](https://openairdocs.org/aircraft/N2651S.md): Cessna 402C · S/N 402C0342 · Built 1980 · Hyannis Air Service Inc - [N266CA](https://openairdocs.org/aircraft/N266CA.md): Costruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 006/US · Built 2019 · Hyannis Air Service Inc - [N267CA](https://openairdocs.org/aircraft/N267CA.md): Cessna 402C · S/N 402C0030 · Built 1979 · Hyannis Air Service Inc DBA - [N288CA](https://openairdocs.org/aircraft/N288CA.md): Costruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 007/US · Built 2019 · Hyannis Air Service Inc - [N290CA](https://openairdocs.org/aircraft/N290CA.md): Cessna 402C · S/N 402C0297 · Built 1980 · Hyannis Air Service Inc - [N318BX](https://openairdocs.org/aircraft/N318BX.md): Cirrus Design SR22 · S/N 3833 · Built 2012 · Longshore Aviation LLC - [N3249M](https://openairdocs.org/aircraft/N3249M.md): Cessna 402C · S/N 402C0296 · Hyannis Air Service Inc - [N3292M](https://openairdocs.org/aircraft/N3292M.md): Cessna 402C · S/N 402C0304 · Hyannis Air Service Inc - [N335CA](https://openairdocs.org/aircraft/N335CA.md): Costruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 035/US · Built 2021 · Hyannis Air Service Inc - [N345CA](https://openairdocs.org/aircraft/N345CA.md): Costruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 036/US · Built 2021 · Hyannis Air Service Inc - [N357CA](https://openairdocs.org/aircraft/N357CA.md): Costruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 037/US · Built 2021 · Hyannis Air Service Inc - [N36911](https://openairdocs.org/aircraft/N36911.md): Cessna 402C · S/N 402C0314 · Built 1980 · Hyannis Air Service Inc - [N375R](https://openairdocs.org/aircraft/N375R.md): Cessna 402C · S/N 402C0468 · Built 1981 · Hyannis Air Service Inc DBA - [N385CA](https://openairdocs.org/aircraft/N385CA.md): Cessna 402C · S/N 402C0111 · Built 1979 · Hyannis Air Service Inc - [N396CA](https://openairdocs.org/aircraft/N396CA.md): Costruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 040/US · Built 2021 · Hyannis Air Service Inc - [N401SX](https://openairdocs.org/aircraft/N401SX.md): Cessna 402C · S/N 402C0447 · Hyannis Air Service Inc - [N401TJ](https://openairdocs.org/aircraft/N401TJ.md): Cessna 402C · S/N 402C0109 · Built 1979 · Hyannis Air Service Inc - [N402HG](https://openairdocs.org/aircraft/N402HG.md): Cessna 402C · S/N 402C1016 · Built 1985 · Hyannis Air Service Inc DBA - [N402VN](https://openairdocs.org/aircraft/N402VN.md): Cessna 402C · S/N 402C0488 · Built 1981 · Hyannis Air Service Inc - [N406GA](https://openairdocs.org/aircraft/N406GA.md): Cessna 402C · S/N 402C0329 · Built 1980 · Hyannis Air Service Inc - [N409BK](https://openairdocs.org/aircraft/N409BK.md): Cessna 402C · S/N 402C0651 · Built 1982 · Hyannis Air Service Inc DBA - [N411CA](https://openairdocs.org/aircraft/N411CA.md): Costruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 008/US · Built 2019 · Hyannis Air Service Inc - [N443CA](https://openairdocs.org/aircraft/N443CA.md): Costruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 031/US · Built 2021 · Hyannis Air Service Inc - [N44583](https://openairdocs.org/aircraft/N44583.md): Piper PA-28-151 · S/N 28-7415674 · Built 1974 · Griffin Avionics Inc - [N4630N](https://openairdocs.org/aircraft/N4630N.md): Cessna 402C · S/N 402C0001 · Built 1978 · Hyannis Air Service Inc - [N466CA](https://openairdocs.org/aircraft/N466CA.md): Cessna 402C · S/N 402C0428 · Built 1980 · Hyannis Air Service Inc DBA - [N494BC](https://openairdocs.org/aircraft/N494BC.md): Cessna 402C · S/N 402C0308 · Hyannis Air Service Inc - [N499CA](https://openairdocs.org/aircraft/N499CA.md): Cessna 402C · S/N 402C1006 · Built 1985 · Hyannis Air Service Inc - [N508CA](https://openairdocs.org/aircraft/N508CA.md): Costruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 038/US · Built 2021 · Hyannis Air Service Inc - [N50976](https://openairdocs.org/aircraft/N50976.md): Cessna 172P · S/N 17274243 · Cape Aviation Services LLC - [N510BN](https://openairdocs.org/aircraft/N510BN.md): Pilatus Britten-Norman BN2B-20 · S/N 2239 · Built 1991 · Hyannis Air Service Inc DBA Next page: https://openairdocs.org/faa-place/MA/Hyannis/aircraft.md?page=2 ## The whole list in SQL Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS: ```sql 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 ``` This list as a web page: https://openairdocs.org/faa-place/MA/Hyannis/aircraft --- OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.