OpenAirDocs.org
Haverhill, MA

Cancelled registrations · 25

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 = 'HAVERHILL'
  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.

N5741HPiper PA-16 · S/N 16-354Cancelled Apr 10, 2020 · Revoked, canceled · Built 1949 · Obrien Linc JrN678ALPiper PA-30 · S/N 30-639Cancelled Mar 2, 2018 · Registration expired, pending cancellation · La Rosa AntonioN375ALSocata Group Aerospatiale TB9 · S/N 1370Cancelled Mar 1, 2018 · Registration expired, pending cancellation · Larosa AntonioN20473Cessna 172M · S/N 17261316Cancelled Aug 22, 2012 · Registration expired, pending cancellation · Built 1972 · Andrea Aviation IncN302SBMooney M20J · S/N 24-0933Cancelled Feb 28, 2006 · Triennial form not returned · Built 1979 · Calascibetta SalvatoreN9258SBeech B24R · S/N MC388Cancelled Oct 6, 1994 · Triennial form not returned · Vest Air Leasing IncN21869Cessna 172M · S/N 17264037Cancelled Aug 11, 1984 · Administratively canceled · Sawyer Aldrich WN2HDPiper PA-23 · S/N 23-362Cancelled Jul 26, 1982 · Built 1955 · Dutton Flying Service IncN5708TCessna 172E · S/N 17251608Cancelled Dec 24, 1981 · Dutton Donald H DBA Dutton Flying ServiceN86770Bellanca 8KCAB · S/N 114-74Cancelled Aug 19, 1977 · Dutton DonaldN4CQPitts S-2A · S/N 2007Cancelled May 26, 1977 · Exported to Belgium · Built 1971 · Dutton Howard FN91968Piper J3C-65 · S/N 16399Cancelled Mar 15, 1972 · Dutton Howard FN42405Piper J3C-65 · S/N 14665Cancelled Sep 23, 1970 · Auclair Raymond HN301TPiper PA-18 105 · S/N 18-2415Cancelled Jun 17, 1960 · Exported to Germany · Dutton HowardN3959EAeronca 11BC · S/N 11BC-43Cancelled May 9, 1960 · Exported to Canada · Slavit Evelyn MN64879Cessna T-50 · S/N 3426Cancelled Mar 12, 1956 · Dutton Howard FN33597Piper J3C-65 · S/N 14074Cancelled Feb 20, 1956 · Dutton Howard FN6235KRepublic RC-3 · S/N 438Cancelled Feb 3, 1956 · Slavit William JN8588Waco CSO · S/N A96Cancelled Nov 14, 1955 · Built 1930 · Slavit EvelynN7484HPiper J-3 · S/N 20750Cancelled Oct 5, 1955 · Hodgkins Florence NN98082Piper J3C-65 · S/N 18237Cancelled Jun 14, 1949 · Built 1946 · Walker Dutton AirportN74670Cessna T-50 · S/N 3435Cancelled Feb 21, 1949 · Walker Dutton AirportN69567Cessna T-50 · S/N 2697Cancelled Feb 2, 1949 · Built 1943 · Walker Dutton AirportN32507Piper J3F-65 · S/N 5405Cancelled Jul 18, 1941 · Built 1940 · Pressey Milton AN11899Curtiss Wright JR CW1 · S/N 1269Cancelled Sep 15, 1934 · Rachel H Bartlett
Back to Haverhill, MA