OpenAirDocs.org
Portland, ME

Cancelled registrations · 137

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

N100WPCessna 310N · S/N 310N-0146Cancelled Jun 8, 1973 · Palmer William P IIIN23373Cessna 150H · S/N 15068912Cancelled Jun 5, 1973 · Exported to Canada · Maine Aviation CorpN2570GCessna 182B · S/N 51870Cancelled Jan 15, 1971 · Maine Aviation CorpN1654FCessna 172H · S/N 17255049Cancelled Jun 15, 1970 · Exported to Canada · Built 1966 · Eastern Aviation Sales IncN72348Cessna U206D · S/N U206-1378Cancelled May 15, 1970 · Exported to Canada · Maine Aviation Corp/Portland Municipal AirportN3231FMooney M20E · S/N 670024Cancelled Feb 6, 1970 · Exported to Canada · Built 1967 · Eastern Aviation Sales IncN7888UCessna 172F · S/N 172-51888Cancelled Apr 9, 1969 · Exported to Canada · Maine Aviation CorpN2950LMooney M20C · S/N 670084Cancelled Jan 31, 1968 · Eastern Aviation Sales IncN2836DNoorduyn UC-64A · S/N 225Cancelled Oct 6, 1965 · Exported to Peru · Built 1942 · Fleet Leasing CorporationN1076QCessna 310H · S/N 310H0076Cancelled Mar 1, 1965 · Exported to Canada · Maine Aviation CorpN2169ZCessna 180F · S/N 180-51269Cancelled Jun 22, 1964 · Exported to Canada · Maine Aviation CorpN2939ACessna 180 · S/N 30139Cancelled Mar 6, 1964 · Exported to Canada · Maine Aviation CorpN5735BCessna 182 · S/N 33735Cancelled Jan 3, 1964 · Exported to Canada · Maine Aviation CorpN181NPiper PA-18 · S/N 18-2188Cancelled May 15, 1963 · Exported to Canada · Maine Aviation CorpN44228Taylorcraft BC12-D1 · S/N 10028Cancelled Sep 20, 1960 · Exported to Canada · Casco Bay Flying ClubN92597Piper PA-12 · S/N 12-129Cancelled Jan 16, 1960 · Maine Flying Service IncN93843Ercoupe 415-C · S/N 1166Cancelled Aug 13, 1958 · Exported to Canada · Golodetz Eugene NN2188HErcoupe 415-C · S/N 2811Cancelled Nov 17, 1955 · Built 1946 · Northeast Aviation CoN9399EAeronca 11AC · S/N 11AC-1036Cancelled Nov 17, 1955 · Built 1946 · Pine State Flying ClubN2985HEngineering & Research ERCOUPE 415-C · S/N 3610Cancelled Feb 14, 1952 · Built 1946 · Maine Flying Service IncN3086EAeronca 7AC · S/N 7AC-6675Cancelled Dec 4, 1950 · Portland Flyng Service IncN80132Culver V · S/N V-12ACancelled Sep 9, 1949 · Built 1946 · Miller Gordon LN2742HErcoupe 415-C · S/N 3367Cancelled Jul 1, 1949 · Northeast Aviation CoN594CStinson 108-3 · S/N 108-3594Cancelled May 26, 1949 · Winton Equipment CoN36906Aeronca 65-TAF · S/N F2141TACancelled Sep 16, 1948 · Built 1941 · Portland Flying Service IncN27501Taylorcraft BL-65 · S/N 2143Cancelled Jul 6, 1948 · Northeast Airways IncN19271Piper J-2 · S/N 1671Cancelled May 5, 1948 · Littlefield W Wayne & John G StoverN93638Engineering & Research 415-C · S/N 961Cancelled Jan 15, 1948 · Built 1946 · Northeast Aviation CoN26524Taylorcraft BL · S/N 1865Cancelled May 19, 1944 · Charles C NicelyN21094Aeronca KF · S/N KF-3Cancelled Nov 16, 1938 · Built 1938 · Portland Flying Service IncN12469Waco UBA · S/N 3602Cancelled Jul 9, 1938 · Stanley James GN900VSavoia Marchetti S-56 · S/N 30Cancelled Jun 1, 1936 · Sulivan Frank WN114HIreland N 2 B · S/N 40Cancelled Mar 2, 1933 · Clement Brothers IncN6252Stearman C3-B · S/N 142Cancelled Jan 9, 1933 · Maine Seaplane Terminals IncN1833Curtiss JN4D · S/N 3029Cancelled Oct 12, 1928 · Built 1917 · Nichols Linwood HaydenN17670Piper E-2 · S/N 335Cancellation date not recorded · Built 1935 · Leonard Donald EllisonN8872ABeech B35 · S/N D-2527Cancellation date not recorded · Mathis Raymond Lewis
Back to Portland, ME