OpenAirDocs.org
Spitfire Ventures LLC

Registered aircraft · 26

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 = 'SPITFIRE VENTURES LLC' OR list_contains(g.other_registrant_names, 'SPITFIRE VENTURES LLC')
  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.

N134EMCanadair CT-33 · S/N 133564Built 1959 · San Antonio, TXN139MDAero Vodochody L39CT · S/N 135232Built 1996 · San Antonio, TXN14WBGrumman F8F-2 · S/N 122619Built 1949 · San Antonio, TXN1616Ryan Aeronautical ST3KR · S/N 1062San Antonio, TXN186PJCanadair F-86E MK.6 · S/N 1710Built 1958 · San Antonio, TXN2308ZDehavilland DH98 MOSQUITO T43 · S/N A52-1054Built 1945 · San Antonio, TXN233MBHawker Acft/Sanders T MK 20 · S/N H620508Built 1957 · San Antonio, TXN247MVSpitfire Ventures AIRCAM · S/N AC188Built 2017 · San Antonio, TXN250NANorth American NA-50 · S/N 050Built 1996 · San Antonio, TXN312JVEmbraer EMB 312F · S/N 480Built 1995 · San Antonio, TXN400FSNorth American FJ-4B · S/N 143575San Antonio, TXN47MVCubcrafters CC11-160 · S/N CC11-00258Built 2013 · San Antonio, TXN492MTEmbraer EMB 312F · S/N 492Built 1995 · San Antonio, TXN50FSNorth American F-51D · S/N 44-74839-59Built 1966 · San Antonio, TXN58204Grumman F8F-1 · S/N 95255Built 1946 · San Antonio, TXN628BLVickers/Supermarine SPITFIRE VB · S/N CBAF1660Built 1942 · San Antonio, TXN700FGrumman F7F-3 · S/N 80390Built 1945 · San Antonio, TXN737HFGarlick Helicopters 209/AH1G · S/N 67-15737Built 1967 · San Antonio, TXN747AFNorth American B-25J · S/N 44-30456Built 1944 · San Antonio, TXN747MXGrumman/Skurich TIGERCAT F7F-3 · S/N 80503Built 1945 · San Antonio, TXN747NFGrumman F8F-2 · S/N 988Built 1945 · San Antonio, TXN748BAAero Vodochody L39C · S/N 831102Built 1978 · San Antonio, TXN76CJRadial Aircraft Partners RER-1 · S/N 001San Antonio, TXN805FFCanadair CF-5D · S/N 116805Built 1969 · San Antonio, TXN884TANorth American AT-6G · S/N 49-3190Built 1959 · San Antonio, TXN909TCGrumman F7F-3 · S/N 80425Built 1945 · San Antonio, TX
Back to Spitfire Ventures LLC