Skip to content

Cessna Aircraft Corp

Earlier aircraft under this name · 215

Cancelled registrations that named this owner when they ended, newest first.

Query with SQL

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 CORP' OR list_contains(d.other_registrant_names, 'CESSNA AIRCRAFT CORP') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 CORP' OR list_contains(d.other_registrant_names, 'CESSNA AIRCRAFT 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 AIRCRAFT CORP' OR list_contains(d.other_registrant_names, 'CESSNA AIRCRAFT 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.

N9527ACessna T206H · S/N T20609099Cancelled Apr 17, 2014 · Exported to Brazil · Built 2013 · Independence, KS N5268PCessna T182T · S/N T18208978Cancelled Mar 11, 2010 · Exported to Turkey · Built 2009 · Independence, KS N8958GCessna 188B · S/N 18801329Cancelled Aug 15, 2005 · Built 1973 · Wichita, KS N72177Cessna 337G · S/N 33701534Cancelled Aug 12, 2005 · Built 1973 · Wichita, KS N59006Cessna 210L · S/N 21060013Cancelled Apr 19, 2005 · Exported to Brazil · Built 1973 · Wichita, KS N6874DCessna 425 · S/N 4250183Cancelled May 17, 1985 · Exported to Australia · Built 1983 · Wichita, KS N4804VCessna T303 · S/N T30300279Cancelled Aug 10, 1984 · Exported to Japan · Zaventem N6799CCessna 551 · S/N 5510361Cancelled Mar 2, 1982 · Exported to Argentina · Wichita, KS N54483Cessna 172P · S/N 17274984Cancelled Sep 10, 1981 · Exported to Canada · Zaventem N54261Cessna 172P · S/N 17274934Cancelled Aug 21, 1981 · Exported to Canada · Wichita, KS N4654JCessna A188B · S/N 18803758TCancelled Jul 7, 1981 · Exported to Nicaragua · Wichita, KS N4658ZCessna U206 · S/N U20605996Cancelled Jun 5, 1981 · Exported to Bolivia · Wichita, KS N5524VCessna 172RG · S/N 172RG0552Cancelled Jul 2, 1980 · Exported to Germany N739PYCessna 172N · S/N 17270708Cancelled Oct 5, 1978 · Exported to Libya · Zaventem N1723RCessna A185F · S/N 18502444Cancelled Jul 10, 1974 · Exported to Norway · Wichita, KS N19503Cessna 150L · S/N 15074454Cancelled Mar 20, 1974 · Exported to Canada · Built 1973 · Wichita, KS N92007Cessna 172M · S/N 17261536Cancelled Nov 20, 1973 · Exported to Denmark · Built 1973 · Wichita, KS N58796Cessna 182P · S/N 18262301Cancelled Oct 24, 1973 · Exported to Brazil N9702LBeech C23 · S/N M-1322Cancelled Nov 3, 1971 · Exported to Canada N84559Cessna 172K · S/N 17258520Cancelled Dec 19, 1969 · Exported to Ecuador · Built 1969 · Wichita, KS N5703JCessna P206D · S/N P206-0603Cancelled Dec 4, 1969 · Exported to Germany · Wichita, KS N70864Cessna 182M · S/N 18259398Cancelled Apr 22, 1969 · Exported to Italy N20432Cessna 172F · S/N F172-0432Cancelled Nov 1, 1968 · Exported to Netherlands · Zaventem N8876GCessna 182L · S/N 18258636Cancelled Jun 12, 1968 · Exported to Germany · Wichita, KS N2386CCessna 180 · S/N 30686Cancelled Nov 14, 1967 · Wichita, KS N3179SCessna 150E · S/N 18255679Cancelled Mar 17, 1965 · Exported to Argentina · Built 1964 · Wichita, KS N3351UCessna 182F · S/N 18254751Cancelled May 31, 1963 · Exported to Canada · Wichita, KS N5790XCessna 320 · S/N 320-0090Cancelled Feb 26, 1962 · Wichita, KS N5789XCessna 320 · S/N 320-0089Cancelled Feb 20, 1962 · Wichita, KS N5787XCessna 320 · S/N 320-0087Cancelled Feb 9, 1962 · Wichita, KS N5791XCessna 320 · S/N 320-0091Cancelled Feb 6, 1962 · Wichita, KS N5785XCessna 320 · S/N 320-0085Cancelled Feb 1, 1962 · Wichita, KS N5774XCessna 320 · S/N 320-0074Cancelled Jan 13, 1962 · Exported to Germany · Wichita, KS N6482XCessna 180D · S/N 18050982Cancelled Jan 10, 1962 · Exported to Mexico · Wichita, KS N5766XCessna 320 · S/N 320-0066Cancelled Dec 7, 1961 · Exported to Mozambique · Wichita, KS N5427ECessna T-37B · S/N 40586Cancelled Sep 19, 1961 · Exported to Peru · Wichita, KS N5428ECessna T-37B · S/N 40610Cancelled Sep 19, 1961 · Exported to Peru · Wichita, KS N5429ECessna T-37B · S/N 40612Cancelled Sep 19, 1961 · Exported to Peru · Wichita, KS N5430ECessna T-37B · S/N 40614Cancelled Aug 9, 1961 · Exported to Peru · Wichita, KS N6412XCessna 180D · S/N 18050912Cancelled Aug 9, 1961 · Exported to Portugal · Wichita, KS N7858XCessna 172B · S/N 17248358Cancelled Apr 18, 1961 · Exported to Chile N6488XCessna 180D · S/N 18050988Cancelled Apr 4, 1961 · Exported to Brazil · Wichita, KS N6493XCessna 180D · S/N 18050993Cancelled Apr 4, 1961 · Exported to Brazil · Wichita, KS N6463XCessna 180D · S/N 18050963Cancelled Mar 1, 1961 · Exported to Australia · Wichita, KS N6485XCessna 180D · S/N 18050985Cancelled Mar 1, 1961 · Exported to Canada · Wichita, KS N6486XCessna 180D · S/N 18050986Cancelled Mar 1, 1961 · Exported to Norway · Wichita, KS N6487XCessna 180D · S/N 18050987Cancelled Mar 1, 1961 · Exported to Canada · Wichita, KS N6432XCessna 180D · S/N 18050932Cancelled Jan 30, 1961 · Exported to Brazil · Wichita, KS N6433XCessna 180D · S/N 18050933Cancelled Jan 30, 1961 · Exported to Brazil · Wichita, KS N6470XCessna 180D · S/N 18050970Cancelled Jan 30, 1961 · Exported to Australia · Wichita, KS

Back to Cessna Aircraft Corp