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.

N513LRBritish Aerospace BAE 125 SERIES 1000A · S/N NA1004Cancelled Feb 4, 2023 · Built 1992 · Aviation Dynamics LLCN746LDDJI INSPIRE 1 PRO · S/N W21ADA11021893Cancelled Nov 29, 2019 · Registration expired, pending cancellation · 360 Productions LLCN6522PDJI PHANTOM 2 · S/N PH636162862Cancelled Sep 6, 2019 · Registration expired, pending cancellation · 360 Productions LLCN740TKDJI INSPIRE 1 · S/N W130CC30030452Cancelled Sep 6, 2019 · Registration expired, pending cancellation · 360 Productions LLC DBAN86EABombardier CL-600-2C10 · S/N 10086Cancelled Jan 7, 2019 · Registration expired, pending cancellation · Elite Airways LLCN28992Bowlus BA-100 · S/N 108Cancelled Aug 9, 2018 · Revoked, canceled · Built 1942 · Fuller Frank JN80028Handcock Thomas 7 · S/N 1Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Handcock ThomasN87563Cessna U206F · S/N U20601825Cancelled May 6, 2015 · Registration expired, pending cancellation · C-B Marine CorporationN333BKPiper PA-32-300 · S/N 32-73-40180Cancelled Nov 21, 2014 · Registration expired, pending cancellation · Built 1973 · Port Aviation IncN4091CStinson 108-3 · S/N 108-5091Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Built 1948 · Savik Wade AN67887Cessna 402C · S/N 402C0436Cancelled Jul 15, 2014 · Exported to Bahamas · Built 1981 · Maine Aviation Sales IncN45904Cessna 152 · S/N 15282941Cancelled Apr 30, 2014 · Exported to Canada · Maine Aviation Aircraft Leasing LLCN404BKCessna 402C · S/N 402C0628Cancelled Feb 26, 2014 · Exported to Bahamas · Built 1980 · Maine Aviation Sales IncN4173GCessna 402B · S/N 402B1219Cancelled Jan 8, 2014 · Exported to Colombia · Built 1977N442EHCessna 404 · S/N 404-0202Cancelled Oct 28, 2013 · Exported to Honduras · Built 1978 · Maine Aviation Sales IncN62664Piper PA-23-250 · S/N 27-7654125Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1976N6099KRepublic RC-3 · S/N 282Cancelled Jul 15, 2013 · Sale reported, canceled · Built 1947N7116PBalloon Works FIREFLY 9 · S/N F9-002Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Route Deliveries IncN48213Vachon Peter F ROTEC RALLY 3 · S/N 25327Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Vachon Peter FN911MEBell Helicopter Textron 206L-1 · S/N 45553Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1980 · Airmed Skycare IncN3641QBalloon Works FIREFLY 8-24 · S/N F8-046Cancelled Apr 1, 2013 · Sale reported, canceled · Built 1984N7180XCessna 150A · S/N 15059280Cancelled Mar 18, 2013 · Exported to Canada · Built 1961 · Aviation Management Services IncN80038Handcock Thomas 8 · S/N 2Cancelled Nov 13, 2012 · Registration expired, pending cancellation · Handcock ThomasN1048Cessna 402B · S/N 402B0628Cancelled Oct 30, 2012 · Exported to Philippines · Built 1974 · Maine Aviation Sales IncN2800TCessna 180H · S/N 18051906Cancelled Sep 21, 2012 · Registration expired, pending cancellation · Built 1967 · Howland Raymond EdbaN390TMCessna 402C · S/N 402C0069Cancelled Mar 18, 2011 · Exported to Honduras · Built 1979 · Maine Aviation Sales IncN409DHBeech 200 · S/N BB-795Cancelled Jan 10, 2011 · Exported to Colombia · Built 1981 · Maine Aviation Sales IncN6350XCessna 402B · S/N 402B1317Cancelled Jun 23, 2010 · Exported to Philippines · Built 1978 · Maine Aviation Sales IncN4630GCessna 402B · S/N 402B1307Cancelled May 19, 2010 · Exported to Bolivia · Maine Aviation Sales IncN41059Cessna 404 · S/N 404-0012Cancelled May 6, 2010 · Exported to Venezuela · Built 1977 · Maine Aviation Sales IncN700BGCessna 402B · S/N 402B0577Cancelled Nov 18, 2009 · Exported to Mexico · Built 1974 · Maine Aviation Sales IncN16851Fairchild 24 C8 · S/N 3131Cancelled Jul 1, 2009 · Registration revoked · Built 1936 · White Lloyd NN49JBCessna 402B · S/N 402B1040Cancelled Oct 28, 2008 · Exported to Portugal · Built 1976 · Maine Aviation Sales IncN98682Cessna 172R · S/N 17280604Cancelled Mar 28, 2007 · Exported to Canada · Maine Aviation Sales IncN897BCessna 404 · S/N 4040014Cancelled Mar 12, 2007 · Exported to Colombia · Built 1977 · Maine Aviation Sales IncN2616LCessna 172R · S/N 17280548Cancelled Jan 8, 2007 · Exported to Portugal · Built 1998 · Maine Aviation Aircraft Leasing LLCN52606Cessna 172S · S/N 172S9174Cancelled Jun 30, 2006 · Exported to Venezuela · Built 2002 · Maine Aviation CorpN66DVCessna 337 · S/N 3370047Cancelled Jun 26, 2006 · Expired dealer · Built 1965 · Northeast Aircraft Sales IncN145RCCessna 402C · S/N 120Cancelled Oct 13, 2005 · Exported to Panama · Maine Aviation Sales IncN32872Balloon Works FIRE FLY 10 · S/N F10-024Cancelled Jun 14, 2005 · Built 1997 · Handcook ThomasN68PBCessna 402C · S/N 402C-0034Cancelled Mar 16, 2005 · Built 1979 · Maine Aviation CorpN27SACessna 404 · S/N 404-0038Cancelled Aug 13, 2004 · Exported to Venezuela · Built 1977 · Maine Aviation Sales IncN433RCCessna 404 · S/N 4040033Cancelled Aug 13, 2004 · Exported to Mexico · Built 1977 · Maine Aviation Sales IncN433VCessna 404 · S/N 404-0433Cancelled Aug 13, 2004 · Exported to Venezuela · Maine Aviation Sales IncN346RCCessna 402C · S/N 402C0346Cancelled Sep 12, 2003 · Exported to Panama · Built 1980 · Maine Aviation Sales IncN404ECessna 404 · S/N 4040054Cancelled Aug 12, 2003 · Exported to Colombia · Built 1977 · Maine Aviation Sales IncN401EXCessna 404 · S/N 404-0403Cancelled Feb 24, 2003 · Exported to Venezuela · Built 1978 · Maine Aviation Sales IncN20JCCarroll James J RANS S 9 · S/N 0188040Cancelled Jul 9, 2002 · Carroll James JN2061CCessna TU206G · S/N U20603913Cancelled Sep 20, 2000 · Exported to Mexico · Maine Aviation Sales IncN9272SCessna 402C · S/N 402C0252Cancelled Apr 3, 2000 · Exported to Mexico · Maine Aviation Sales Inc
Back to Portland, ME