United Airlines Inc
Registered aircraft · 1,225
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 = 'UNITED AIRLINES INC' OR list_contains(g.other_registrant_names, 'UNITED AIRLINES INC') 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 = 'UNITED AIRLINES INC' OR list_contains(g.other_registrant_names, 'UNITED AIRLINES INC') 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.
N10156Embraer EMB-145XR · S/N 145786N11106Embraer EMB-145XR · S/N 145650N11107Embraer EMB-145XR · S/N 145654N11113Embraer EMB-145XR · S/N 145662N11119Embraer EMB-145XR · S/N 145677N11121Embraer EMB-145XR · S/N 145683N11127Embraer EMB-145XR · S/N 145697N11140Embraer EMB-145XR · S/N 145732N11150Embraer EMB-145XR · S/N 145756N11164Embraer EMB-145XR · S/N 14500817N11165Embraer EMB-145XR · S/N 14500819N11176Embraer EMB-145XR · S/N 14500881N11181Embraer EMB-145XR · S/N 14500904N11184Embraer EMB-145XR · S/N 14500917N11187Embraer EMB-145XR · S/N 14500927N11189Embraer EMB-145XR · S/N 14500931N11191Embraer EMB-145XR · S/N 14500935N11192Embraer EMB-145XR · S/N 14500936N11193Embraer EMB-145XR · S/N 14500938N11194Embraer EMB-145XR · S/N 14500940N11199Embraer EMB-145XR · S/N 14500953N11206Boeing 737-824 · S/N 30578N12003Boeing 787-10 · S/N 40935N12004Boeing 787-10 · S/N 60139N12005Boeing 787-10 · S/N 40937N12006Boeing 787-10 · S/N 60140N12010Boeing 787-10 · S/N 40926N12012Boeing 787-10 · S/N 60145N12020Boeing 787-10 · S/N 66989N12021Boeing 787-10 · S/N 66990N120UABoeing 747-422 · S/N 29166N12109Boeing 757-224 · S/N 27299N12114Boeing 757-224 · S/N 27556N12116Boeing 757-224 · S/N 27558N12125Boeing 757-224 · S/N 28967N12135Embraer EMB-145XR · S/N 145718N12136Embraer EMB-145XR · S/N 145719N12142Embraer EMB-145XR · S/N 145735N12145Embraer EMB-145XR · S/N 145745N12157Embraer EMB-145XR · S/N 145787N12160Embraer EMB-145XR · S/N 145799N12163Embraer EMB-145XR · S/N 14500811N12167Embraer EMB-145XR · S/N 14500834N12172Embraer EMB-145XR · S/N 14500864N12175Embraer EMB-145XR · S/N 14500878N12195Embraer EMB-145XR · S/N 14500943N12201Embraer EMB-145XR · S/N 14500959N12216Boeing 737-824 · S/N 28776N12218Boeing 737-824 · S/N 28778N12221Boeing 737-824 · S/N 28930
Back to United Airlines Inc