Textron Financial Corp
Earlier aircraft under this name · 92
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 FINANCIAL CORP' OR list_contains(d.other_registrant_names, 'TEXTRON FINANCIAL CORP') 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 FINANCIAL CORP' OR list_contains(d.other_registrant_names, 'TEXTRON FINANCIAL CORP') 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.
N408TATextron 408 · S/N 408-0041N60063Textron 208B · S/N 208B5962N933TFTextron 208B · S/N 208B5933N6007DTextron 208B · S/N 208B5964N409TLTextron 408 · S/N 408-0055N2011FTextron 208B · S/N 208B5931N545BTBell Textron Canada 429 · S/N 57545N20088Textron 208B · S/N 208B5919N1705CTextron 680A · S/N 680A0177N2009NTextron 208B · S/N 208B5914N2011HTextron 208B · S/N 208B5913N475PTextron 525C · S/N 525C0465N507EVBell Textron Canada 505 · S/N 65701N9000FTextron 208B · S/N 208B5873N9013STextron 208B · S/N 208B5862N9011BTextron 208B · S/N 208B5847N9011QTextron 208B · S/N 208B5849N90093Textron 208B · S/N 208B5830N90100Textron 208B · S/N 208B5843N9010BTextron 208B · S/N 208B5831N260DWTextron B200GT · S/N BY-461N922PSTextron G58 · S/N TH-2514N716CATextron 208B · S/N 208B5793N9006BTextron 208B · S/N 208B5789N90021Textron 208B · S/N 208B5791N90088Textron 208B · S/N 208B5781N9006RTextron 208B · S/N 208B5779N30025Textron 208B · S/N 208B5678N1292VTextron 208B · S/N 208B5663N880KATextron B300 · S/N FL-1280N772KATextron B300 · S/N FL-1277N905HBBell Textron Canada 429 · S/N 57429N889BTBell Textron Canada 429 · S/N 57385N352TXCessna 680 · S/N 680-0036N283MJTextron 525B · S/N 525B0629N534KBBell Helicopter Textron Canada 412EP · S/N 36690N897DTTextron 208B · S/N 208B5609N335MPTextron 525C · S/N 525C0335N875CTTextron 208B · S/N 208B5540N864HTTextron 208B · S/N 208B5521N861YUTextron 208B · S/N 208B5515N135DJTextron 208B · S/N 208B5507N135DKTextron 680A · S/N 680A0202N864CGBell Helicopter Textron Canada 505 · S/N 65207N864STTextron 525 · S/N 525-1024N863LDTextron 208B · S/N 208B5519N523EXTextron 208B · S/N 208B5523N473YTextron 208B · S/N 208B5473N8496TTextron 208B · S/N 208B5468N8497TTextron 208B · S/N 208B5479
Back to Textron Financial Corp