OpenAirDocs.org
Jetran LLC

Registered aircraft · 64

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

N116JKEngineering & Research ERCOUPE 415-C · S/N 4276Built 1946 · Horseshoe Bay, TXN13QCBoeing 777-237LR · S/N 36306Horseshoe Bay, TXN14QCBoeing 777-237LR · S/N 36305Horseshoe Bay, TXN15QCBoeing 777-237LR · S/N 36307Horseshoe Bay, TXN185VVCessna A185F · S/N 18504435Built 1985 · Horseshoe Bay, TXN2051DNorth American/Aero Classics P-51D · S/N 44-73454Horseshoe Bay, TXN2287YPiper PA-18 105 · S/N 18-2434Horseshoe Bay, TXN281AYAirbus A330-243 · S/N 1041Built 2009 · Horseshoe Bay, TXN288AYAirbus A330-243 · S/N 1441Built 2013 · Horseshoe Bay, TXN3518JBoeing 737-800 · S/N 35108Horseshoe Bay, TXN36PHBoeing B75N1 · S/N 75-7030Built 1943 · Horseshoe Bay, TXN4583SCessna L-19E · S/N 24707Horseshoe Bay, TXN55268Boeing A75N1(PT17) · S/N 75-1917Horseshoe Bay, TXN5540NBoeing E75N1 · S/N 75-8391Built 1943 · Horseshoe Bay, TXN5ZSNorth American T-6G · S/N 49-3160Built 1951 · Horseshoe Bay, TXN618WFBombardier BD-700-1A10 · S/N 9005Built 1999 · Horseshoe Bay, TXN6397TCessna TR182 · S/N 18202010Horseshoe Bay, TXN6420TCessna R182 · S/N R18202017Horseshoe Bay, TXN656GTBoeing 767-281 · S/N 23017Built 1984 · Horseshoe Bay, TXN657GTBoeing 767-281 · S/N 23018Built 1984 · Horseshoe Bay, TXN659GTBoeing 767-281 · S/N 23140Built 1984 · Horseshoe Bay, TXN666TXBeech D17S · S/N 6897Built 1947 · Horseshoe Bay, TXN695MKNorth American T-6G · S/N 168472Built 1949 · Horseshoe Bay, TXN6YAerokit SA32-T · S/N 001Built 1989 · Horseshoe Bay, TXN705DNBoeing 777-232LR · S/N 29742Built 2009 · Horseshoe Bay, TXN710DNBoeing 777-232LR · S/N 40560Built 2010 · Horseshoe Bay, TXN7482Grumman Acft ENG Cor-Schweizer G-164A · S/N 957Built 1972 · Horseshoe Bay, TXN790MFBoeing 777-2DZLR · S/N 36018Horseshoe Bay, TXN791MFBoeing 777-2DZLR · S/N 36016Built 2009 · Horseshoe Bay, TXN792MFBoeing 777-2DZLR · S/N 36017Built 2009 · Horseshoe Bay, TXN829CPiper PA32-301XTC · S/N 3255039Built 2005 · Horseshoe Bay, TXN900JGulfstream Aerospace GV-SP (G550) · S/N 5200Horseshoe Bay, TXN902JDassault FALCON 2000 · S/N 214Built 2004 · Horseshoe Bay, TXN904JCessna 560 · S/N 560-0144Built 1991 · Horseshoe Bay, TXN906JTextron 182T · S/N 18283160Built 2021 · Horseshoe Bay, TXN9560PPiper PA-25-235 · S/N 25-7405674Built 1974 · Horseshoe Bay, TXN9615WMcdonnell Douglas DC-9-83(MD-83) · S/N 53562Built 1997 · Horseshoe Bay, TXN9616GMcdonnell Douglas DC-9-83(MD-83) · S/N 53563Built 1997 · Horseshoe Bay, TXN9617RMcdonnell Douglas DC-9-83(MD-83) · S/N 53564Built 1997 · Horseshoe Bay, TXN9618AMcdonnell Douglas DC-9-83(MD-83) · S/N 53565Built 1997 · Horseshoe Bay, TXN9619VMcdonnell Douglas DC-9-83(MD-83) · S/N 53566Built 1997 · Horseshoe Bay, TXN961TWMcdonnell Douglas DC-9-83(MD-83) · S/N 53611Built 1999 · Horseshoe Bay, TXN9620DMcdonnell Douglas DC-9-83(MD-83) · S/N 53591Built 1997 · Horseshoe Bay, TXN9622AMcdonnell Douglas DC-9-83(MD-83) · S/N 53593Built 1998 · Horseshoe Bay, TXN9624TMcdonnell Douglas DC-9-83(MD-83) · S/N 53594Built 1998 · Horseshoe Bay, TXN9625WMcdonnell Douglas DC-9-83(MD-83) · S/N 53595Built 1998 · Horseshoe Bay, TXN9626FMcdonnell Douglas DC-9-83(MD-83) · S/N 53596Built 1998 · Horseshoe Bay, TXN9628WMcdonnell Douglas DC-9-83(MD-83) · S/N 53598Built 1998 · Horseshoe Bay, TXN9629HMcdonnell Douglas DC-9-83(MD-83) · S/N 53599Built 1998 · Horseshoe Bay, TXN962TWMcdonnell Douglas DC-9-83(MD-83) · S/N 53612Built 1999 · Horseshoe Bay, TX
Back to Jetran LLC