OpenAirDocs.org
Manchester, NH

Cancelled registrations · 80

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 = 'NH' AND d.registrant_city = 'MANCHESTER'
  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.

N46DKPiper PA 46-350P · S/N 4622010Cancelled May 9, 1994 · Deka Research & Development CorpN126PMDehavilland DHC-6 TWIN OTTER · S/N 275Cancelled Mar 6, 1992 · Exported to Papua New Guinea · Fugere Joseph MN52144Murray Richard E AVID FLYER · S/N 29Cancelled Mar 25, 1991 · Triennial form not returned · Murray Richard EN5383RCessna 172F · S/N 17252918Cancelled Feb 12, 1991 · Triennial form not returned · Abood Trudy AN451CBeech 99 · S/N U-66Cancelled Jul 12, 1984 · Built 1968 · Fugere Joseph MN90019Cessna 140 · S/N 9077Cancelled Mar 10, 1984 · Administratively canceled · Prescott Robert GN1513FCessna 185D · S/N 1850836Cancelled Jun 6, 1981 · Administratively canceled · Mathes Richard EN9586Enstrom F-28A · S/N 115Cancelled Jun 12, 1980 · Exported to United Kingdom · Kamlot FrederickN2NZAmerican AA-1 · S/N AA1-0312Cancelled Jun 5, 1978 · Exported to Germany · Aero Investment IncN5498FPiper PA-28-151 · S/N 287715142Cancelled Jun 10, 1977 · Exported to Australia · Hampshire Aviation IncN8740FPiper PA-28-151 · S/N 28-7715287Cancelled Jun 10, 1977 · Exported to Australia · Built 1976 · Hampshire Aviation IncN4499FPiper PA-32R-300 · S/N 32R-7680454Cancelled Jan 24, 1977 · Exported to Australia · Built 1976 · Hampshire Aviation IncN8860MBeech A23 · S/N M-600Cancelled Nov 21, 1974 · Dooly John EN836TBeech 99A · S/N U-84Cancelled Mar 14, 1974 · Exported to France · Built 1969 · Connor Aircraft CoN144HBeech C35 · S/N 2831Cancelled Nov 16, 1972 · New England Aviation CorpN475YABeech A23-24 · S/N MA-165Cancelled Jul 28, 1972 · Exported to Canada · L & F Construction Co Of N H IncN80838Globe GC-1A · S/N 241Cancelled Dec 7, 1971 · Spyridakis JamesN8271NPiper PA-28-140 · S/N 28-25485Cancelled Sep 13, 1971 · Exported to Canada · Tech Aeroservice IncN1118Piper J3C-65 · S/N 8311Cancelled Jun 7, 1971 · Civil Air Patrol IncN29814Taylorcraft BL-65 · S/N 2663Cancelled Aug 18, 1970 · Gelinas Motor SalesN2724VBeech 35 · S/N D102Cancelled Jul 7, 1970 · State Motors IncN7267YPiper PA-30 · S/N 30-303Cancelled Mar 5, 1965 · Stearns William EN4837APiper PA-22-150 · S/N 22-3990Cancelled Mar 20, 1961 · Exported to Ethiopia · Hartford Edward SN1403VAeronca 7DC · S/N 147Cancelled Aug 21, 1956 · Civil Air Patrol IncN92933Commonwealth/Irish 185 SKYRANGER · S/N 1665Cancelled Oct 12, 1955 · Skyservice Of New England IncN2021MPiper J3C-65 · S/N 20795Cancelled Mar 24, 1948 · Corriveau Charles E SrN830EMoth 60-GM · S/N 1-ECancelled Feb 17, 1948 · Dallaire AimeN3059Arrow Aircraft & Motors ARROW SPORT · S/N 325Cancelled Mar 8, 1933 · Built 1929 · Northeast AirwaysN827VWaco NAZ · S/N 4045Cancelled Feb 8, 1933 · Northeast AirwaysN5972Waco GXE · S/N 1535Cancellation date not recorded · Northeast Airways Inc
Back to Manchester, NH