Skip to content

Bombardier Capital Inc

Earlier aircraft under this name · 41

Cancelled registrations that named this owner when they ended, newest first.

Query with SQL

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_name = 'BOMBARDIER CAPITAL INC' OR list_contains(d.other_registrant_names, 'BOMBARDIER CAPITAL INC') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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_name = 'BOMBARDIER CAPITAL INC' OR list_contains(d.other_registrant_names, 'BOMBARDIER CAPITAL INC')
  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.

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_name = 'BOMBARDIER CAPITAL INC' OR list_contains(d.other_registrant_names, 'BOMBARDIER CAPITAL INC')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N592MLBombardier CL-600-2B19 · S/N 7410Cancelled Oct 18, 2017 · Built 2000 · Wichita, KS N17337Bombardier CL-600-2B19 · S/N 7337Cancelled Mar 21, 2017 · First renewal notice · Built 1999 · Wichita, KS N510APBombardier CL-600-2D24 · S/N 15063Cancelled Oct 27, 2014 · Exported to Canada · Colchester, VT N77302Bombardier CL-600-2B19 · S/N 7302Cancelled May 8, 2013 · Built 1999 · Colchester, VT N33WQBombardier DHC-8-402 · S/N 4033Cancelled May 8, 2012 · Exported to Canada · Built 2001 · Colchester, VT N509DCBombardier CL-600-2D24 · S/N 15001Cancelled Apr 12, 2011 · Exported to Canada · Colchester, VT N231ESBoeing DHC-8-102 · S/N 231Cancelled Jun 15, 2010 · Non-citizen corporation, flight hours not reported · Colchester, VT N565ESBombardier CL-600-2D24 · S/N 15065Cancelled Mar 24, 2010 · Exported to Canada · Colchester, VT N847EXBombardier DHC-8-103 · S/N 333Cancelled Jan 2, 2008 · Exported to Canada · Built 1992 · Colchester, VT N288DHDehavilland DHC-8-102 · S/N 317Cancelled Sep 5, 2007 · Exported to Canada · Colchester, VT N812LRDehavilland DHC-8-102 · S/N 253Cancelled May 3, 2007 · Exported to Canada · Colchester, VT N844EXDehavilland DHC-8-106 · S/N 339Cancelled Nov 6, 2006 · Exported to Canada · Built 1992 · Colchester, VT N848EXDehavilland DHC-8-106 · S/N 331Cancelled Nov 3, 2006 · Exported to Canada · Built 1992 · Colchester, VT N652MLBombardier CL-600-2B19 · S/N 7036Cancelled Jun 2, 2006 · Exported to Canada · Built 1994 · Colchester, VT N849EXDehavilland DHC-8-102 · S/N 337Cancelled Mar 1, 2006 · Exported to Canada · Built 1992 · Colchester, VT N840EXDehavilland DHC-8-102 · S/N 327Cancelled Feb 2, 2006 · Exported to Canada · Built 1992 · Colchester, VT N536DSBombardier DHC-8-402 · S/N 4044Cancelled Nov 14, 2005 · Exported to Canada · Built 2001 · Colchester, VT N533DSBombardier DHC-8-402 · S/N 4041Cancelled Oct 14, 2005 · Exported to Canada · Built 2001 · Colchester, VT N535DSBombardier DHC-8-402 · S/N 4043Cancelled Jul 15, 2004 · Exported to Canada · Built 2001 · Colchester, VT N532DSBombardier DHC-8-402 · S/N 4040Cancelled Jun 25, 2004 · Exported to Canada · Colchester, VT N538DSDehavilland DHC-8-311 · S/N 323Cancelled Oct 30, 2003 · Exported to Bahamas · Built 1992 · Colchester, VT N454LPLearjet 45 · S/N 034Cancelled Sep 19, 2003 · Exported to Mexico · Built 1999 · Colchester, VT N64320Boeing 727-231 · S/N 20053Cancelled Sep 10, 2003 · Exported to Swaziland · Built 1969 · Colchester, VT N305DCBoeing Of Canada/Dehav Div DHC-8-311 · S/N 305Cancelled Jul 9, 2002 · Exported to Antigua and Barbuda · Colchester, VT N802SADehavilland DHC-8-311 · S/N 250Cancelled Jun 27, 2002 · Exported to Antigua and Barbuda · Built 1990 · Colchester, VT N819MABoeing DHC-8-102 · S/N 251Cancelled Mar 27, 2002 · Exported to Antigua and Barbuda · Colchester, VT N60LJLearjet 60 · S/N 164Cancelled Feb 8, 2001 · Exported to Brazil · Colchester, VT N152CAEmbraer EMB-120RT · S/N 120.152Cancelled Jan 11, 2001 · Exported to Australia · Colchester, VT N286BCDehavilland DHC-8-102 · S/N 268Cancelled Aug 15, 2000 · Exported to Antigua and Barbuda · Colchester, VT N285BCDehavilland DHC-8-311 · S/N 410Cancelled Jul 31, 2000 · Exported to Antigua and Barbuda · Colchester, VT N823PHDehavilland DHC-8-102 · S/N 110Cancelled Apr 21, 2000 · Exported to Jamaica · Colchester, VT N821PHDehavilland DHC-8-102 · S/N 104Cancelled Apr 14, 2000 · Exported to Jamaica · Colchester, VT N477DCDehavilland DHC-8-315 · S/N 420Cancelled Feb 1, 2000 · Exported to South Africa · Colchester, VT N848MADehavilland DHC-8-102 · S/N 346Cancelled Jun 28, 1999 · Exported to Australia · Colchester, VT N864MADehavilland DHC-8-102 · S/N 363Cancelled Jul 1, 1998 · Exported to Argentina · Colchester, VT N866MADehavilland DHC-8-102 · S/N 366Cancelled Jul 1, 1998 · Exported to Argentina · Colchester, VT N83WNLearjet 31A · S/N 081Cancelled Apr 20, 1998 · Exported to Argentina · Colchester, VT N99KVGates Learjet 55 · S/N 55122Cancelled Mar 14, 1997 · Exported to Canada · Colchester, VT N760AQGates Learjet 55 · S/N 017Cancelled Jun 14, 1994 · Exported to Germany · Burlington, VT N407MRGates Learjet 35A · S/N 407Cancelled May 6, 1994 · Exported to Canada · Burlington, VT N801AWDehavilland DHC-8-102 · S/N 067Cancelled Nov 2, 1993 · Exported to Australia · Burlington, VT

Back to Bombardier Capital Inc