Raytheon Aircraft Co
Earlier aircraft under this name · 65
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 CO' OR list_contains(d.other_registrant_names, 'RAYTHEON AIRCRAFT 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 = 'RAYTHEON AIRCRAFT CO' OR list_contains(d.other_registrant_names, 'RAYTHEON AIRCRAFT 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.
N7128TRaytheon HAWKER 850XP · S/N 258828N7022FRaytheon B200 · S/N BB-1972N7074NRaytheon B200 · S/N BB-1974N7077SRaytheon HAWKER 850XP · S/N 258827N74142Raytheon HAWKER 850XP · S/N 258832N73220Raytheon C90GT · S/N LJ-1822N70689Raytheon C90GT · S/N LJ-1819N7081VRaytheon 390 · S/N RB-181N417SBRaytheon A36 · S/N E-3479N493XPRaytheon 400A · S/N RK-493N74155Raytheon HAWKER 850XP · S/N 258815N70409Raytheon HAWKER 850XP · S/N 258809N71010Raytheon HAWKER 850XP · S/N 258810N71881Raytheon HAWKER 850XP · S/N 258811N74061Raytheon B200 · S/N BB-1961N36878Raytheon HAWKER 850XP · S/N 258807N71904Raytheon HAWKER 850XP · S/N 258804N793XPRaytheon HAWKER 850XP · S/N 258793N6178NRaytheon B300 · S/N FL-478N240AJRaytheon B200 · S/N BB-1619N36846Raytheon 400A · S/N RK-476N638LDBeech 2000 · S/N NC-18N36744Raytheon B300 · S/N FL-444N61729Raytheon HAWKER 800 · S/N 258629N777MQRaytheon 390 · S/N RB-20N512LRBritish Aerospace BAE 125 SERIES 1000A · S/N 259012N68HDRaytheon HAWKER 800XP · S/N 258429N163BJRaytheon 400A · S/N RK-163N5019HRaytheon B200 · S/N BB-1819N5104BRaytheon B200 · S/N BB-1804N124BGRaytheon 400A · S/N RK124N61320Raytheon HAWKER 800 · S/N 258610N728AMRaytheon B200 · S/N BB-1729N50733Raytheon HAWKER 800 · S/N 258533N50513Raytheon HAWKER 800 · S/N 258513N1112NRaytheon HAWKER 800 · S/N 258325N2175WRaytheon HAWKER 800 · S/N 258348N23556Raytheon HAWKER 800 · S/N 258370N23566Raytheon HAWKER 800 · S/N 258381N30562Raytheon HAWKER 800 · S/N 258407N31833Raytheon HAWKER 800 · S/N 258427N40708Raytheon HAWKER 800 · S/N 258445N40933Raytheon HAWKER 800 · S/N 258493N43079Raytheon HAWKER 800 · S/N 258469N4471NRaytheon HAWKER 800XP · S/N 258571N133BPRaytheon 400A · S/N RK133N3171HRaytheon B200 · S/N BB-1671N400HDRaytheon 400A · S/N RK-303N84802Beech 1900D · S/N UE-53N80VSRaytheon 58 · S/N TH-1948
Back to Raytheon Aircraft Co