OpenAirDocs.org
Tre Aviation Corp

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 = 'TRE AVIATION CORP' OR list_contains(g.other_registrant_names, 'TRE AVIATION CORP')
  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.

N109WHAgusta A109A · S/N 7174Built 1997 · Wilmington, DEN11577Cessna 150L · S/N 15075534Built 1973 · Wilmington, DEN120BEEurocopter EC120B · S/N 1137Built 2000 · Wilmington, DEN16947Taylor J-2 · S/N 813Built 1936 · Wilmington, DEN182WXCessna 182P · S/N 18264898Wilmington, DEN1CTCessna T337G · S/N P3370001Built 1972 · Queen Creek, AZN2026NCessna 120 · S/N 12262Built 1947 · Wilmington, DEN22978Piper J3C-65 · S/N 2860Built 1939 · Queen Creek, AZN24WXLearjet 24 · S/N 101Built 1966 · Wilmington, DEN2760KBell 206B · S/N 2733Wilmington, DEN28MLHughes Helicopters HUGHES 369D · S/N 1080362DBuilt 1978 · Wilmington, DEN3079CBeech K35 · S/N D-5759Built 1958 · Wilmington, DEN401AZCessna 401B · S/N 401B-0018Built 1969 · Wilmington, DEN4796UGrumman HU-16 · S/N 137915Wilmington, DEN500WXMcdonnell Douglas Helicopter 369E · S/N 0493EBuilt 1992 · Wilmington, DEN521TCHughes 369HE · S/N 1090201EBuilt 1969 · Wilmington, DEN55069Piper PA-28R-200 · S/N 28R-7335177Built 1973 · Wilmington, DEN6193NGrumman TF-1(C-1A) · S/N 136773Built 1952 · Wilmington, DEN61PHBell 206B · S/N 3282Built 1981 · Wilmington, DEN6635QHughes 500C · S/N 440589SWilmington, DEN6677RCessna T210L · S/N 21059654Wilmington, DEN67JJBell 206B · S/N 4062Wilmington, DEN73AWBell 206-L4 · S/N 52115Wilmington, DEN876RJAgusta A109A II · S/N 7291Wilmington, DEN8924MBeech S35 · S/N D-7337Built 1964 · Wilmington, DEN9994GTompkins John C CHRISTEN EAGLE II · S/N TOMPKINS-0001Wilmington, DE
Back to Tre Aviation Corp