Wilmington Trust Co Trustee
Registered aircraft · 628
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 CO TRUSTEE' OR list_contains(g.other_registrant_names, 'WILMINGTON TRUST CO 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 CO TRUSTEE' OR list_contains(g.other_registrant_names, 'WILMINGTON TRUST CO 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.
N101NNAirbus Industrie A321-231 · S/N 5834N103NNAirbus A321-231 · S/N 5884N109AZAgustawestland AW109SP · S/N 22223N111CCCanadair CL-600-2B16 · S/N 5192N114BZEmbraer Empresa Brasileira De ERJ 190-100 IGW · S/N 19000092N115BZEmbraer ERJ 190-100 IGW · S/N 19000096N116BZEmbraer Empresa Brasileira De ERJ 190-100 IGW · S/N 19000101N120AHPilatus PC-12/47E · S/N 1582N120BZEmbraer Empresa Brasileira De ERJ 190-100 IGW · S/N 19000115N121RSBombardier BD-700-2A12 · S/N 70042N122GAGulfstream Aerospace GVIII-G700 · S/N 87022N123QBombardier BD-100-1A10 · S/N 20616N126BZEmbraer Empresa Brasileira De ERJ 190-100 IGW · S/N 19000124N128BZEmbraer ERJ 190-100 IGW · S/N 19000132N140QSBombardier BD-700-1A11 · S/N 60205N1415NGulfstream Aerospace GVI (G650ER) · S/N 6149N14528Airbus S A S A321-271NX · S/N 12354N14540Airbus S A S A321-271NX · S/N 12489N14545Airbus S A S A321-271NX · S/N 12633N14553Airbus S A S A321-271NX · S/N 12841N14569Airbus S A S A321-271NX · S/N 13013N156TMRaytheon B300 · S/N FL-518N159JAGulfstream Aerospace GVI (G650ER) · S/N 6288N161RSRalph Starr SUPER SPORT · S/N KA10183170N17254Boeing 737-8 · S/N 43436N17262Boeing 737-8 · S/N 66594N17264Boeing 737-8 · S/N 66596N17265Boeing 737-8 · S/N 64454N172AJBoeing 757-223 · S/N 32400N17310Boeing 737-8 · S/N 67566N17314Boeing 737-8 · S/N 67569N17321Boeing 737-8 · S/N 67577N17333Boeing 737-8 · S/N 67587N17406Boeing 737-9 · S/N 68815N17407Boeing 737-9 · S/N 68816N17411Boeing 737-9 · S/N 68819N17413Boeing 737-9 · S/N 68812N17467Boeing 737-9 · S/N 67659N17468Boeing 737-9 · S/N 67660N17475Boeing 737-9 · S/N 67666N17479Boeing 737-9 · S/N 67675N17529Boeing 737-9 · S/N 64503N175BZAirbus Canada LP BD-500-1A11 · S/N 55058N176BZAirbus Canada LP BD-500-1A11 · S/N 55060N176KHGulfstream Aerospace GVI (G650ER) · S/N 6406N177XFAirbus A319-112 · S/N 2836N178BZAirbus Canada LP BD-500-1A11 · S/N 55062N179UWAirbus Industrie A321-211 · S/N 1521N180USAirbus Industrie A321-211 · S/N 1525N181BZAirbus Canada LP BD-500-1A11 · S/N 55074
Back to Wilmington Trust Co Trustee