Wilmington Trust Co Trustee
Earlier aircraft under this name · 394
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 CO TRUSTEE' OR list_contains(d.other_registrant_names, 'WILMINGTON TRUST CO 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 CO TRUSTEE' OR list_contains(d.other_registrant_names, 'WILMINGTON TRUST CO 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.
N238HRBoeing 737-86N · S/N 36812N775HRBoeing 737-86D · S/N 35775N288ZGulfstream Aerospace GVIII-G800 · S/N 88004N913NKAirbus A320-271N · S/N 7757N861DABoeing 777-232 · S/N 29952N207RBombardier CL-600-2B16 · S/N 5882N324JBEmbraer ERJ 190-100 IGW · S/N 19000388N403SVAtr-Gie Avions De Trnsp Region ATR42-500 · S/N 1219N782BABoeing 737-8 · S/N 67926N907NKAirbus A320-271N · S/N 8275N309GTBoeing 737-4Q8 · S/N 26334N700SVAtr-Gie Avions De Trnsp Rgnl ATR 72-212A · S/N 1548N316JBEmbraer ERJ 190-100 IGW · S/N 19000292N402SVAtr-Gie Avions De Trnsp Region ATR42-500 · S/N 1217N304JBEmbraer ERJ 190-100 IGW · S/N 19000257N401SVAtr-Gie Avions De Trnsp Region ATR42-500 · S/N 1216N769BABoeing 737-8 · S/N 67925N239HRBoeing 737-8FH · S/N 35089N102BZEmbraer ERJ 190-100 IGW · S/N 19000055N108BZEmbraer ERJ 190-100 IGW · S/N 19000070N236HRBoeing 737-8FH · S/N 29640N294JBEmbraer ERJ 190-100 IGW · S/N 19000185N306GTBoeing 737-45D · S/N 27157N307JBEmbraer ERJ 190-100 IGW · S/N 19000286N703SVAtr-Gie Avions De Trnsp Rgnl ATR 72-212A · S/N 1555N486HFEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000338N702SVAtr-Gie Avions De Trnsp Rgnl ATR 72-212A · S/N 1553N823AWAirbus Industrie A319-132 · S/N 1463N486FMEmbraer-Empresa Brasileira De ERJ 170-200 LR · S/N 17000339N3013CAirbus A321-231 · S/N 3013N427LLearjet 45 · S/N 427N192ANBoeing 757-223 · S/N 32386N712DAGulfstream Aerospace GVI · S/N 6035N3005MAirbus A321-231 · S/N 3005N919AZAtr-Gie Avions De Trnsp Rgnl ATR 72-212A · S/N 0853N2974CAirbus A321-231 · S/N 2974N178JBEmbraer ERJ 190-100 IGW · S/N 19000004N241NAEmbraer ERJ 190-100 IGW · S/N 19000041N781FSSikorsky S-76C · S/N 760479N1018JAtr-Gie Avions De Trnsp Region ATR42-500 · S/N 1018N1103CAtr-Gie Avions De Trnsp Rgnl ATR 72-212A · S/N 1103N1112GAtr-Gie Avions De Trnsp Rgnl ATR 72-212A · S/N 1112N8601CBoeing 737-8H4 · S/N 38874N198BZEmbraer S A ERJ 190-200 IGW · S/N 19000692N109MAgusta A109S · S/N 22063N420SKBombardier CL-600-2B16 · S/N 5590N434AZEmbraer ERJ 190-200 · S/N 19000434N491AREmbraer ERJ 190-200 LR · S/N 19000491N104ASMcdonnell Douglas Helicopter 369E · S/N 0318EN986AZEmbraer S A ERJ 190-200 IGW · S/N 19000386
Back to Wilmington Trust Co Trustee