Wilmington Trust Company Owner Trustee
Earlier aircraft under this name · 21
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 = 'WILMINGTON TRUST COMPANY OWNER TRUSTEE' OR list_contains(d.other_registrant_names, 'WILMINGTON TRUST COMPANY OWNER TRUSTEE') 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 = 'WILMINGTON TRUST COMPANY OWNER TRUSTEE' OR list_contains(d.other_registrant_names, 'WILMINGTON TRUST COMPANY OWNER TRUSTEE') 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.
N564WNBoeing 737-73V · S/N 30244N688DREmbraer ERJ 190-200 LR · S/N 19000688N9413TMcdonnell Douglas DC-9-83(MD-83) · S/N 53188N606SAAirship Industries UK SKYSHIP 600-08 · S/N 121506N754PRBoeing 747-469 · S/N 27663N304WABoeing 737-347 · S/N 23345N824PHBoeing DHC-8-102 · S/N 157N192AJMcdonnell Douglas DC-9-83(MD-83) · S/N 53192N2620Dehavilland DHC-7-102 · S/N 26N117KCBoeing 747-300 SERIES · S/N 23028N240ATDassault/Sud FAN JET FALCON SER E · S/N 240N262GEAirbus Industrie A300 B4-203 · S/N 262N876UMBoeing 727-230 · S/N 20430N63063Boeing 727-2Q4 · S/N 22425N81028Lockheed L-1011-385-1-15 · S/N 193B1108N570UPSwearingen SA227-AT · S/N AT570N686AVFairchild SA227-AC · S/N AC686N703AFokker F.27MK 500 · S/N 10503N743AFokker F.27MK 500 · S/N 10550N100CQBoeing DHC-8-301 · S/N 100N480RXAirbus Industrie A320-231 · S/N 480
Back to Wilmington Trust Company Owner Trustee