OpenAirDocs.org
Hyannis, MA

Cancelled registrations · 44

Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
  WHERE d.registrant_state = 'MA' AND d.registrant_city = 'HYANNIS'
  ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"

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.

N26632Cessna 402C · S/N 402C0404Cancelled Nov 15, 2025 · Built 1980 · Hyannis Air Service Inc DBAN18VVCessna 402C · S/N 402C0619Cancelled Dec 21, 2024 · Built 1981 · Hyannis Air Service IncN762EACessna 402C · S/N 402C0061Cancelled Dec 11, 2023 · Hyannis Air Service IncN121PBCessna 402C · S/N 402C0507Cancelled Dec 10, 2023 · Built 1981 · Hyannis Air Services Inc DBAN300SNCessna 402C · S/N 402C0060Cancelled Aug 18, 2023 · Built 1979 · Hyannis Air Service IncN2714MCessna 402C · S/N 402C0211Cancelled May 27, 2023 · Built 1979 · Hyannis Air Service IncN525RHCessna 402C · S/N 402C0525Cancelled May 27, 2023 · Hyannis Air Service IncN2714BCessna 402C · S/N 402C0210Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Hyannis Air Service IncN88833Cessna 402C · S/N 402C0265Cancelled Apr 8, 2022 · Built 1980 · Hyannis Air Service IncN2748YCessna 402C · S/N 402C0248Cancelled Apr 17, 2021 · Built 1979 · Hyannis Air Service IncN4652NCessna 402C · S/N 402C0011Cancelled Apr 17, 2021 · Built 1978 · Hyannis Air Service IncN161TACessna 402C · S/N 402C0070Cancelled Jul 13, 2020 · Built 1979 · Hyannis Air Service IncN69SCCessna 402C · S/N 402C0041Cancelled Jun 2, 2020 · Built 1979 · Hyannis Air Service Inc DBAN1376GCessna 402C · S/N 402C0271Cancelled May 29, 2020 · Built 1980 · Hyannis Air Service IncN1361GCessna 402C · S/N 402C0270Cancelled May 22, 2020 · Built 1980 · Hyannis Air Service IncN404SXCessna 402C · S/N 402C-0280Cancelled May 28, 2019 · First renewal notice · Hyannis Air Service IncN2079VCessna 120 · S/N 14313Cancelled May 4, 2019 · Revoked, pending cancellation · Built 1947 · Flying IncN394GSSilva/Antares MA-30 · S/N ANT950815GS447Cancelled Mar 2, 2018 · Registration expired, pending cancellation · Built 1996 · Batista Juan CN2612CCessna 402C · S/N 402C0077Cancelled Sep 18, 2017 · Registration expired, pending cancellation · Hyannis Air Service IncN770CACessna 402C · S/N 402C-0432Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1981 · Hyannis Air Service Inc DBAN6434ACessna P210R · S/N P21000871Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1986 · Dewire Thomas A III TrusteeN8789NPiper PA-28-140 · S/N 28-25629Cancelled Aug 4, 2014 · Exported to Brazil · Built 1969 · Aero Aviation Service IncN44058Beckloff A Peter S-9 CHAOS · S/N 1291103Cancelled Jul 30, 2013 · Sale reported, canceledN8919ZCessna 310G · S/N 310G-0019Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1962 · Falmouth Import & Export Co IncN224TXCirrus Design SR22 · S/N 2530Cancelled Jul 9, 2012 · Exported to Brazil · Built 2007 · Aero Aviation Service IncN733EECessna 172N · S/N 17268231Cancelled May 23, 2012 · Exported to Brazil · Built 1976 · Aero Aviation Service IncN403BKCessna 402C · S/N 402C0330Cancelled Sep 10, 2010 · Built 1980 · Hyannis Air Service IncN11835Aerospatiale/Aeritalia ATR 42-320 · S/N 194Cancelled Jan 16, 2007 · Exported to Maldives · Turbo Lease LLCN760EACessna 402C · S/N 402C0056Cancelled Dec 20, 2001 · Built 1979 · Hyannis Air Service IncN6837YCessna 402C · S/N 402C0467Cancelled Jul 12, 2001 · Triennial form not returned · Hyannis Air Leasing IncN7444LPiper PA-31-310 · S/N 31836Cancelled Jul 19, 1991 · Exported to Canada · Hyannis Air Lsg IncN6721GCessna 150L · S/N 15072221Cancelled Jan 28, 1975 · Exported to Canada · Discover Flying ServiceN4829UCessna 210-5A · S/N 205-0529Cancelled Feb 3, 1972 · Jones Allen FN76354Cessna 140 · S/N 10771Cancelled Apr 28, 1971 · Whiting Walter R IIIN7096PPiper PA-24-250 · S/N 242251Cancelled May 23, 1965 · Allan F JonesN61378Cessna T-50 · S/N 4780Cancelled May 20, 1965 · Cape & Island Flight Service IncN505Lockheed 12A · S/N 1216Cancelled May 18, 1965 · Cape & Islands Flight Service IncN8925DPiper PA-22-160 · S/N 22-6082Cancelled Jan 23, 1964 · Henderson Chester M DBA Hyannis AviationN52726Cessna T-50 · S/N 6004Cancelled Mar 27, 1958 · Cape & Islands Flight Service IncN505Cessna T-50 · S/N 5068Cancelled Jul 23, 1957 · Cape & Islands Flight Service IncN54575Cessna T-50 · S/N 4028Cancelled Oct 11, 1955 · Cape Air Service IncN75183Cessna T-50 · S/N 3243Cancelled Jan 26, 1951 · Cape Air Service IncN91848Schweizer SGS 2-12 · S/N 105Cancelled Aug 30, 1949 · Cape Cod Saoring Society IncN6536Fairchild Airplane Mfg FC-2 · S/N 103Cancelled May 31, 1929 · Hyannis Airport Corp
Back to Hyannis, MA