Old Town, ME

Cancelled registrations · 54

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 = 'ME' AND d.registrant_city = 'OLD TOWN'
  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.

N925MFBell UH-1H · S/N 65-9871Cancelled Jul 6, 2023 · Usda Forest Service FeppN2532EAeronca 7DC · S/N 7AC-6114Cancelled Jan 12, 2018 · Registration expired, pending cancellation · Built 1946 · Manzer Franklin EN6006YPiper PA-23-250 · S/N 27-3187Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1966 · James W Sewall CoN9548WPiper PA-28-140 · S/N 28-22980Cancelled Jun 26, 2008 · Exported to Canada · Built 1967 · Central Maine Flying Service IncN738HECessna 172N · S/N 17269983Cancelled Aug 30, 2006 · Triennial form not returned · Built 1977 · Old Town Aviation IncN714EJCessna 150M · S/N 15079117Cancelled Aug 28, 2006 · Triennial form not returned · Built 1976 · Old Town Aviation IncN975MFBell UH-1H · S/N 64-13810Cancelled Aug 11, 2004 · Triennial form not returned · Usda Forest Service FeppN985MFBell UH-1H · S/N 66-16138Cancelled Aug 11, 2004 · Triennial form not returned · Usda Forest Service FeppN5482KCessna 172P · S/N 17274148Cancelled Aug 24, 2000 · Sale reportedN51413Cessna A185F · S/N 18503594Cancelled Feb 27, 1997 · Triennial form not returned · Central Maine Flying ServiceN106MFBell UH-1B · S/N 6312910Cancelled Jul 13, 1993 · Triennial form not returned · State Of Maine Dept Conserv ForestryN185NMCessna A185F · S/N 18504054Cancelled Feb 18, 1993 · Exported to Canada · Central Maine Flying ServiceN255LCessna A185F · S/N 18504434Cancelled Oct 23, 1991 · Exported to Germany · Eastern Aircraft Sales IncN43452Piper PA-28-151 · S/N 287415496Cancelled Dec 25, 1975 · Built 1974 · Central Maine Flying Service IncN5753UPiper PA-28-140 · S/N 28-26578Cancelled Jun 26, 1973 · Exported to Canada · Central Maine Flying Service IncN451FLPiper PA-28-140 · S/N 28-7125244Cancelled May 31, 1973 · Exported to Canada · Built 1971 · Central Maine Flying Service IncN5254TPiper PA-28-140 · S/N 287225374Cancelled Jul 11, 1972 · Exported to Canada · Central Maine Flying ServiceN6653YPiper PA-23-250 · S/N 27-3965Cancelled Jun 2, 1972 · Exported to Canada · Central Maine Flying Service IncN5308SPiper PA-28-140 · S/N 2826925Cancelled Mar 16, 1972 · Exported to Canada · Central Maine Flying Service IncN8646NPiper PA-32-300 · S/N 32-7140041Cancelled Jul 20, 1971 · Exported to Canada · Built 1971 · Central Maine Flying Service IncN4485JPiper PA-28-140 · S/N 28-22903Cancelled Jun 24, 1971 · Exported to Canada · Central Maine Flying Service IncN60987Cessna T-50 · S/N 2705Cancelled Oct 9, 1970 · Built 1943 · Central Maine Flying Service IncN13834Piper PA-23-250 · S/N 27-4476Cancelled Sep 23, 1970 · Exported to Canada · Central Maine Flying Service IncN4264JPiper PA-28-140 · S/N 28-22621Cancelled Sep 16, 1970 · Exported to Canada · Central Maine Flying ServiceN7811NPiper PA-28-180 · S/N 28-5263Cancelled Aug 27, 1970 · Exported to Canada · Central Maine Flying Service IncN7405RPiper PA-28-140 · S/N 28-21922Cancelled Jul 27, 1970 · Exported to Canada · Central Maine Flg Svc IncN7244JPiper PA-28-140 · S/N 28-24585Cancelled Feb 16, 1970 · Exported to Canada · Central Maine Flying Service IncN6591YPiper PA-23-250 · S/N 27-3894Cancelled Apr 7, 1969 · Exported to Canada · Central Maine Flying Service IncN4137WPiper PA-32-300 · S/N 32-40204Cancelled Sep 10, 1968 · Exported to Canada · Central Maine Flying Service IncN9506WPiper PA-28-140 · S/N 28-22929Cancelled Jul 12, 1968 · Exported to Canada · Central Maine Flying Service IncN6494WPiper PA-28-140 · S/N 28-20570Cancelled Aug 26, 1967 · Built 1964 · Central Maine Flying Service IncN3372PPiper PA-23-160 · S/N 23-1329Cancelled Jun 21, 1967 · Exported to Canada · Central Main Flying Service IncN5871YPiper PA-23-250 · S/N 27-3024Cancelled Mar 2, 1967 · Exported to Canada · Central Maine Flying Service IncN8171YPiper PA-30 · S/N 30-1284Cancelled Feb 21, 1967 · Exported to Canada · Built 1966 · Central Maine Flying Service IncN6320WPiper PA-28-140 · S/N 28-20376Cancelled Apr 26, 1966 · Exported to Canada · Built 1964 · Central Maine Flying Service IncN8628PPiper PA-24-260 · S/N 24-4072Cancelled Aug 9, 1965 · Exported to Canada · Central Maine Flying Service IncN3195PPiper PA-23-150 · S/N 23-1133Cancelled Nov 6, 1963 · Exported to Canada · Central Maine Flying Service IncN7581PPiper PA-24 · S/N 24-2792Cancelled Sep 18, 1963 · Exported to Canada · Central Maine Flying ServiceN6779PPiper PA-24-250 · S/N 24-1910Cancelled Oct 19, 1961 · Exported to Canada · Built 1960 · Central Main Flying Service IncN7274DPiper PA-18 · S/N 18-5682Cancelled May 31, 1960 · Exported to Canada · Central Maine Flying Service IncN9131CCessna 180 · S/N 31230Cancelled Apr 26, 1960 · Exported to Canada · Central Maine Flying Service IncN9768EAeronca 11AC · S/N 11AC-1412Cancelled Oct 23, 1959 · Exported to Canada · Built 1946 · Central Maine Flying Service IncN3472PPiper PA-23-160 · S/N 23-1446Cancelled Mar 19, 1959 · Exported to Canada · Built 1958 · Central Maine Flying ServiceN9011DPiper PA-22-160 · S/N 22-6146Cancelled Nov 3, 1958 · Exported to Canada · Central Maine Flying Service IncN3330PPiper PA-23 · S/N 23-1281Cancelled Aug 13, 1958 · Exported to Canada · Central Maine Flying Service IncN83089Aeronca 7AC · S/N 7AC-1746Cancelled Jul 16, 1958 · Exported to Canada · Built 1946 · Central Maine Flying Service IncN2757PPiper PA-22 · S/N 22-3064Cancelled May 17, 1958 · Exported to Sweden · Deane B GrayN3745PPiper PA-22-150 · S/N 22-3465Cancelled Mar 27, 1958 · Exported to Canada · Built 1955 · Central Maine Flying Service IncN3241BPiper PA-22 · S/N 22-2071Cancelled Dec 7, 1955 · Exported to Canada · Central Maine Flying Service IncN3634VCessna 140 · S/N 14905Cancelled Dec 8, 1954 · Exported to Canada · Central Maine Flying Service Inc
Back to Old Town, ME