Textron Financial Corp
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 = 'TEXTRON FINANCIAL CORP' OR list_contains(g.other_registrant_names, 'TEXTRON FINANCIAL CORP') 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 FINANCIAL CORP' OR list_contains(g.other_registrant_names, 'TEXTRON FINANCIAL CORP') 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.
N107AEBell Helicopter Textron Canada 407 · S/N 54752N164AEBell Helicopter Textron Canada 206L-4 · S/N 52494N165AEBell Helicopter Textron Canada 206L-4 · S/N 52495N166AEBell Helicopter Textron Canada 206L-4 · S/N 52496N190AEBell Helicopter Textron Canada 407 · S/N 54511N193AEBell Helicopter Textron Canada 407 · S/N 54847N501MTBell Textron Canada 407 · S/N 54965N541MTBell Helicopter Textron Canada 407 · S/N 54876N557MTBell Textron Canada 407 · S/N 56409N606AHBell Textron Canada 407 · S/N 56329N606MTBell Textron Canada 407 · S/N 56339N637SVCessna 680 · S/N 680-0037N742AEBell Textron Canada 407 · S/N 56350N773AEBell Textron Canada 407 · S/N 56440N82GTCessna 560XL · S/N 560-6068N897MTBell Textron Canada 407 · S/N 56385N977JHTextron 680 · S/N 680-0592
Back to Textron Financial Corp