Skip to content

Terraplex Ag LLC

Registered aircraft · 138

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

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 = 'TERRAPLEX AG LLC' OR list_contains(g.other_registrant_names, 'TERRAPLEX AG LLC') ORDER BY g.n_number

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

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

N149TAGteex Revolution INDEPENDENCE 19 · S/N 212985300C8A6Odebolt, IA N160AGDJI AGRAS T40 · S/N 1581F574B235D00100QUOdebolt, IA N163TAGteex Revolution INDEPENDENCE 19 · S/N 212985300CC7DOdebolt, IA N240AGDJI AGRAS T50 · S/N 1581F6BUB234200104TWOdebolt, IA N270AGXag P100 PRO · S/N 1863FPEG82193290V3G1Odebolt, IA N290AGXag P100 PRO · S/N 1863FPEG82193293L2P4Odebolt, IA N440AGXag P100 PRO · S/N 1863FPEG821934590A4EOdebolt, IA N460AGXag P100 PRO · S/N 1863FPEG8219329SE249Odebolt, IA N470AGDJI AGRAS T20P · S/N 1581F574B23830010014Odebolt, IA N485TTXag P100 PRO · S/N 1863FPEG821934592ET5Odebolt, IA N544GRGteex Revolution INDEPENDENCE 19 · S/N 212985300C680Odebolt, IA N546GRGteex Revolution INDEPENDENCE 19 · S/N 212985300C628Odebolt, IA N547GRGteex Revolution INDEPENDENCE 19 · S/N 212985300C686Odebolt, IA N548DPGteex Revolution INDEPENDENCE 19 · S/N 212985300CC47Odebolt, IA N5490TGteex Revolution INDEPENDENCE 19 · S/N 212985300C6CCOdebolt, IA N549QTGteex Revolution INDEPENDENCE 19 · S/N 212985300C6C8Odebolt, IA N549UTGteex Revolution INDEPENDENCE 19 · S/N 212985300C6BBOdebolt, IA N549XTGteex Revolution INDEPENDENCE 19 · S/N 212985300C6BAOdebolt, IA N549ZTGteex Revolution INDEPENDENCE 19 · S/N 212985300C6C9Odebolt, IA N550ETGteex Revolution INDEPENDENCE 19 · S/N 212985300C6D5Odebolt, IA N550VTGteex Revolution INDEPENDENCE 19 · S/N 212985300C6EBOdebolt, IA N550YXGteex Revolution INDEPENDENCE 19 · S/N 212985300C892Odebolt, IA N5514TGteex Revolution INDEPENDENCE 19 · S/N 212985300C86COdebolt, IA N551ETGteex Revolution INDEPENDENCE 19 · S/N 212985300C89EOdebolt, IA N551HTGteex Revolution INDEPENDENCE 19 · S/N 212985300C613Odebolt, IA N551UTGteex Revolution INDEPENDENCE 19 · S/N 212985300C791Odebolt, IA N551YTGteex Revolution INDEPENDENCE 19 · S/N 212985300C854Odebolt, IA N552BTGteex Revolution INDEPENDENCE 19 · S/N 212985300C889Odebolt, IA N552HDGteex Revolution INDEPENDENCE 19 · S/N 212985300C867Odebolt, IA N552JTGteex Revolution INDEPENDENCE 19 · S/N 212985300C873Odebolt, IA N552MPGteex Revolution INDEPENDENCE 19 · S/N 212985300C63AOdebolt, IA N552QTGteex Revolution INDEPENDENCE 19 · S/N 212985300C66DOdebolt, IA N552RTGteex Revolution INDEPENDENCE 19 · S/N 212985300C871Odebolt, IA N553DHGteex Revolution INDEPENDENCE 19 · S/N 212985300C700Odebolt, IA N553GBGteex Revolution INDEPENDENCE 19 · S/N 212985300C708Odebolt, IA N553JKGteex Revolution INDEPENDENCE 19 · S/N 212985300C711Odebolt, IA N553KBGteex Revolution INDEPENDENCE 19 · S/N 212985300C717Odebolt, IA N554DPGteex Revolution INDEPENDENCE 19 · S/N 212985300CC4BOdebolt, IA N5892GGteex Revolution R-40 · S/N 1596A3039CA0CF7Odebolt, IA N5893GGteex Revolution R-40 · S/N 1596A30472D7054Odebolt, IA N5894GGteex Revolution R-40 · S/N 1596A30837F0F1AOdebolt, IA N589KAGteex Revolution R-40 · S/N 1596A30BCAADCCEOdebolt, IA N589LGGteex Revolution R-40 · S/N 1596A301F44A32EOdebolt, IA N589MAGteex Revolution R-40 · S/N 1596A304A91D20FOdebolt, IA N589QAGteex Revolution R-40 · S/N 1596A304D5B02E3Odebolt, IA N589TGGteex Revolution R-40 · S/N 1596A302A222363Odebolt, IA N589UGGteex Revolution R-40 · S/N 1596A306242452Odebolt, IA N589WGGteex Revolution R-40 · S/N 1596A3007FEA0ABOdebolt, IA N590EGGteex Revolution R-40 · S/N 1596A302168E4D7Odebolt, IA N590FGGteex Revolution R-40 · S/N 1596A308CCE7524Odebolt, IA

Back to Terraplex Ag LLC