Tvpx Ars Inc Trustee
Registered aircraft · 124
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 = 'TVPX ARS INC TRUSTEE' OR list_contains(g.other_registrant_names, 'TVPX ARS INC 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 = 'TVPX ARS INC TRUSTEE' OR list_contains(g.other_registrant_names, 'TVPX ARS INC 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.
N100WXEmbraer-Empresa Brasileira De EMB-500 · S/N 50000037N104ARGulfstream Aerospace GVII-G500 · S/N 72123N1073PEmbraer S A ERJ 190-200 IGW · S/N 19000107N116MBCessna 650 · S/N 650-7081N121LHPiper PA-42-720 · S/N 425501049N123EBBombardier BD-700-1A10 · S/N 9167N124ALCompagnie Daher TBM 700 · S/N 1606N132JMCirrus Design SR22 · S/N 10631N139AKAgustawestland Philadelphia AW139 · S/N 41565N139WAgustawestland Philadelphia AW139 · S/N 41612N1492JDassault FALCON 2000EX · S/N 62N15VXDassault-Breguet FALCON 50 · S/N 158N168NWGulfstream Aerospace GVI (G650ER) · S/N 6225N169HBHawker Beechcraft B200GT · S/N BY-169N16KBCanadair CL-600-2B16 · S/N 5066N175KBCessna 401B · S/N 401B0206N186CMRaytheon 400A · S/N RK-248N191CSRaytheon 1900D · S/N UE-392N1923TTextron B300 · S/N FL-1266N1FGulfstream Aerospace GVI (G650) · S/N 6076N1FCIai GULFSTREAM G280 · S/N 2079N200XCBeech B200 · S/N BB-1061N201CEGulfstream Aerospace GVI (G650ER) · S/N 6074N215BVEmbraer EMB-550 · S/N 55000021N221LCCessna 680 · S/N 680-0228N230AVCostruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 030N231CEGulfstream Aerospace GV-SP (G550) · S/N 5232N241CEGulfstream Aerospace GVI (G650ER) · S/N 6310N24962Piper J3C-65 · S/N 3568N24QACessna 560 · S/N 560-0762N251JJPilatus PC-12/47 · S/N 701N257AGulfstream Aerospace GV-SP (G550) · S/N 5571N25AXEpic E1000 · S/N K115N261AHCessna 680 · S/N 680-0261N288DLBell Helicopter Textron 212 · S/N 32125N2FHSikorsky S-70C · S/N 701029N300NZBombardier BD-100-1A10 · S/N 20397N303TGEmbraer Executive EMB-505 · S/N 50500559N309QSikorsky S-92A · S/N 920309N30WXAgusta Aerospace AW139 · S/N 41223N310LJLearjet 45 · S/N 031N350WSHawker Beechcraft B300 · S/N FL-763N355GBTextron B300 · S/N FL-1273N365LGGulfstream Aerospace GVI (G650) · S/N 6049N376FXEmbraer Executive EMB-505 · S/N 50500447N39FMGulfstream Aerospace GV-SP (G550) · S/N 5412N3LLGulfstream Aerospace GV-SP (G550) · S/N 5080N3WAgusta Aerospace AW139 · S/N 41211N403KTStratos 714 · S/N S714-100N404NABombardier BD-700-1A11 · S/N 9356
Back to Tvpx Ars Inc Trustee