Textron Aviation Inc
Registered aircraft · 341
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 = 'TEXTRON AVIATION INC' OR list_contains(g.other_registrant_names, 'TEXTRON AVIATION INC') 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 = 'TEXTRON AVIATION INC' OR list_contains(g.other_registrant_names, 'TEXTRON AVIATION INC') 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.
N101CSCessna J182T · S/N J182T00001N1027PCessna 680 · S/N 680-0004N103CSCessna J182T · S/N J182T00003N1068YTextron T206H · S/N T20609869N108HPTextron 525 · S/N 525-1422N10DQTextron 525 · S/N 525-1426N110NBTextron B200CGT · S/N BZ-10N111JJTextron 208B · S/N 208B5988N111UNTextron B200CGT · S/N BZ-11N112CMTextron 700 · S/N 700-0180N112MNTextron B200CGT · S/N BZ-12N113KHTextron T206H · S/N T20609859N113MNTextron B200CGT · S/N BZ-13N114NNTextron B200CGT · S/N BZ-14N115BATextron 525C · S/N 525C0506N115NBTextron B200CGT · S/N BZ-15N116WETextron 172S · S/N 172S13611N12185Textron 172S · S/N 172S13632N1229KTextron T206H · S/N T20609871N123PBTextron 172S · S/N 172S13648N1288NCessna LC41-550FG · S/N 411088N1357KTextron B300 · S/N FL-1357N135SSTextron B300C · S/N FM-135N138MMTextron B300C · S/N FM-138N13ECTextron 525B · S/N 525B0919N13TACessna 172P · S/N 17276111N140MNTextron B300C · S/N FM-140N142MNTextron B300C · S/N FM-142N145GPTextron 208 · S/N 20800722N149CATextron 408 · S/N 408-0072N14WLTextron T206H · S/N T20609857N161CBTextron 680A · S/N 680A0491N165DSCessna 560XL · S/N 560-6175N172STTextron 172S · S/N 172S13635N176CCTextron 700 · S/N 700-0176N17BBTextron T206H · S/N T20609861N2000CTextron 172S · S/N 172S13601N2002FTextron 182T · S/N 18283349N206CTextron T206H · S/N T20609864N207SFTextron 172S · S/N 172S13485N2093BCessna 182S · S/N 18280041N21454Cessna 182T · S/N 18281228N2145ZCessna T182T · S/N T18208204N218CSCessna T240 · S/N T24002012N220BTTextron 220 · S/N E220-744001N221NTTextron 220 · S/N 220-0001N2225FCessna 172S · S/N 172S10468N222DCTextron 172S · S/N 18283364N222NTTextron 220 · S/N 220-0002N2244WCessna T182T · S/N T18208714
Back to Textron Aviation Inc