OpenAirDocs.org
Norwalk, CT

Cancelled registrations · 70

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

N130RUEurocopter AS 350 B2 · S/N 4208Cancelled Jun 15, 2021 · Exported to New Zealand · Built 2007 · Nef Holdings LLCN351LHAmerican Eurocopter AS350B2 · S/N 7684Cancelled Jun 15, 2021 · Exported to New Zealand · Built 2013 · Nef Holdings LLCN586EBDJI PHANTOM 3 PROFESSION · S/N P76DCD18010299Cancelled Dec 16, 2019 · Sale reported, canceledN850DMBoeing 737-809 · S/N 28403Cancelled Apr 2, 2019 · Afs Investments 52 LLCN795SABoeing 747-243B · S/N 22506Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1980 · Air Mobility IncN760SABoeing 747-230B · S/N 21221Cancelled Oct 30, 2017 · Registration expired, pending cancellation · Built 1976 · Air Mobility IncN820SABoeing 747-243B · S/N 23476Cancelled Oct 20, 2017 · Registration expired, pending cancellation · Built 1986 · Air Mobility IncN815SABoeing 747-2L5B · S/N 22107Cancelled Sep 26, 2017 · Registration expired, pending cancellation · Built 1980 · Air Mobility IncN223FSFalcon Safety Craft FALCON XP · S/N 600223Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Built 1986 · Murphy Jerry GN379KWPiper J4A · S/N 4546Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Wiemer Karl JN935FRAirbus A319-111 · S/N 2318Cancelled Apr 12, 2017 · Exported to Ireland · Built 2004 · Afs Investments 55 LLCN932FRAirbus A319-111 · S/N 2258Cancelled Dec 13, 2016 · Exported to Ireland · Built 2004 · Afs Investments 58 LLCN906FRAirbus A319-111 · S/N 1684Cancelled Dec 1, 2016 · Exported to Ireland · Built 2002 · Afs Investments 70 LLCN934FRAirbus A319-111 · S/N 2287Cancelled Sep 12, 2016 · Exported to Austria · Built 2004 · Afs Investments 55 LLCN933FRAirbus A319-111 · S/N 2260Cancelled May 23, 2016 · Exported to Austria · Built 2004 · Afs Investments 58 LLCN924FRAirbus A319-111 · S/N 2030Cancelled Apr 28, 2016 · Exported to Austria · Built 2003 · Afs Investments Xxii LLCN908FRAirbus A319-111 · S/N 1759Cancelled Mar 21, 2016 · Exported to Austria · Built 2002 · Afs Investments Xvi LLCN912FRAirbus A319-111 · S/N 1803Cancelled Feb 5, 2016 · Exported to Ireland · Built 2002 · Afs Investments Xv LLCN931FRAirbus A319-111 · S/N 2253Cancelled Jan 14, 2016 · Exported to Ireland · Built 2004 · Afs Investments 54 LLCN728SABoeing 747-228B · S/N 21982Cancelled Dec 23, 2015 · Third renewal notice · Cf6-50 LLCN746SABoeing 747-206B · S/N 21111Cancelled Dec 23, 2015 · Third renewal notice · Built 1975 · Air Mobility IncN748SABoeing 747-206B · S/N 21110Cancelled Dec 23, 2015 · Third renewal notice · Air Mobility IncN758SABoeing 747-281F · S/N 23138Cancelled Dec 23, 2015 · Third renewal notice · Built 1984 · Air Mobility IncN761SABoeing 747-2F6B · S/N 21832Cancelled Dec 23, 2015 · Third renewal notice · Built 1979 · Air Mobility IncN765SABoeing 747-2F6B · S/N 21833Cancelled Dec 23, 2015 · Third renewal notice · Built 1980 · Air Mobility IncN929FRAirbus A319-111 · S/N 2240Cancelled Nov 16, 2015 · Exported to Ireland · Built 2004 · Afs Investments 54 LLCN751SABoeing 747-228F · S/N 22678Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1981 · Air Mobility IncN789SABoeing 747-341 · S/N 23394Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1985 · Air Mobility IncN46318Piper J3C-65 · S/N G-9Cancelled Dec 22, 2014 · Revoked, canceled · Built 1945 · Demague Roy EN754SABoeing 747-228F · S/N 21576Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Built 1978 · Air Mobility IncN727RVVoeller SMITH MINI PLANE · S/N 1Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 1976 · Voeller Roy CN221NWMcdonnell-Douglas DC-10-30 · S/N 46579Cancelled Aug 13, 2013 · Sale reported, canceled · Built 1973N88856Pincince Norman T CORBEN BABY ACE C · S/N NP-1Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1995N708SABoeing 747-2B5F · S/N 24196Cancelled May 31, 2013 · Registration expired, pending cancellation · Built 1988 · Southern Air IncN8034CPiper PA-22-135 · S/N 22-2221Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1954 · Kalmanidis ChristosN704SABoeing 747-2B5F · S/N 24195Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1988 · Southern Air IncN798SABoeing 747-246B · S/N 23389Cancelled Jul 16, 2012 · Registration expired · Built 1986 · Southern Air IncN716SABoeing 747-228B · S/N 24067Cancelled Jul 13, 2012 · 24067 LLCN723SABoeing 747-246F · S/N 23641Cancelled Jul 13, 2012 · Third renewal notice · Built 1987 · Southern Air IncN749SABoeing 747-300 SERIES · S/N 24194Cancelled Jul 13, 2012 · First renewal notice · Built 1988 · Southern Air IncN753SABoeing 747-228F · S/N 21787Cancelled Jul 13, 2012 · Built 1979 · Air Mobility IncN818SABoeing 747-346 · S/N 23068Cancelled Jul 13, 2012 · Built 1983 · Southern Air IncN740SABoeing 747-230B · S/N 21380Cancelled Jul 11, 2012 · Built 1978 · Air Mobility IncN100EGGrumman G-159 · S/N 196Cancelled Oct 18, 2010 · Exported to Republic of the Congo · Built 1969 · Greenfield Aviation LLCN730SABoeing 747-200 · S/N 22380Cancelled Mar 9, 2009 · Triennial form not returned · Cf 6-50 LLCN747BDScottish SERIES 100 MDL 101 · S/N 110Cancelled Feb 12, 2008 · Exported to Australia · Built 1972 · Jacobelli RaphaelN86ULWaldhaus Robert N KOLB TWINSTAR · S/N TS-0019Cancelled Feb 15, 2006 · Exported to Japan · Built 1986 · Waldhaus Robert NN726SABoeing 747-206B · S/N 21660Cancelled Dec 12, 2005 · Cf6-50 LLCN725SABoeing 747-206B · S/N 21550Cancelled Nov 8, 2004 · Built 1978 · 21550 LLCN720SABoeing 747-230B · S/N 21590Cancelled Sep 26, 2003 · Built 1979 · 21590 LLC
Back to Norwalk, CT