Cessna Aicraft Co
Earlier aircraft under this name · 67
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 AICRAFT CO' OR list_contains(d.other_registrant_names, 'CESSNA AICRAFT 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 AICRAFT CO' OR list_contains(d.other_registrant_names, 'CESSNA AICRAFT 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.
N2700JCessna A188B · S/N 18803501TN3665JCessna T188C · S/N T18803658TN731EWCessna A188B · S/N 18802849TN732KYCessna T210M · S/N 21061584N7458QCessna U206F · S/N U20602208N6808XCessna 172A · S/N 47708N6267MStinson 108-3 · S/N 1084267N6259FCessna 337A · S/N 337-0259N6267RCessna 150F · S/N 15061567N6265RCessna 150F · S/N 15061565N8000ZCessna U206 · S/N U2060400N4773UCessna 180H · S/N 18051473N4776UCessna 180H · S/N 18051476N4762UCessna 180H · S/N 18051462N4767UCessna 180H · S/N 18051467N4761UCessna 180H · S/N 18051461N4774UCessna 180H · S/N 18051474N3238SCessna 182G · S/N 18255738N1758ZCessna 336 · S/N 336-0058N6991XCessna 172B · S/N 17247891N6814XCessna 172A · S/N 47714N6834XCessna 172A · S/N 47734N6892XCessna 172B · S/N 17247792N6811XCessna 172A · S/N 47711N6819XCessna 172A · S/N 47719N6818XCessna 172A · S/N 47718N6805XCessna 172A · S/N 47705N6820XCessna 172A · S/N 47720N6822XCessna 172A · S/N 47722N6826XCessna 172A · S/N 47726N6802XCessna 172A · S/N 47702N6806XCessna 172A · S/N 47706N6815XCessna 172A · S/N 47715N6816XCessna 172A · S/N 47716N9899TCessna 172A · S/N 47699N6494TCessna 150 · S/N 17894N6461TCessna 150 · S/N 17861N6474TCessna 150 · S/N 17874N6477TCessna 150 · S/N 17877N6433TCessna 150 · S/N 17833N6435TCessna 150 · S/N 17835N6444TCessna 150 · S/N 17844N7554TCessna 172A · S/N 47154N6418TCessna 150 · S/N 17818N6402TCessna 150 · S/N 17802N7192TCessna 172A · S/N 46792N7042TCessna 172 · S/N 46642N7098TCessna 172 · S/N 46698N7128TCessna 172 · S/N 46728N7139TCessna 172 · S/N 46739
Back to Cessna Aicraft Co