OpenAirDocs.org
Greenwich, CT

Cancelled registrations · 64

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

N8821Airbus A319-115 · S/N 3542Cancelled Dec 14, 2023 · Exported to San Marino · Altitude 51 IncN605BPMcdonnell Douglas Helicopter 600N · S/N RN034Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Brim Equipment Leasing LLC DBAN6975WPiper PA-28-140 · S/N 28-21173Cancelled Jan 28, 2019 · Registration expired, pending cancellation · Built 1965 · Agthe Thilo CN4124RPiper PA-32-300 · S/N 32-40442Cancelled Aug 2, 2018 · Sale reported, canceled · Built 1968N485PMEnstrom F-28A · S/N 259Cancelled Feb 15, 2018 · Sale reported, canceled · Built 1974N602SKAirship Industries UK AIRSHIP 600 · S/N 1215/07Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Airship Management Services IncN8988Keystone Helicopter S-76C · S/N 760757Cancelled Oct 24, 2017 · Exported to Canada · Altitude 51 IncN6029SHawker Beechcraft B300C · S/N FM-29Cancelled Jul 11, 2017 · Exported to United Kingdom · Built 2009 · Fm 29 LLCN287QEnstrom F-28A · S/N 303Cancelled Sep 14, 2016 · Sale reported, canceled · Built 1975N731Boeing A75 · S/N 75045Cancelled May 12, 2016 · Exported to United Kingdom · Built 1937 · Pumba Investments LLCN6688KRepublic RC-3 · S/N 971Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1947 · Martin James M WN33433Piper J4A · S/N 4-1375Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1940 · Martin James MwN241KKSikorsky S-76C · S/N 760470Cancelled Mar 24, 2014 · Exported to Brazil · Built 1997 · Greenwich Aerogroup Brazil Leasing IncN9571TPiper PA-38-112 · S/N 38-78A0134Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1978 · Willsea Anthony LN883JSThompson Stephen K VANS RV-9A · S/N 91266Cancelled Aug 13, 2013 · Sale reported, canceled · Built 2009N320TCMunro Arthur LANCAIR 320 · S/N 945-320-785-CSFBCancelled Jul 9, 2013 · Registration expired, pending cancellation · Munro Arthur RN195BBeech E-90 · S/N LW-195Cancelled Jun 24, 2013 · Second renewal notice · Built 1976 · Avco CorporationN44BKBrady STEEN SKYBOLT · S/N 8346844Cancelled Jun 12, 2013 · Sale reported, canceled · Built 1975N823JSBritish Aerospace BAE JETSTREAM 3101 · S/N 623Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Chrysler Capital Funding CorpN123QCOrcutt Charles L QUICKIE Q-2 · S/N 2496Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1982 · Luders Contemporary Living ConceptsN98139Piper J-3 · S/N 18294Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1946 · Martin James M WN9ASGrumman G-44 · S/N 1233Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1941 · Flying Barnyard IncN555EMPiper PA-30 · S/N 30-1587Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1967 · Doppke Gregory DN2254TCessna R182 · S/N R18200009Cancelled Feb 7, 2013 · Registration expired, pending cancellation · Built 1977 · Westwind Aviation Services IncN151MGrumman G-44 · S/N 1266Cancelled Dec 13, 2012 · Registration expired, pending cancellation · Built 1942 · Flying Barnyard IncN37189Grumman G-44 · S/N 1239Cancelled Sep 20, 2012 · Sale reported, canceled · Built 1941N514JRCanadair CL600-2B16(CL601-3A) · S/N 5147Cancelled Mar 22, 2012 · Exported to Mexico · Dark Blue Aviation LLCN105CRMesserschmitt-Boelkow-Blohm BO-105S · S/N S-829Cancelled Oct 24, 2011 · Exported to Argentina · Built 1990 · Tcc Air Services IncN1104VAllen Ballon HOT AIR BALLON · S/N 127Cancelled Jul 20, 2011 · Sale reported, canceled · Built 1965N303CSCessna 550 · S/N 550-0814Cancelled Apr 25, 2011 · Exported to Canada · Built 1997 · Bank Of America NaN417VRCzech Aircraft Works Spol Sro SPORTCRUISER · S/N 08SC232Cancelled Feb 25, 2011 · First renewal notice · Built 2008 · Lsa LLCN128CSCessna 525 · S/N 525-0361Cancelled Feb 24, 2011 · Exported to Argentina · Built 2000 · Bank Of America NaN2969Grumman G-73 · S/N J-27Cancelled Jan 10, 2011 · First renewal notice · Built 1947 · Seaplane Adventures LLCN1208Grumman G-73 · S/N J-44Cancelled Apr 29, 2010 · Triennial form not returned · Built 1949 · Seaplane Adventures LLCN2974Grumman G-73T · S/N J-36Cancelled Apr 29, 2010 · Triennial form not returned · Built 1967 · Seaplane Adventures LLCN142PAGrumman G-73T · S/N J42Cancelled Mar 25, 2010 · Triennial form not returned · Seaplane Adventures LLCN818MVRaytheon Corporate Jets BAE 125-800A · S/N 258186Cancelled Nov 18, 2009 · Triennial form not returned · Built 1990 · Mva Aircraft Leasing IncN51VRBombardier CL-600-2B16 · S/N 5426Cancelled Jun 9, 2008 · Exported to United Kingdom · Built 1999 · Dark Blue Aviation LLCN200BRBeech 200 · S/N BB-600Cancelled May 30, 2008 · Exported to Chile · Built 1980 · B & R Motorsports LLCN133CSCessna 525 · S/N 525-0502Cancelled Jul 23, 2007 · Exported to Sweden · Built 2002 · Citationshares Sales IncN212SXBell 212 · S/N 30583Cancelled Oct 12, 2006 · Exported to Australia · Built 1973 · Wings Venture LtdN9603RChristen Industries A-1 · S/N 1128Cancelled Jul 6, 1998 · Exported to Belgium · Built 1990 · Streber Leasing CorpN8507JCessna 150G · S/N 15066407Cancelled Jan 10, 1998 · Triennial form not returned · Martin James M WN883AVBeech C90 · S/N LJ528Cancelled Dec 16, 1997 · Exported to Kenya · Galaxy Investments LLCN4704FCessna P206A · S/N P2060304Cancelled Mar 27, 1997 · Triennial form not returned · Wood Curtis CN6591KRepublic RC-3 · S/N 1051Cancelled Feb 8, 1995 · Triennial form not returned · Martin James M WN9438ZCessna TU206G · S/N U20606490Cancelled Apr 15, 1993 · Exported to Canada · Irving Forest Products IncN6474TCessna R182 · S/N R18202034Cancelled Mar 29, 1993 · Exported to Switzerland · Mayone JosephN939ABBelmont August III TERATORN TIERRA II · S/N 339Cancelled Sep 10, 1984 · Administratively canceled · Belmont August IIIN68667North American AJ-2 · S/N 184014Cancelled Jun 14, 1984 · Avco Corp
Back to Greenwich, CT