Hawker Beechcraft Corp
Earlier aircraft under this name · 201
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 = 'HAWKER BEECHCRAFT CORP' OR list_contains(d.other_registrant_names, 'HAWKER BEECHCRAFT 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 = 'HAWKER BEECHCRAFT CORP' OR list_contains(d.other_registrant_names, 'HAWKER BEECHCRAFT 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.
N122XPHawker Beechcraft HAWKER 900XP · S/N HA-0122N132XPHawker Beechcraft HAWKER 900XP · S/N HA-0132N605XPHawker Beechcraft 400A · S/N RK-605N8113ZHawker Beechcraft B300 · S/N FL-795N5019THawker Beechcraft G58 · S/N TH-2358N51041Hawker Beechcraft G58 · S/N TH-2341N805HHHawker Beechcraft 4000 · S/N RC-5N8042RHawker Beechcraft B300 · S/N FL-792N8094LHawker Beechcraft B300 · S/N FL-784N8105XHawker Beechcraft B200GT · S/N BY-135N8132JHawker Beechcraft G58 · S/N TH-2332N209BABeech PD 373 · S/N PT-3N81017Hawker Beechcraft B300 · S/N FL-767N198XPHawker Beechcraft HAWKER 900XP · S/N HA-0198N8043DHawker Beechcraft B300 · S/N FL-783N81474Hawker Beechcraft B300 · S/N FL-774N457HBHawker Beechcraft 4000 · S/N RC-57N8126VHawker Beechcraft B200GT · S/N BY-126N3189HHawker Beechcraft HAWKER 800 U125A · S/N 258360N748KAHawker Beechcraft B300 · S/N FL-748N8125HHawker Beechcraft B200GT · S/N BY-125N8082JHawker Beechcraft G36 · S/N E-3962N8042PHawker Beechcraft B300 · S/N FL-742N63600Hawker Beechcraft HAWKER 800 U125A · S/N 258843N8018KHawker Beechcraft C90GTI · S/N LJ-2018N82XPHawker Beechcraft HAWKER 900XP · S/N HA-0182N8018JHawker Beechcraft B200 · S/N BB-2018N741JSRaytheon B200 · S/N BB-1901N80245Hawker Beechcraft B300 · S/N FL-745N80948Hawker Beechcraft B300C · S/N FM-48N6434HHawker Beechcraft B300C · S/N FM-34N434HBHawker Beechcraft HAWKER 750 · S/N HB-34N6032ZHawker Beechcraft B300C · S/N FM-32N767HBHawker Beechcraft HAWKER 750 · S/N HB-67N173XPHawker Beechcraft HAWKER 900XP · S/N HA-0173N6211ZHawker Beechcraft B300C · S/N FM-31N6242QHawker Beechcraft B300C · S/N FM-42N63795Hawker Beechcraft B200GT · S/N BY95N80562Hawker Beechcraft B200C · S/N BL-162N8093JHawker Beechcraft G58 · S/N TH-2293N6430BHawker Beechcraft B300C · S/N FM-30N80761Hawker Beechcraft B200C · S/N BL-161N6021CHawker Beechcraft B300 · S/N FL-721N81480Hawker Beechcraft G58 · S/N TH-2290N111LQHawker Beechcraft 390 · S/N RB-243N438HBHawker Beechcraft HAWKER 4000 · S/N RC-38N927KAHawker Beechcraft B300C · S/N FM-27N928KAHawker Beechcraft B300C · S/N FM-28N6469DHawker Beechcraft B300 · S/N FL-713N153XPHawker Beechcraft HAWKER 900XP · S/N HA-0153
Back to Hawker Beechcraft Corp