Tvpx Ars Inc Trustee
Earlier aircraft under this name · 129
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 = 'TVPX ARS INC TRUSTEE' OR list_contains(d.other_registrant_names, 'TVPX ARS INC 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 = 'TVPX ARS INC TRUSTEE' OR list_contains(d.other_registrant_names, 'TVPX ARS INC 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.
N650DJGulfstream Aerospace GVI (G650) · S/N 6312N919NXAirbus A321-231 · S/N 02919N610GWGulfstream Aerospace G-IV · S/N 1289N775KSDehavilland DHC-6 · S/N 244N80VLBritish Aerospace BAE JETSTREAM 3101 · S/N 796N40VLBritish Aerospace BAE JETSTREAM 3101 · S/N 779N20077Textron 208B · S/N 208B5923N30ABPilatus PC-12/47E NGX · S/N 2069N464LSTextron 172S · S/N 172S13464N463LSTextron 172S · S/N 172S13463N390ELHawker Beechcraft 390 · S/N RB-284N604BSBombardier CL-600-2B16 · S/N 5560N210GLBeech 1900D · S/N UE-210N650PPBombardier CL-600-2B16(CL-604) · S/N 6051N726EPAgustawestland Philadelphia AW139 · S/N 41611N254GLRaytheon 1900D · S/N UE-254N399JABombardier BD-700-1A11 · S/N 9334N61WCPiaggio Aero Industries P180 · S/N 3001N139RTGulfstream Aerospace GVI (G650ER) · S/N 6433N208TPTextron 208 · S/N 20800604N571SVPilatus PC-24 · S/N 571N605VGBombardier CL-600-2B16 · S/N 5905N810PFCessna 525A · S/N 525A0399N2009GTextron 208B · S/N 208B5893N700CADouglas DC3C · S/N 12438N390AAHawker Beechcraft 390 · S/N RB-293N2900DBombardier BD-700-1A11 · S/N 9243N404ARGulfstream Aerospace GIV-X (G450) · S/N 4223N714JGBombardier BD-700-2A12 · S/N 70014N117DLBell Helicopter Textron 212 · S/N 31165N70XFCanadair CL-600 CHALLENGER · S/N 1032N711LSBombardier BD-700-1A10 · S/N 9476N972JCBombardier BD-700-1A10 · S/N 9727N921SADassault FALCON 2000 · S/N 148N208JMCessna 208B · S/N 208B5100N400ERPiper PA-42-1000 · S/N 425527023N18LSBombardier CL-600-2B16 · S/N 5658N648JGTextron 680A · S/N 680A0048N6884APiper PA-23-250 · S/N 27-7954105N188KQQuest KODIAK 100 · S/N 100-0188N770MSBombardier CL-600-2B16 · S/N 5491N340JGCessna 340 · S/N 340-0502N197KQQuest KODIAK 100 · S/N 100-0197N33WXAgustawestland Philadelphia AW139 · S/N 41321N737FABoeing 737-319 · S/N 25608N208RPTextron 208 · S/N 20800661N11LSBombardier CL-600-2B16 · S/N 5563N159EEEmbraer S A EMB-545 · S/N 55010059N205KQQuest KODIAK 100 · S/N 100-0205N908ARBoeing 747-412F · S/N 28026
Back to Tvpx Ars Inc Trustee