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.

N107FBMikoyan-Gurevich MIG-3 · S/N SEAV.02.0154Built 1944 · Virginia Beach, VAN108ZZNord 1002 · S/N 258Built 1945 · Virginia Beach, VAN109FFHispano-Aviacion S A La HA-1112M-1-L · S/N C.4K-64Virginia Beach, VAN109GYMesserschmitt BF 109 G4 · S/N 19257Built 1943 · Virginia Beach, VAN111FSMorane Saulnier MORANE 502 · S/N 204Built 1941 · Virginia Beach, VAN114KADehavilland Canada DH98 MOSQUITO FBMK26 · S/N KA114Built 1945 · Virginia Beach, VAN120BHNaval Aircraft Factory N3N-3 · S/N 2892Built 1941 · Virginia Beach, VAN129PTFairchild M-62A · S/N T43-7230Built 1943 · Virginia Beach, VAN14TJBrown Timothy J FOKKER DR I · S/N DR1HBBuilt 1990 · Virginia Beach, VAN153RPPolikarpov I-153 · S/N 6316Built 1938 · Virginia Beach, VAN1639PPolikarpov I-16 TYPE 24 · S/N 2421028Built 1939 · Virginia Beach, VAN183FWFocke Wulf FW44J · S/N 183Built 1937 · Virginia Beach, VAN190BRRussell Robert R JR 190BR · S/N 005Built 2009 · Virginia Beach, VAN1914SAim Atlanta 1 1/2 STRUTTER · S/N 002Virginia Beach, VAN1918CGarcia Robert A NIEUPORT 17 · S/N 1Built 2011 · Virginia Beach, VAN1918FFokker D-7 · S/N 1Built 1968 · Virginia Beach, VAN1918PPeterson FOKKER D-VII · S/N 6880Built 1991 · Virginia Beach, VAN1934DDehavilland DH89A RAPIDE · S/N 6264Built 1934 · Virginia Beach, VAN1941PCurtiss Wright P-40E · S/N 1025Built 1941 · Virginia Beach, VAN208KNord 1101 · S/N 162Built 1944 · Virginia Beach, VAN22518North American-Medore SNJ-4 · S/N 88-13630Virginia Beach, VAN23464Piper J3C-65 · S/N 3196Built 1939 · Virginia Beach, VAN23827Douglas AD-4 · S/N 123827Built 1949 · Virginia Beach, VAN262MFLegend Flyers ME 262-B1-A · S/N 501243Built 2011 · Virginia Beach, VAN26PXMayocraft P-26D · S/N 32-06Built 2006 · Virginia Beach, VAN26RPDouglas A-26B · S/N 6874Built 1956 · Virginia Beach, VAN2776Culver PQ-14B · S/N N-946Virginia Beach, VAN27XZBrucken William L NIEUPORT 27 · S/N 100603Built 2005 · Virginia Beach, VAN2880DBeech C-45 · S/N 39926Virginia Beach, VAN29WRRedfern Walter W FOKKER D VI · S/N 2620Built 1996 · Virginia Beach, VAN315EGrumman FM-2 · S/N 47030Built 1952 · Virginia Beach, VAN352JUConstrucciones Aeronauticas CASA-352-L · S/N T2B-176Built 1949 · Virginia Beach, VAN35PHHenry Patrick FOKKER DR.1 · S/N 1981-ABuilt 1984 · Virginia Beach, VAN3602Polikarpov PO-2 · S/N 0717Built 1936 · Virginia Beach, VAN3815RPolikarpov I-15 BIS · S/N 3994Built 1938 · Virginia Beach, VAN38863Thomas Morse S4C · S/N 38663Built 1917 · Virginia Beach, VAN38BUAG Fur Dornier-Flugzeuge BUCKER BU 133C · S/N 38Built 1938 · Virginia Beach, VAN39FFBell P-39F · S/N 15-554Built 1942 · Virginia Beach, VAN4088HArganbright R/Arganbright V SOPWITH 1 1/2 STRTTR · S/N RA003Virginia Beach, VAN413BTConvair BT-13A · S/N 6528Virginia Beach, VAN415MLLavochkin LA-9 · S/N 828Virginia Beach, VAN422RCCochran Craig SPAD 13 BIPLANE · S/N 13Built 2010 · Virginia Beach, VAN4247LFocke Wulf FW 190-A8 · S/N 350177Virginia Beach, VAN42FMMorane-Saulnier MS 500 · S/N 751Built 1949 · Virginia Beach, VAN42YKYakovlev YAK-3M · S/N 0470103Built 1993 · Virginia Beach, VAN44VYCoolbaugh Robert J ELY-CURTISS · S/N 01BCBuilt 2010 · Virginia Beach, VAN46FMFiat FIAT G-46-B · S/N 53091Built 1950 · Virginia Beach, VAN46RLGoodyear FG1D · S/N 92508Built 1945 · Virginia Beach, VAN482UTWilliams Flugzeugbau ALBATROSS DVA · S/N 0034Built 1978 · Virginia Beach, VAN51462Laister-Kauffman LK-10A · S/N 126Built 1943 · Virginia Beach, VA
Back to Tsi Holdco Inc