Boeing Co
Registered aircraft · 190
Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.
Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'BOEING CO' OR list_contains(g.other_registrant_names, 'BOEING CO') ORDER BY g.n_number"
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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'BOEING CO' OR list_contains(g.other_registrant_names, 'BOEING CO') ORDER BY g.n_number
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.
N125DSBoeing 737-800A · S/N 70604N152DSBoeing 737-800A · S/N 70605N17485Boeing 737-9 · S/N 67680N17488Boeing 737-9 · S/N 67678N17491Boeing 737-9 · S/N 43498N17493Boeing 737-9 · S/N 43497N17495Boeing 737-9 · S/N 67683N17496Boeing 737-9 · S/N 67684N17497Boeing 737-9 · S/N 68762N17499Boeing 737-9 · S/N 67685N1902DRaytheon 1900D · S/N UE327N1916LBoeing 1A · S/N 1AN206HXMcdonnell Douglas Helicopter H-6 · S/N 06-X002N208BACessna 208B · S/N 208B2027N208BXCessna 208B · S/N 208B2292N213XTBoeing BOEING CV2 · S/N 001N21AUPilatus PC-12/45 · S/N 606N223XTBoeing BOEING CV2 · S/N 002N233XTBoeing BOEING CV2 · S/N 003N234MQBoeing Q25 · S/N 00001N243XTBoeing BOEING CV2 · S/N 004N27602Boeing 737-10 · S/N 43510N27635Boeing 737-9 · S/N 67728N27636Boeing 737-9 · S/N 43501N27751Boeing 737-10 · S/N 66122N27752Boeing 737-10 · S/N 66123N27753Boeing 737-10 · S/N 66118N279DSBoeing 737-800A · S/N 67831N280TAMcdonnell Douglas/Daniels M TA-4J · S/N 156925MDN292RNBoeing CH-47F · S/N M2414N313XTBoeing BOEING CV2 · S/N 005N323XTBoeing BOEING CV2 · S/N 006N333HXBoeing BOEING CV2 · S/N 007N343XTBoeing BOEING CV2 · S/N 008N3700MBeech E-90 · S/N LW-340N37035Boeing-Vertol CH-47(352) · S/N MA017N37489Boeing 737-9 · S/N 67681N37490Boeing 737-9 · S/N 43496N37492Boeing 737-9 · S/N 43499N37494Boeing 737-9 · S/N 67682N37498Boeing 737-9 · S/N 67726N37601Boeing 737-10 · S/N 43508N37605Boeing 737-9 · S/N 67688N37715Boeing 737-10 · S/N 43517N381TXBoeing Co The BTX-1 · S/N 00001N382DSBoeing 737-800A · S/N 67832N382TXBoeing Co The BTX-1 · S/N 00002N38FTNorthrop/Thornton T-38A · S/N 5228N38TZNorthrop T-38A · S/N 5881N4143XAero Commander 100 · S/N 243
Back to Boeing Co