Aviation Trust Company LLC Trustee
Registered aircraft · 68
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 = 'AVIATION TRUST COMPANY LLC TRUSTEE' OR list_contains(g.other_registrant_names, 'AVIATION TRUST COMPANY LLC 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 = 'AVIATION TRUST COMPANY LLC TRUSTEE' OR list_contains(g.other_registrant_names, 'AVIATION TRUST COMPANY LLC 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.
N104VVGrumman G-1159 · S/N 53N1125AIsrael Aircraft Industries 1125 WESTWIND ASTRA · S/N 051N1149LMooney M20K · S/N 25-0608N12NNAmerican Eurocopter AS350B2 · S/N 4579N144GGRobinson Helicopter R44 II · S/N 14212N1565SColumbia Aircraft Mfg LC41-550FG · S/N 41761N1810XBeech 58 · S/N TH1266N1957NTextron 525 · S/N 525-1182N197JPRobinson Helicopter R44 II · S/N 11395N204NDPiper PA-28R-201 · S/N 2844070N2069QCessna 510 · S/N 510-0137N20PJRaytheon Corporate Jets HAWKER 800 · S/N 258275N21DQEmbraer Executive EMB-500 · S/N 50000395N240RTCessna 421B · S/N 421B0863N245JRPiper PA-42-720 · S/N 425501019N252NJAirbus Industrie A320-231 · S/N 252N25DABeech B-60 · S/N P-483N260SPOliver Steven R PITTS S-2S · S/N 1114CN274GVTextron B200GT · S/N BY-345N342EDCirrus Design SR22T · S/N 0485N3674JCessna 150G · S/N 15064974N397MGRaytheon 400A · S/N RK-259N4074EEurocopter AS 350 B2 · S/N 2950N407NPBell Textron Canada 407 · S/N 56407N411JECanadair CL-600-2B16 · S/N 5011N430WHBell 430 · S/N 49114N457GVTextron 525B · S/N 525B0691N46ERPiper PA-23-250 · S/N 27-3649N487DTRaytheon 390 · S/N RB-85N4995ASikorsky UH-60A · S/N 79-23328N50SSRaytheon 58 · S/N TH-1961N524MMCessna T210N · S/N 21063717N54346Cessna 172P · S/N 17274959N550ZKCessna U206G · S/N U20604466N5613UPiper PA-28-140 · S/N 28-26543N584DWBeechcraft G58 · S/N TH-2394N593RGPiper PA-34-220T · S/N 3447022N621PBPilatus PC-9M · S/N 621N6292SCessna 150G · S/N 15067092N629TCCessna 182T · S/N 18281629N637PADiamond Aircraft Ind DA 40 NG · S/N 40.NC233N642TKEmbraer EMB-135BJ · S/N 145642N663DJPilatus PC-9M · S/N 623N6766FCessna 150F · S/N 15063366N680XPCessna 680 · S/N 680-0282N6998GCessna 150L · S/N 15072498N712MKPiper PA-46-310P · S/N 4608032N71336Cessna 182M · S/N 18259585N714MCCessna 150M · S/N 15079273N718APCessna T210M · S/N 21061857
Back to Aviation Trust Company LLC Trustee