Valiair Limited Company Trustee
Registered aircraft · 57
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 = 'VALIAIR LIMITED COMPANY TRUSTEE' OR list_contains(g.other_registrant_names, 'VALIAIR LIMITED 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 = 'VALIAIR LIMITED COMPANY TRUSTEE' OR list_contains(g.other_registrant_names, 'VALIAIR LIMITED 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.
N101PQCessna 210B · S/N 21057932N119HPPiper PA-28-140 · S/N 28-21570N131SRCirrus Design SR22 · S/N 1887N147DCDouglas C-47A · S/N 19347N20213Cessna 172M · S/N 17261099N222HWCirrus Design SR20 · S/N 1163N228JDPilatus PC-12 · S/N 220N23358Yakovlev YAK 52 · S/N 833107N233DYCirrus Design SR20 · S/N 11705N240SPCirrus Design SR20 · S/N 11613N260RCLearjet 31A · S/N 080N2801ZPiper PA-22-160 · S/N 22-6794N292RSCessna 414A · S/N 414A0482N321WCirrus Design SR20 · S/N 1727N332NEurocopter France AS332L1 · S/N 2408N336DSDiamond Aircraft Ind DA 40 · S/N 40.365N351PMPiper PA 46-350P · S/N 4636840N368EVAerospatiale AS332L1 · S/N 2179N377CSocata TB21 · S/N 2222N3FRCessna R172E · S/N R172-0237N4095ACessna A185F · S/N 18503910N4135JPiper PA-32R-301 · S/N 3246127N441GACessna 441 · S/N 441-0234N442DZCessna T206H · S/N T20608453N444PCPiper PA-31T · S/N 31T-7920066N44829Robinson Helicopter R66 · S/N 0034N449TAPiper PA-31 · S/N 31-480N4585SBeech A36 · S/N E-752N458TPQuest KODIAK 100 · S/N 100-0050N466HRRobinson Helicopter R66 · S/N 1127N479RATextron 525 · S/N 525-1175N525RJPiper PA-32R-300 · S/N 32R7780278N53181Boeing D75N1 · S/N 75-3963N53CXRotorsport UK ROTORSPORT UK CAVALO · S/N RSUK/CAVP/004N550FEclipse Aerospace EA500 · S/N 550-1001N5554DPiper PA-28-180 · S/N 28-2228N5554EPiper PA-28-140 · S/N 28-7725152N567PMCirrus Design SR22T · S/N 1748N56PVPiper PA-46-600TP · S/N 4698162N580HRCessna 182S · S/N 18280141N580WBTextron 182T · S/N 18283131N60728Piper AEROSTAR 601P · S/N 61P07007963335N6248SCessna T182T · S/N T18208849N6255QCessna 401A · S/N 401A0055N634SWBoeing 737-3H4 · S/N 27937N650DBCessna 414A · S/N 414A0853N6664CBeech 35-C33 · S/N CD-890N727FMBell 407 · S/N 53555N755APTextron G58 · S/N TH-2470N75DJBeech P35 · S/N D-7088
Back to Valiair Limited Company Trustee