Raytheon Aircraft Company
Earlier aircraft under this name · 137
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 = 'RAYTHEON AIRCRAFT COMPANY' OR list_contains(d.other_registrant_names, 'RAYTHEON AIRCRAFT COMPANY') 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 = 'RAYTHEON AIRCRAFT COMPANY' OR list_contains(d.other_registrant_names, 'RAYTHEON AIRCRAFT COMPANY') 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.
N36566Raytheon B200 · S/N BB-1936N3732YRaytheon 390 · S/N RB-152N37160Raytheon HAWKER 800XP · S/N 258760N61256Raytheon 400A · S/N RK-456N6128YRaytheon 390 · S/N RB-128N6178FRaytheon B200C · S/N BL-151N6178DRaytheon B200C · S/N BL-150N36850Raytheon C90A · S/N LJ-1750N37149Raytheon C90A · S/N LJ-1749N138XPRaytheon HAWKER 800XP · S/N 258738N136XPRaytheon HAWKER 800XP · S/N 258736N30246Raytheon C90A · S/N LJ-1746N60724Raytheon C90A · S/N LJ-1744N36667Raytheon C90A · S/N LJ-1747N36745Raytheon C90A · S/N LJ-1745N4277EBeech B200 · S/N BB-1314N36823Raytheon G36 · S/N E-3653N36640Raytheon C90A · S/N LJ-1740N37322Raytheon HAWKER 800XP · S/N 258722N10857British Aerospace BAE 125 SERIES 800A · S/N 258213N19XPRaytheon HAWKER 800XP · S/N 258719N36972Raytheon B200 · S/N BB-1902N3726GRaytheon 390 · S/N RB-126N37010Raytheon HAWKER 800XP · S/N 258710N36635Raytheon B300 · S/N FL-435N707XPRaytheon HAWKER 800XP · S/N 258707N36792Raytheon 400A · S/N RK-392N36620Raytheon B300 · S/N FL-420N36689Raytheon HAWKER 800XP · S/N 258689N36690Raytheon HAWKER 800XP · S/N 258690N37082Raytheon B200 · S/N BB-1882N36801Raytheon B200 · S/N BB-1881N6180QRaytheon B200 · S/N BB-1880N61767Raytheon B200 · S/N BB-1877N6173XRaytheon 58 · S/N TH-2093N4488FRaytheon 390 · S/N RB88N5085TRaytheon B300 · S/N FL-385N10855British Aerospace BAE 125-1000 · S/N 258159N61346Raytheon B200T · S/N BT-46N50969Raytheon B200CT · S/N BN-9N5117MRaytheon B200 · S/N BB-1817N6196XRaytheon B36TC · S/N EA-696N51161Raytheon B200 · S/N BB-1811N2021YBeech 58TC · S/N TK-81N3251MRaytheon HAWKER 800 · S/N 258341N3261YRaytheon HAWKER 800 · S/N 258333N4470TRaytheon B200 · S/N BB-1790N471BBRaytheon B36TC · S/N EA-697N3218ZRaytheon B300 · S/N FL-318N3185KRaytheon 400A · S/N RK-318
Back to Raytheon Aircraft Company