Cessna Aircraft Co
Earlier aircraft under this name · 6,555
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 AIRCRAFT CO' OR list_contains(d.other_registrant_names, 'CESSNA AIRCRAFT CO') 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 AIRCRAFT CO' OR list_contains(d.other_registrant_names, 'CESSNA AIRCRAFT CO') 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.
N442EWCessna 680 · S/N 6800168N45FJCessna 525 · S/N 525-0003N9911TCessna AD02 · S/N AD02-010001N158CSCessna CSA · S/N CSA-010001N2384TCessna 172R · S/N 17280707N132CTTextron 182T · S/N 18282381N243VPCessna 560 · S/N 560-0243N196JPCessna 560 · S/N 560-0809N170THTextron 172S · S/N 172S11670N438CSTextron 172S · S/N 172S11680N446TACessna 525A · S/N 525A0446N517CSTextron 182T · S/N 18282417N902VPCessna 750 · S/N 750-0002N362TACessna 525B · S/N 525B-0362N574PATextron 208B · S/N 208B5276N573PATextron 208B · S/N 208B5273N386TACessna 510 · S/N 510-0386N208LPCessna 208 · S/N 699N583EXCessna 208B · S/N 208B5183N546PATextron 208B · S/N 208B5246N548PATextron 208B · S/N 208B5248N812HFCessna 525B · S/N 525B-0262N694TXCessna 680 · S/N 680-0094N595EXCessna 208B · S/N 208B5095N712TXCessna 750 · S/N 750-0012N605CSCessna 680 · S/N 680-0001N606CSCessna 680 · S/N 680-0061N814TXCessna 560 · S/N 560-0814N139TTCessna LC41-550FG · S/N 411164N500ASCessna 525B · S/N 525B0164N558CCCessna 208 · S/N 20800558N511VPCessna 525B · S/N 525B-0101N233VPCessna 525C · S/N 525C0003N84EECessna 680 · S/N 680-0262N680VPCessna 680 · S/N 6800012N405CZCessna 525B · S/N 525B0405N506EXCessna 208B · S/N 208B5006N236MGCessna 172S · S/N 172S11235N341GCCessna 208B · S/N 208B2341N485CJCessna 525C · S/N 525C0085N79VPCessna 525B · S/N 525B0079N94870Cessna T206H · S/N T20609085N12566Cessna 552 · S/N 552-0012N152VPCessna 550 · S/N 550-1052N93733Cessna T182T · S/N T18209063N906CSCessna T206H · S/N T20609000N8117JCessna 208B · S/N 208B2366N396DMCessna 510 · S/N 510-0008N347GCCessna 208B · S/N 208B2347N260CCCessna 208B · S/N 208B2260
Back to Cessna Aircraft Co