Transatlantic Deliveries Trust
Earlier aircraft under this name · 55
Cancelled registrations that named this owner when they ended, newest first.
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_name = 'TRANSATLANTIC DELIVERIES TRUST' OR list_contains(d.other_registrant_names, 'TRANSATLANTIC DELIVERIES TRUST') 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 = 'TRANSATLANTIC DELIVERIES TRUST' OR list_contains(d.other_registrant_names, 'TRANSATLANTIC DELIVERIES TRUST') 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.
N980PLDaher TBM 700 · S/N 1675N980MKDaher TBM 700 · S/N 1667N980JWDaher TBM 700 · S/N 1659N980VJDaher TBM 700 · S/N 1657N940SNCompagnie Daher TBM 700 · S/N 1345N910BDSocata TBM 700 · S/N 1181N964DHCompagnie Daher TBM 700 · S/N 1624N962FACompagnie Daher TBM 700 · S/N 1620N960PMCompagnie Daher TBM 700 · S/N 1585N95KTCompagnie Daher TBM 700 · S/N 1590N961FACompagnie Daher TBM 700 · S/N 1576N960CVCompagnie Daher TBM 700 · S/N 1569N960FACompagnie Daher TBM 700 · S/N 1563N960RJCompagnie Daher TBM 700 · S/N 1561N964DHCompagnie Daher TBM 700 · S/N 1554N962LDCompagnie Daher TBM 700 · S/N 1521N960AECompagnie Daher TBM 700 · S/N 1475N960AJCompagnie Daher TBM 700 · S/N 1455N960APCompagnie Daher TBM 700 · S/N 1443N940DVCompagnie Daher TBM 700 · S/N 1414N960DHCompagnie Daher TBM 700 · S/N 1409N940BZCompagnie Daher TBM 700 · S/N 1352N940JPCompagnie Daher TBM 700 · S/N 1289N970BCCompagnie Daher TBM 700 · S/N 1271N910KCompagnie Daher TBM 700 · S/N 1269N910BTSocata TBM 700 · S/N 1217N930SMSocata TBM 700 · S/N 1158N930ARSocata TBM 700 · S/N 1127N930TSocata TBM 700 · S/N 1129N900EQSocata TBM 700 · S/N 1091N850EHSocata TBM 700 · S/N 1057N900GESocata TBM 700 · S/N 1074N850DESocata TBM 700 · S/N 1052N850CQSocata TBM 700 · S/N 1045N900BXSocata TBM 700 · S/N 1040N850AQSocata TBM 700 · S/N 1034N850CXSocata TBM 700 · S/N 1018N850ZDSocata TBM 700 · S/N 683N850HCSocata TBM 700 · S/N 663N646XXSocata TBM 700 · S/N 649N850CYSocata TBM 700 · S/N 626N850CVSocata TBM 700 · S/N 615N850JTSocata TBM 700 · S/N 362N850CKSocata TBM 700 · S/N 617N702BMSocata TBM 700 · S/N 2N426TBSocata TBM 700 · S/N 610N850JJSocata TBM 700 · S/N 595N850NRSocata TBM 700 · S/N 583N850SSocata TBM 700 · S/N 580N850BESocata TBM 700 · S/N 558
Back to Transatlantic Deliveries Trust