Tsi Holdco Inc
Registered aircraft · 80
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 = 'TSI HOLDCO INC' OR list_contains(g.other_registrant_names, 'TSI HOLDCO INC') 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 = 'TSI HOLDCO INC' OR list_contains(g.other_registrant_names, 'TSI HOLDCO INC') 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.
N107FBMikoyan-Gurevich MIG-3 · S/N SEAV.02.0154N108ZZNord 1002 · S/N 258N109FFHispano-Aviacion S A La HA-1112M-1-L · S/N C.4K-64N109GYMesserschmitt BF 109 G4 · S/N 19257N111FSMorane Saulnier MORANE 502 · S/N 204N114KADehavilland Canada DH98 MOSQUITO FBMK26 · S/N KA114N120BHNaval Aircraft Factory N3N-3 · S/N 2892N129PTFairchild M-62A · S/N T43-7230N14TJBrown Timothy J FOKKER DR I · S/N DR1HBN153RPPolikarpov I-153 · S/N 6316N1639PPolikarpov I-16 TYPE 24 · S/N 2421028N183FWFocke Wulf FW44J · S/N 183N190BRRussell Robert R JR 190BR · S/N 005N1914SAim Atlanta 1 1/2 STRUTTER · S/N 002N1918CGarcia Robert A NIEUPORT 17 · S/N 1N1918FFokker D-7 · S/N 1N1918PPeterson FOKKER D-VII · S/N 6880N1934DDehavilland DH89A RAPIDE · S/N 6264N1941PCurtiss Wright P-40E · S/N 1025N208KNord 1101 · S/N 162N22518North American-Medore SNJ-4 · S/N 88-13630N23464Piper J3C-65 · S/N 3196N23827Douglas AD-4 · S/N 123827N262MFLegend Flyers ME 262-B1-A · S/N 501243N26PXMayocraft P-26D · S/N 32-06N26RPDouglas A-26B · S/N 6874N2776Culver PQ-14B · S/N N-946N27XZBrucken William L NIEUPORT 27 · S/N 100603N2880DBeech C-45 · S/N 39926N29WRRedfern Walter W FOKKER D VI · S/N 2620N315EGrumman FM-2 · S/N 47030N352JUConstrucciones Aeronauticas CASA-352-L · S/N T2B-176N35PHHenry Patrick FOKKER DR.1 · S/N 1981-AN3602Polikarpov PO-2 · S/N 0717N3815RPolikarpov I-15 BIS · S/N 3994N38863Thomas Morse S4C · S/N 38663N38BUAG Fur Dornier-Flugzeuge BUCKER BU 133C · S/N 38N39FFBell P-39F · S/N 15-554N4088HArganbright R/Arganbright V SOPWITH 1 1/2 STRTTR · S/N RA003N413BTConvair BT-13A · S/N 6528N415MLLavochkin LA-9 · S/N 828N422RCCochran Craig SPAD 13 BIPLANE · S/N 13N4247LFocke Wulf FW 190-A8 · S/N 350177N42FMMorane-Saulnier MS 500 · S/N 751N42YKYakovlev YAK-3M · S/N 0470103N44VYCoolbaugh Robert J ELY-CURTISS · S/N 01BCN46FMFiat FIAT G-46-B · S/N 53091N46RLGoodyear FG1D · S/N 92508N482UTWilliams Flugzeugbau ALBATROSS DVA · S/N 0034N51462Laister-Kauffman LK-10A · S/N 126
Back to Tsi Holdco Inc