Textron Aviation Inc
Earlier aircraft under this name · 397
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 = 'TEXTRON AVIATION INC' OR list_contains(d.other_registrant_names, 'TEXTRON AVIATION INC') 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 = 'TEXTRON AVIATION INC' OR list_contains(d.other_registrant_names, 'TEXTRON AVIATION INC') 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.
N673SMTextron 408 · S/N 408-0073N674SMTextron 408 · S/N 408-0074N6006TTextron T182T · S/N T18209208N134MNTextron B300C · S/N FM-134N875SMTextron 408 · S/N 408-0075N326CRTextron 208B · S/N 208B5971N20087Textron T206H · S/N T20609853N179PBTextron B300C · S/N FM-132N60055Textron T182T · S/N T18209802N367SMTextron B300 · S/N FL-1367N1360DTextron B300 · S/N FL-1360N497MHTextron 172S · S/N 172S13497N498MHTextron 172S · S/N 172S13498N508MHTextron 172S · S/N 172S13500N130HSTextron B300C · S/N FM-130N793CETextron T206H · S/N T20609793N2012BTextron 208B · S/N 208B5928N2012XTextron 208B · S/N 208B5927N131HMTextron B300C · S/N FM-131N20138Textron 208B · S/N 208B5932N129HSTextron B300C · S/N FM-129N813EXTextron 208B · S/N 208B5813N128HSTextron B300C · S/N FM-128N433MHTextron 172S · S/N 172S13423N436MHTextron 172S · S/N 172S13426N439MHTextron 172S · S/N 172S13429N408MXTextron 408 · S/N 408-0053N127HSTextron B300C · S/N FM-127N353SUTextron B300 · S/N FL-1353N125HMTextron B300C · S/N FM-125N124HSTextron B300C · S/N FM-124N123HRTextron B300C · S/N FM-123N126ADTextron B300C · S/N FM-126N314CWTextron ASCEND · S/N 560-6504N121HKTextron B300C · S/N FM-121N122HKTextron B300C · S/N FM-122N846FHTextron 208B · S/N 208B5846N9007LTextron T206H · S/N T20609798N9003UTextron 182T · S/N 18283289N9788NTextron T206H · S/N T20609788N408RATextron 408 · S/N 408-0028N681PBTextron 680A · S/N 680A0412N121MHTextron 172S · S/N 172S13244N122MHTextron 172S · S/N 172S13246N125MHTextron 172S · S/N 172S13247N712SUTextron 208B · S/N 208B5821N713SUTextron 208B · S/N 208B5823N714SUTextron 208B · S/N 208B5825N119YVTextron B300C · S/N FM-119N590SATextron 208B · S/N 208B5832
Back to Textron Aviation Inc