Wilmington Trust Company Trustee
Registered aircraft · 32
Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.
Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'WILMINGTON TRUST COMPANY TRUSTEE' OR list_contains(g.other_registrant_names, 'WILMINGTON TRUST COMPANY TRUSTEE') ORDER BY g.n_number"
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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'WILMINGTON TRUST COMPANY TRUSTEE' OR list_contains(g.other_registrant_names, 'WILMINGTON TRUST COMPANY TRUSTEE') ORDER BY g.n_number
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.
N1242ZEmbraer EMB-550 · S/N 55020242N17408Boeing 737-9 · S/N 68817N17410Boeing 737-9 · S/N 68810N17414Boeing 737-9 · S/N 68813N179BZAirbus Canada LP BD-500-1A11 · S/N 55063N193ANBoeing 757-223 · S/N 32387N208BZAirbus Canada LP BD-500-1A11 · S/N 55148N25HLGulfstream Aerospace GV-SP (G550) · S/N 5066N302AGBombardier BD-700-2A12 · S/N 70173N317JBEmbraer ERJ 190-100 IGW · S/N 19000363N34535Airbus S A S A321-271NX · S/N 12332N37473Boeing 737-9 · S/N 67749N374QATextron 525C · S/N 525C0374N397NCEmbraer Empresa Brasileira De ERJ 190-100 IGW · S/N 19000151N457FXGulfstream Aerospace GIV-X (G450) · S/N 4154N508KZBoeing 747-4KZF · S/N 36135N550KFGulfstream Aerospace GV-SP (G550) · S/N 5504N642FRAirbus S A S A321-271NX · S/N 11888N646FRAirbus A321-271NX · S/N 11952N731NKAirbus S A S A321-271NX · S/N 11937N749BMEmbraer ERJ 170-100 SE · S/N 17000133N763CCEmbraer ERJ 170-100 STD · S/N 17000300N764JDEmbraer ERJ 170-100 STD · S/N 17000302N776MSEmbraer ERJ 170-100 SE · S/N 17000050N777AZBoeing 777-232 · S/N 29743N797TDGulfstream Aerospace GVIII-G700 · S/N 87104N842AABoeing 787-9 · S/N 66007N844MCBoeing 787-9 · S/N 66009N854NNBoeing 737-823 · S/N 33214N8738KBoeing 737-8 · S/N 60229N930WNBoeing 737-7H4 · S/N 36636N951AVAirbus A320-214 · S/N 3574
Back to Wilmington Trust Company Trustee