OpenAirDocs.org
Thrush Aircraft LLC

Registered aircraft · 17

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

N5101CThrush S2R-T34 · S/N T34-502Built 2020 · Albany, GAN5102AThrush S2R-T34 · S/N T34-503Built 2020 · Albany, GAN510XCThrush S2R-510 · S/N 510-152DCAlbany, GAN5128TThrush S2R-T660 · S/N T660-156Albany, GAN5129LThrush S2R-T660 · S/N T660-157Albany, GAN51686Thrush S2R-T660 · S/N T660-170DCBuilt 2022 · Albany, GAN5170FThrush S2R-T660 · S/N T660-171DCBuilt 2022 · Albany, GAN6216UThrush S2R-H80 · S/N H80-192Built 2017 · Albany, GAN7001CThrush S2R-T660 · S/N T660-190Built 2025 · Albany, GAN70035Thrush S2R-510 · S/N 510-156Albany, GAN70058Thrush S2R-T660 · S/N T660-198DCBuilt 2026 · Albany, GAN70059Thrush S2R-510 · S/N 510-539Built 2026 · Albany, GAN7005DThrush S2R-510 · S/N 510-161Built 2026 · Albany, GAN7005RThrush S2R-510 · S/N 510-163DCAlbany, GAN7005YThrush S2R-510 · S/N 510-158Albany, GAN780MCThrush S2R-510 · S/N 510-536DCAlbany, GAN793MCThrush S2R-510 · S/N 510-162DCBuilt 2026 · Albany, GA
Back to Thrush Aircraft LLC