OpenAirDocs.org
Colchester, VT

Cancelled registrations · 96

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 = 'VT' AND d.registrant_city = 'COLCHESTER'
  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.

N841EXBoeing DHC-8-102 · S/N 249Cancelled Dec 17, 2004 · Exported to Canada · Built 1991 · Bombardier Services CorpN229ASEmbraer EMB-120RT · S/N 120.042Cancelled Dec 8, 2004 · Exported to Canada · Built 1987 · Bombardier Services CorpN235ASEmbraer EMB-120RT · S/N 120.047Cancelled Dec 8, 2004 · Exported to Canada · Built 1987 · Bombardier Services CorpN547DSBoeing Of Canada/Dehav Div DHC-8-311 · S/N 286Cancelled Nov 22, 2004 · Exported to Canada · Bombardier Services CorpN784BCBoeing Of Canada/Dehav Div DHC-8-311 · S/N 311Cancelled Oct 29, 2004 · Exported to United Kingdom · Bombardier Services CorpN535DSBombardier DHC-8-402 · S/N 4043Cancelled Jul 15, 2004 · Exported to Canada · Built 2001 · Bombardier Capital IncN532DSBombardier DHC-8-402 · S/N 4040Cancelled Jun 25, 2004 · Exported to Canada · Bombardier Capital IncN283BCBoeing / Dehavilland DHC-8-103 · S/N 175Cancelled Apr 21, 2004 · Exported to Canada · Bombardier Services CorpN994DCDehavilland DHC-8-314 · S/N 309Cancelled Dec 5, 2003 · Exported to Bahamas · Bombardier Services CorpN538DSDehavilland DHC-8-311 · S/N 323Cancelled Oct 30, 2003 · Exported to Bahamas · Built 1992 · Bombardier Capital IncN791BCDehavilland DHC-8-106 · S/N 345Cancelled Oct 6, 2003 · Exported to Canada · Bombardier Services CorpN454LPLearjet 45 · S/N 034Cancelled Sep 19, 2003 · Exported to Mexico · Built 1999 · Bombardier Capital IncN64320Boeing 727-231 · S/N 20053Cancelled Sep 10, 2003 · Exported to Swaziland · Built 1969 · Bombardier Capital IncN136NMFokker F27 MK 050 · S/N 20136Cancelled Jul 9, 2003 · Exported to Kenya · Bombardier Services CorpN137NMFokker F27 MK 050 · S/N 20137Cancelled Jul 9, 2003 · Exported to Kenya · Bombardier Services CorpN203NMFokker F27 MK 050 · S/N 20203Cancelled Jul 9, 2003 · Exported to Kenya · Bombardier Services CorpN236ASEmbraer EMB-120RT · S/N 120.049Cancelled Jun 13, 2003 · Exported to Canada · Built 1987 · Bombardier Services CorpN242ASEmbraer EMB-120RT · S/N 120.069Cancelled Jun 13, 2003 · Exported to Canada · Built 1987 · Bombardier Services CorpN305DCBoeing Of Canada/Dehav Div DHC-8-311 · S/N 305Cancelled Jul 9, 2002 · Exported to Antigua and Barbuda · Bombardier Capital IncN802SADehavilland DHC-8-311 · S/N 250Cancelled Jun 27, 2002 · Exported to Antigua and Barbuda · Built 1990 · Bombardier Capital IncN4352ZPiper PA-18-150 · S/N 18-8670Cancelled Apr 11, 2002 · Exported to Canada · Built 1968 · Hazelett R WN819MABoeing DHC-8-102 · S/N 251Cancelled Mar 27, 2002 · Exported to Antigua and Barbuda · Bombardier Capital IncN60LJLearjet 60 · S/N 164Cancelled Feb 8, 2001 · Exported to Brazil · Bombardier Capital IncN152CAEmbraer EMB-120RT · S/N 120.152Cancelled Jan 11, 2001 · Exported to Australia · Bombardier Capital IncN286BCDehavilland DHC-8-102 · S/N 268Cancelled Aug 15, 2000 · Exported to Antigua and Barbuda · Bombardier Capital IncN285BCDehavilland DHC-8-311 · S/N 410Cancelled Jul 31, 2000 · Exported to Antigua and Barbuda · Bombardier Capital IncN823PHDehavilland DHC-8-102 · S/N 110Cancelled Apr 21, 2000 · Exported to Jamaica · Bombardier Capital IncN821PHDehavilland DHC-8-102 · S/N 104Cancelled Apr 14, 2000 · Exported to Jamaica · Bombardier Capital IncN477DCDehavilland DHC-8-315 · S/N 420Cancelled Feb 1, 2000 · Exported to South Africa · Bombardier Capital IncN848MADehavilland DHC-8-102 · S/N 346Cancelled Jun 28, 1999 · Exported to Australia · Bombardier Capital IncN826MADehavilland DHC-8-102 · S/N 330Cancelled Jan 8, 1999 · Exported to Argentina · De Havilland CorporationN864MADehavilland DHC-8-102 · S/N 363Cancelled Jul 1, 1998 · Exported to Argentina · Bombardier Capital IncN866MADehavilland DHC-8-102 · S/N 366Cancelled Jul 1, 1998 · Exported to Argentina · Bombardier Capital IncN83WNLearjet 31A · S/N 081Cancelled Apr 20, 1998 · Exported to Argentina · Bombardier Capital IncN992RERotec Engineering PANTHER 2 PLUS · S/N 4271Cancelled Oct 8, 1997 · Triennial form not returned · Deforge Enterprises Inc DBAN1189XZlin 526 · S/N 1055Cancelled Jul 7, 1997 · Exported to Hungary · Gesoco Industries IncN99KVGates Learjet 55 · S/N 55122Cancelled Mar 14, 1997 · Exported to Canada · Bombardier Capital IncN977ACessna 208 · S/N 20800108Cancelled Apr 5, 1996 · Exported to Australia · Carl Healey & Associates US IncN172MWCessna 172L · S/N 17259723Cancelled Nov 9, 1995 · Exported to Russia · Coy George SN90BCCrowell John K CHRISTEN EAGLE II · S/N 001Cancelled Mar 3, 1994 · Mcgrath Mary JaneN5132GPiper PA-23-250 · S/N 27-7405341Cancelled Feb 1, 1994 · Exported to Hungary · Coy GeorgeN8632JCessna 150G · S/N 15066532Cancelled Nov 15, 1993 · Exported to Hungary · Coy George SN6936XCessna 172B · S/N 17247836Cancelled Jul 15, 1993 · Exported to Lithuania · Coy George SN5718JCessna P206E · S/N P20600618Cancelled Apr 26, 1993 · Exported to Hungary · Coy George SN435CBBouffard Charles J KOLB TWINSTAR · S/N 007Cancelled Sep 9, 1992 · Bouffard Charles JN94416Ercoupe G · S/N 5048Cancelled Sep 4, 1969 · Exported to Canada · Built 1950 · Feraud Larence
Back to Colchester, VT