Skip to content

World Trade Enterprises Inc

Earlier aircraft under this name · 32

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 = 'WORLD TRADE ENTERPRISES INC' OR list_contains(d.other_registrant_names, 'WORLD TRADE ENTERPRISES 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 = 'WORLD TRADE ENTERPRISES INC' OR list_contains(d.other_registrant_names, 'WORLD TRADE ENTERPRISES 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 = 'WORLD TRADE ENTERPRISES INC' OR list_contains(d.other_registrant_names, 'WORLD TRADE ENTERPRISES 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.

N3172HNorth American T-6G · S/N 49-3403Cancelled Dec 19, 2016 · Exported to Brazil · Built 1951 · Los Angeles, CA N63EBBeech Acft B200T · S/N BT32Cancelled Aug 10, 2015 · Exported to Brazil · Torrance, CA N7059NRobinson Helicopter R44 II · S/N 13775Cancelled Mar 9, 2015 · Exported to Brazil · Torrance, CA N22065Cessna 182A · S/N 51342Cancelled Oct 8, 2014 · Exported to Kenya · Torrance, CA N7102URobinson Helicopter R66 · S/N 0410Cancelled Sep 10, 2014 · Exported to Brazil · Built 2013 · Torrance, CA N110LNEurocopter AS 350 B2 ECUREUIL · S/N 2828Cancelled Apr 17, 2014 · Exported to Brazil · Built 1994 · Torrence, CA N912VRAgusta S P A A109K2 · S/N 10028Cancelled Dec 23, 2013 · Exported to Brazil · Built 1996 · Torrance, CA N757UVCessna 152 · S/N 15280022Cancelled May 16, 2013 · Exported to Brazil · Built 1977 · Torrance, CA N7079WRobinson Helicopter R66 · S/N 0290Cancelled Mar 11, 2013 · Exported to Brazil · Torrance, CA N6224SCessna 150G · S/N 15067024Cancelled Mar 4, 2013 · Exported to Brazil · Built 1967 · Torrance, CA N7040NRobinson Helicopter R66 · S/N 0182Cancelled Feb 5, 2013 · Exported to Brazil · Built 2012 · Torrance, CA N433FXLearjet 45 · S/N 192Cancelled Dec 13, 2012 · Exported to Brazil · Built 2002 · Torrance, CA N303WTRobinson Helicopter R44 II · S/N 13347Cancelled Oct 30, 2012 · Exported to Brazil · Torrance, CA N3004YCessna 182E · S/N 18254004Cancelled Sep 25, 2012 · Exported to Brazil · Built 1962 · Torrance, CA N701LVAerospatiale AS350BA · S/N 1546Cancelled Nov 10, 2011 · Exported to Brazil · Built 1982 · Torrance, CA N22VMPiper PA 46-350P · S/N 4636116Cancelled Nov 1, 2011 · Exported to Mexico · Built 1997 · Torrance, CA N4485ZRobinson Helicopter R44 II · S/N 13176Cancelled Sep 12, 2011 · Exported to Brazil · Torrance, CA N759FBCessna 182Q · S/N 18265949Cancelled Aug 23, 2011 · Exported to Brazil · Built 1977 · Torrance, CA N44828Robinson Helicopter R44 II · S/N 13149Cancelled Jul 28, 2011 · Exported to Brazil · Torrance, CA N960SDEurocopter AS 350 B2 · S/N 3501Cancelled Jun 27, 2011 · Exported to Brazil · Built 2001 · Torrance, CA N993ABRobinson Helicopter R44 II · S/N 12721Cancelled May 9, 2011 · Exported to Brazil · Built 2009 · Torrance, CA N4214ARobinson Helicopter R44 II · S/N 13111Cancelled May 6, 2011 · Exported to Brazil · Built 2011 · Torrance, CA N84PNBeech 200 · S/N BB-835Cancelled Mar 21, 2011 · Exported to Brazil · Built 1981 · Torrance, CA N7508URobinson Helicopter R22 BETA · S/N 3344Cancelled Mar 1, 2011 · Exported to Brazil · Built 2002 · Torrance, CA N407SBBell 206B · S/N 4625Cancelled Feb 8, 2011 · Exported to Brazil · Built 2007 · Torrance, CA N4516YRobinson Helicopter R22 BETA · S/N 4469Cancelled Jul 20, 2010 · Exported to Brazil · Built 2010 · Torrance, CA N300JVPiper PA-34-220T · S/N 3449032Cancelled Feb 9, 2010 · Exported to Brazil · Built 1997 · Torrance, CA N43944Robinson Helicopter R44 · S/N 1996Cancelled Nov 4, 2009 · Exported to Brazil · Torrance, CA N42336Robinson Helicopter R44 II · S/N 12604Cancelled Aug 24, 2009 · Exported to Brazil · Built 2009 · Torrance, CA N42217Robinson Helicopter R44 II · S/N 12320Cancelled Aug 17, 2009 · Exported to Brazil · Built 2008 · Torrance, CA N4864KCessna P210N · S/N P21000347Cancelled Oct 16, 2008 · Exported to Brazil · Built 1979 · Torrance, CA N685RCLearjet 31A · S/N 149Cancelled May 6, 2008 · Exported to Brazil · Built 1998 · Torrance, CA

Back to World Trade Enterprises Inc