Thrush Aircraft LLC
Earlier aircraft under this name · 91
Cancelled registrations that named this owner when they ended, newest first.
Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'THRUSH AIRCRAFT LLC' OR list_contains(d.other_registrant_names, 'THRUSH AIRCRAFT LLC') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"
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 d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'THRUSH AIRCRAFT LLC' OR list_contains(d.other_registrant_names, 'THRUSH AIRCRAFT LLC') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
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.
N7001VThrush S2R-T660 · S/N T660-193DCN7003CThrush S2R-T660 · S/N T660-197DCN70056Thrush S2R-T660 · S/N T660-196DCN70021Thrush S2R-510 · S/N 510-157N7002CThrush S2R-510 · S/N 510-155N70053Thrush S2R-510 · S/N 510-159DCN7001QThrush S2R-510 · S/N 510-154N7001FThrush S2R-T660 · S/N T660-192DCN7001LThrush S2R-510 · S/N 510-149N7001BThrush S2R-T660 · S/N T660-191DCN7001JThrush S2R-510 · S/N 510-153N8017JThrush S2R-510 · S/N 510-151N8015XThrush S2R-510 · S/N 510-145N8015YThrush S2R-510 · S/N 510-147N8017FThrush S2R-510 · S/N 510-532DCN8016ZThrush S2R-T660 · S/N T660-187DCN8016YThrush S2R-T660 · S/N T660-178DCN80107Thrush S2R-T660 · S/N T660-188N8015DThrush S2R-510 · S/N 510-144N80151Thrush S2R-T660 · S/N T660-189DCN80162Thrush S2R-T660 · S/N T660-179DCN80147Thrush S2R-510 · S/N 510-528N80133Thrush S2R-510 · S/N 510-141N80153Thrush S2R-510 · S/N 510-143N8012GThrush S2R-510 · S/N 510-520DCN8014LThrush S2R-T660 · S/N T660-186DCN80136Thrush S2R-510 · S/N 510-527N8004UThrush S2R-510 · S/N 510-503N80132Thrush S2R-510 · S/N 510-140N8011BThrush S2R-510 · S/N 510-123N8010TThrush S2R-510 · S/N 510-524N8009VThrush S2R-510 · S/N 510-133N8009SThrush S2R-510 · S/N 510-137N8010QThrush S2R-510 · S/N 510-117DCN8009EThrush S2R-510 · S/N 510-516N510FKThrush S2R-510 · S/N 510-104DCN8009QThrush S2R-510 · S/N 510-136N8008HThrush S2R-510 · S/N 510-127N8007LThrush S2R-T660 · S/N T660-183DCN8007NThrush S2R-510 · S/N 510-129N8008CThrush S2R-510 · S/N 510-513N8007KThrush S2R-510 · S/N 510-131N80073Thrush S2R-510 · S/N 510-119N5127MThrush S2R-T660 · S/N T660-155N8004EThrush S2R-510 · S/N 510-502N80061Thrush S2R-T660 · S/N T660-172DCN8006RThrush S2R-510 · S/N 510-120N80065Thrush S2R-510 · S/N 510-506N8006CThrush S2R-510 · S/N 510-118N80063Thrush S2R-510 · S/N 510-501
Back to Thrush Aircraft LLC