Beech Aircraft Corporation
Earlier aircraft under this name · 41
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 = 'BEECH AIRCRAFT CORPORATION' OR list_contains(d.other_registrant_names, 'BEECH AIRCRAFT CORPORATION') 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 = 'BEECH AIRCRAFT CORPORATION' OR list_contains(d.other_registrant_names, 'BEECH AIRCRAFT CORPORATION') 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.
N8294ZBeech C90A · S/N LJ1354N82982Beech F33A · S/N CE1760N82979Beech F33A · S/N CE1759N56449Beech 300 · S/N FA224N8061QBeech C90A · S/N LJ1329N83022Beech 1900D · S/N UE58N81148Beech B200 · S/N BB1434N56361Beech Acft B200T · S/N BT34N55684Beech B300C · S/N FM8N8103EBeech C90 · S/N LJ1315N80929Beech F33A · S/N CE1698N81042Beech F33A · S/N CE1702N8076DBeech A36 · S/N E2735N31527Beech 1900C · S/N UC51N31544Beech 1900C · S/N UC52N56485Beech F33A · S/N CE1665N56493Beech F33A · S/N CE1666N56546Beech F33A · S/N CE1667N80513Beech C90A · S/N LJ1303N8036NBeech F33A · S/N CE1656N82671Beech 58 · S/N TH1645N82670Beech 58 · S/N TH1643N1565FBeech B200 · S/N BB1362N5641DBeech 58 · S/N TH1581N3206CBeech 1900C · S/N UC32N1833SBeech F33A · S/N CE-1013N158TCBeech 58TC · S/N TK-1N289BABeech PD-289 · S/N 289-1N4912MBeech 200 · S/N BB-395N860DBeech 60 · S/N P-2N700DBeech 50 · S/N H-2N2321ZBeech 23 · S/N M-9N2392QBeech 23 · S/N M-468N368QBeech 65-80 · S/N LD-88N1463GBeech 95-A55 · S/N TC-251N1411GBeech 65 · S/N LC-135N332BBeech D-50 · S/N DH-130N3741BBeech E18S · S/N BA-68N90557Beech D18C · S/N AA-29N25476Beechcraft M18R · S/N 377N293YBeech F17D · S/N 309
Back to Beech Aircraft Corporation