Wilmington Trust Company Trustee
Earlier aircraft under this name · 200
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 TRUSTEE' OR list_contains(d.other_registrant_names, 'WILMINGTON TRUST COMPANY 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 TRUSTEE' OR list_contains(d.other_registrant_names, 'WILMINGTON TRUST COMPANY 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.
N605SABombardier CL-600-2B16 · S/N 5788N698FTEmbraer ERJ 190-200 LR · S/N 19000698N498AZEmbraer ERJ 190-200 LR · S/N 19000498N420MTHonda HA-420 · S/N 42000263N468KTBoeing 777-333ER · S/N 35256N2864BBoeing 737-86N · S/N 28642N891NWAirbus A321-211 · S/N 6698N470DMBoeing 737-8JP · S/N 41134N478TAAirbus A319-132 · S/N 2339N456AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49561N453UWBoeing 737-4B7 · S/N 24980N454UWBoeing 737-4B7 · S/N 24996N455UWBoeing 737-4B7 · S/N 24997N450UWBoeing 737-4B7 · S/N 24933N931FDouglas DC-9-33F · S/N 47192N625AABoeing 757-223 · S/N 24583N817PHDehavilland DHC-8-102 · S/N 056N818PHDehavilland DHC-8-102 · S/N 058N41063Airbus Industrie A300 B4-605R · S/N 506N13983Airbus Industrie A300 B4 · S/N 092N169AGDehavilland DHC-7-102 · S/N 69N901HADehavilland DHC-7-102 · S/N 42N70074Airbus Industrie A300 B4-605R · S/N 517N633AWAirbus Industrie A320-231 · S/N 82N338AABoeing 767-223 · S/N 22335N904AWBoeing 757-2S7 · S/N 23566N624AABoeing 757-223 · S/N 24582N988AGHawker Beechcraft HAWKER 900XP · S/N HA-0088N622AABoeing 757-223 · S/N 24580N339AABoeing 767-223 · S/N 22336N335AABoeing 767-223 · S/N 22333N7508Mcdonnell Douglas DC-9-82(MD-82) · S/N 49802N612AABoeing 757-223 · S/N 24488N945FMcdonnell Douglas DC-9-33F · S/N 47279N323AABoeing 767-223 · S/N 22324N313UABoeing 737-322 · S/N 23674N617AMBoeing 757-223 · S/N 24525N452UWBoeing 737-4B7 · S/N 24979N445USBoeing 737-4B7 · S/N 24863N942AXMcdonnell Douglas DC-9-31 · S/N 47552N325UABoeing 737-322 · S/N 23957N902HADehavilland DHC-7-102 · S/N 52N420AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49332N422AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49334N314FEMcdonnell Douglas MD-10-30F · S/N 48312N451UWBoeing 737-4B7 · S/N 24934N495AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49733N785CABombardier CL-600-2B19 · S/N 7326N318UABoeing 737-322 · S/N 23950N90070Airbus Industrie A300 B4-605R · S/N 513
Back to Wilmington Trust Company Trustee