OpenAirDocs.org
Stamford, CT

Cancelled registrations · 183

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 = 'CT' AND d.registrant_city = 'STAMFORD'
  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.

N570TMRaytheon 400A · S/N RK-292Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 2000 · Xl Specialty Insurance CoN612STStemme STEMME S 12 · S/N 12-009Cancelled Apr 3, 2021 · Registration expired, pending cancellation · Built 2017 · Tcc Air Services IncN380GBGrumman G-73T · S/N J-34Cancelled Dec 28, 2020 · Registration expired, pending cancellation · Built 1948 · Tcc Air Services IncN1376DCessna 170B · S/N 19952Cancelled May 4, 2019 · Revoked, canceled · Built 1951 · Bel Cer Mer IncN2299EAeronca 7AC · S/N 7AC5873Cancelled Jan 29, 2019 · Revoked, canceled · Built 1946 · Parish ClintonN596TSDJI PHANTOM 3 PROFESSION · S/N P76DCF15014175Cancelled May 30, 2018 · Sale reported, canceledN26HDHarrison Philip W PITTS SPECIAL S-1S · S/N 001Cancelled Apr 19, 2018 · Registration expired, pending cancellation · Built 1998 · Harrison Philip WN831FTBoeing 747-121 · S/N 19648Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1970 · Palc II IncN31743Piper PA-34-200T · S/N 34-7870264Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 1978 · Campbell Associataes At Curtiss Aero IncN589CCBoeing 747-4HAF · S/N 35235Cancelled Aug 11, 2017 · Exported to China · Aircraft Msn 35235 LLCN7274DCessna 172R · S/N 17280712Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Built 1999 · Blackbird Services IncN816NKMcdonnell Douglas DC-9-82(MD-82) · S/N 49140Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1983 · Aviation Financial Services IncN201BBMesserschmitt-Boelkow-Blohm-Gm BO-105C · S/N S-51Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1972 · American Aircraft Equity IncN5892WPiper PA-28-150 · S/N 28-2634Cancelled Jun 23, 2017 · Registration pending · Built 1965N352WLMcdonnell-Douglas DC-10-30 · S/N 47838Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Built 1980 · Polaris Holding CoN830FTBoeing 747-121 · S/N 19642Cancelled May 21, 2015 · Registration expired, pending cancellation · Built 1969 · Palc II IncN679ACBoeing 737-800 · S/N 28213Cancelled Jan 15, 2015 · Exported to Slovak Republic · Aircraft Msn 28213 LLCN3365TCessna 177 · S/N 17700665Cancelled Oct 7, 2014 · Registration expired, pending cancellation · Built 1967 · Cann TempleN637ACBoeing 737-8AS · S/N 29919Cancelled Sep 29, 2014 · Exported to Slovak Republic · Aircraft Msn 29919 LLCN493EVBoeing 747-4H6 · S/N 25702Cancelled Sep 9, 2014 · Built 1993 · Aircraft Msn 25702-2 LLCN649ACBoeing 737-8AS · S/N 29918Cancelled Feb 24, 2014 · Exported to Turkey · Aircraft Msn 29918 LLCN641ACBoeing 737-8AS · S/N 29920Cancelled Jan 22, 2014 · Exported to Turkey · Aircraft Msn 29920 LLCN708DDDurfee Douglas E JR RANS S-7 COURIER · S/N 0388042Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Built 1989 · Belknap John CN782LFAerospatiale AS350B · S/N 1487Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1987 · American Aircraft Equity IncN777MMAero Commander 685 · S/N 12030Cancelled Aug 28, 2013 · Registration expired, pending cancellation · Built 1973 · Maxfield MorganN914FRAirbus A319-111 · S/N 1841Cancelled Jul 31, 2013 · Exported to Bermuda · Built 2002 · Afs Investments Xix LLCN393USBoeing 737-3B7 · S/N 23315Cancelled Jul 5, 2013 · Sale reported, pending cancellation · Built 1986N945FRAirbus A319-112 · S/N 2751Cancelled Jul 2, 2013 · Exported to Bermuda · Built 2006 · Afs Investments 58 LLCN77MMCessna 310 · S/N 35491Cancelled Jun 21, 2013 · Third renewal notice · Built 1957 · Maxfield J R IIIN40765Raven S-60A · S/N S60A-247Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1983 · ElectroluxN656CSBoeing 737-85R · S/N 30407Cancelled Jun 5, 2013 · Afs Investments 57 LLCN657CSBoeing 737-85R · S/N 30408Cancelled Jun 5, 2013 · Afs Investments 57 LLCN658CSBoeing 737-85R · S/N 30409Cancelled Jun 5, 2013 · Afs Investments 57 LLCN930FRAirbus A319-111 · S/N 2241Cancelled May 28, 2013 · Exported to Bermuda · Built 2004 · Afs Investments 58 LLCN676ACBoeing 767-3T7ER · S/N 25076Cancelled Apr 9, 2013 · Built 1991 · Aircraft Msn 25076 LLCN923LDouglas DC-9-32 · S/N 47109Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1968N277CSBoeing 737-7L9 · S/N 28004Cancelled Mar 13, 2013 · Afs Investments 57 LLCN451MAAmerican Champion 8KCAB · S/N 907-2002Cancelled Feb 8, 2013 · Built 2002 · Green Aviation IncN5784CCessna 170A · S/N 19738Cancelled Feb 1, 2013 · Sale reported, canceled · Built 1950N940FRAirbus A319-111 · S/N 2465Cancelled Dec 3, 2012 · Exported to Ireland · Afs Investments 58 LLCN936FRAirbus A319-111 · S/N 2392Cancelled Nov 6, 2012 · Exported to Belgium · Built 2005 · Afs Investments X LLCN942FRAirbus A319-111 · S/N 2497Cancelled Oct 17, 2012 · Exported to Ireland · Built 2005 · Afs Investments 58 LLCN2469FCessna 172S · S/N 172S10066Cancelled Jun 27, 2012 · Exported to Indonesia · Built 2005 · Cta Properties LLCN264AVAirbus A320-214 · S/N 1867Cancelled Jun 19, 2012 · Exported to Colombia · Built 2002 · Afs Investments Xx LLCN609SCBoeing 737-4YO · S/N 24545Cancelled May 11, 2012 · Afs Investments 57 LLCN260AVAirbus Industrie A320-214 · S/N 1564Cancelled Apr 11, 2012 · Exported to Colombia · Built 2001 · Afs Investments 70 LLCN840HKEmbraer EMB-145LR · S/N 145341Cancelled Dec 15, 2011 · Built 2001 · Afs Investments Xiv LLCN806FRAirbus A318-111 · S/N 2218Cancelled Sep 28, 2011 · Second renewal notice · Built 2004 · Afs Investments X LLCN807FRAirbus A318-111 · S/N 2276Cancelled Sep 28, 2011 · Built 2004 · Afs Investments X LLCN680AABoeing 737-3A4 · S/N 23505Cancelled Aug 25, 2010 · Built 1986 · Afs Investments 68 LLC
Back to Stamford, CT