Cessna Finance Corp
Earlier aircraft under this name · 128
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 = 'CESSNA FINANCE CORP' OR list_contains(d.other_registrant_names, 'CESSNA FINANCE 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 = 'CESSNA FINANCE CORP' OR list_contains(d.other_registrant_names, 'CESSNA FINANCE 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.
N127TDCessna 510 · S/N 510-0127N510BPCessna 510 · S/N 510-0027N510LKCessna 510 · S/N 510-0068N5072TCessna 206H · S/N 20608169N288CXCessna 750 · S/N 750-0219N228CFCessna 750 · S/N 750-0028N541CSCessna 560XL · S/N 560-5521N2019JCessna 208B · S/N 208B2376N146EPCessna 510 · S/N 510-0306N822DSCessna 680 · S/N 680-0121N8JQCessna 750 · S/N 750-0020N930NVBell Helicopter Textron Canada 206B · S/N 4672N2UJCessna 680 · S/N 680-0179N225GGCessna 525A · S/N 525A0047N570CFCessna 560XL · S/N 560-5701N83GGCessna 560XL · S/N 560-5046N702AMCessna 560 · S/N 560-0702N365MBBell Helicopter Textron Canada 407 · S/N 53932N871SAEurocopter EC120B · S/N 1548N976TACessna 172S · S/N 172S9076N430APBell 430 · S/N 49003N9278VBell 206B · S/N 4656N6130KCessna 208B · S/N 208B2108N5YDCessna 525A · S/N 525A0121N235SSCessna 510 · S/N 510-0070N2460GCessna 208B · S/N 208B2127N1468BBell Helicopter Textron Canada 407 · S/N 53821N2234JCessna 208B · S/N 208B2091N20768Cessna 750 · S/N 750-0298N325PBBell Helicopter Textron Canada 206L-4 · S/N 52386N325TBBell Helicopter Textron Canada 206L-4 · S/N 52382N3474PHawker Beechcraft B300 · S/N FL-574N5219GCessna 172S · S/N 172S10841N2327XCessna 208B · S/N 208B2035N2015PCessna 182T · S/N 18281773N2293YCessna 208B · S/N 208B2017N2326SCessna 208B · S/N 208B2031N410BHBell Helicopter Textron Canada 206B · S/N 4645N21738Cessna 208B · S/N 208B1317N1445BBell Helicopter Textron Canada 412EP · S/N 36471N7532QBell 412EP · S/N 36458N41179Cessna 208B · S/N 208B1291N75319Bell 412EP · S/N 36456N97XRLearjet 45 · S/N 256N4115RCessna 208B · S/N 208B1293N4117DCessna 208B · S/N 208B1292N41168Cessna 208B · S/N 208B1265N8515XBell 412EP · S/N 36437N818CFCessna 182T · S/N 18281084N8019TBell 412EP · S/N 36422
Back to Cessna Finance Corp