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.

N10156Embraer EMB-145XR · S/N 145786Built 2004 · Chicago, ILN11106Embraer EMB-145XR · S/N 145650Built 2002 · Chicago, ILN11107Embraer EMB-145XR · S/N 145654Built 2002 · Chicago, ILN11113Embraer EMB-145XR · S/N 145662Built 2002 · Chicago, ILN11119Embraer EMB-145XR · S/N 145677Built 2002 · Chicago, ILN11121Embraer EMB-145XR · S/N 145683Built 2003 · Chicago, ILN11127Embraer EMB-145XR · S/N 145697Built 2003 · Chicago, ILN11140Embraer EMB-145XR · S/N 145732Built 2003 · Chicago, ILN11150Embraer EMB-145XR · S/N 145756Built 2003 · Chicago, ILN11164Embraer EMB-145XR · S/N 14500817Built 2004 · Chicago, ILN11165Embraer EMB-145XR · S/N 14500819Built 2004 · Chicago, ILN11176Embraer EMB-145XR · S/N 14500881Built 2004 · Chicago, ILN11181Embraer EMB-145XR · S/N 14500904Built 2005 · Chicago, ILN11184Embraer EMB-145XR · S/N 14500917Built 2005 · Chicago, ILN11187Embraer EMB-145XR · S/N 14500927Built 2005 · Chicago, ILN11189Embraer EMB-145XR · S/N 14500931Built 2005 · Chicago, ILN11191Embraer EMB-145XR · S/N 14500935Built 2005 · Chicago, ILN11192Embraer EMB-145XR · S/N 14500936Built 2005 · Chicago, ILN11193Embraer EMB-145XR · S/N 14500938Built 2005 · Chicago, ILN11194Embraer EMB-145XR · S/N 14500940Built 2005 · Chicago, ILN11199Embraer EMB-145XR · S/N 14500953Built 2006 · Chicago, ILN11206Boeing 737-824 · S/N 30578Built 2000 · Chicago, ILN12003Boeing 787-10 · S/N 40935Chicago, ILN12004Boeing 787-10 · S/N 60139Built 2019 · Chicago, ILN12005Boeing 787-10 · S/N 40937Built 2019 · Chicago, ILN12006Boeing 787-10 · S/N 60140Built 2019 · Chicago, ILN12010Boeing 787-10 · S/N 40926Built 2019 · Chicago, ILN12012Boeing 787-10 · S/N 60145Built 2020 · Chicago, ILN12020Boeing 787-10 · S/N 66989Built 2022 · Chicago, ILN12021Boeing 787-10 · S/N 66990Built 2022 · Chicago, ILN120UABoeing 747-422 · S/N 29166Built 1999 · Chicago, ILN12109Boeing 757-224 · S/N 27299Built 1994 · Chicago, ILN12114Boeing 757-224 · S/N 27556Built 1995 · Chicago, ILN12116Boeing 757-224 · S/N 27558Built 1996 · Chicago, ILN12125Boeing 757-224 · S/N 28967Built 1998 · Chicago, ILN12135Embraer EMB-145XR · S/N 145718Built 2003 · Chicago, ILN12136Embraer EMB-145XR · S/N 145719Built 2003 · Chicago, ILN12142Embraer EMB-145XR · S/N 145735Built 2003 · Chicago, ILN12145Embraer EMB-145XR · S/N 145745Built 2003 · Chicago, ILN12157Embraer EMB-145XR · S/N 145787Built 2004 · Chicago, ILN12160Embraer EMB-145XR · S/N 145799Built 2004 · Chicago, ILN12163Embraer EMB-145XR · S/N 14500811Built 2004 · Chicago, ILN12167Embraer EMB-145XR · S/N 14500834Built 2004 · Chicago, ILN12172Embraer EMB-145XR · S/N 14500864Built 2004 · Chicago, ILN12175Embraer EMB-145XR · S/N 14500878Built 2004 · Chicago, ILN12195Embraer EMB-145XR · S/N 14500943Built 2005 · Chicago, ILN12201Embraer EMB-145XR · S/N 14500959Built 2006 · Chicago, ILN12216Boeing 737-824 · S/N 28776Built 1998 · Chicago, ILN12218Boeing 737-824 · S/N 28778Built 1998 · Chicago, ILN12221Boeing 737-824 · S/N 28930Built 1998 · Chicago, IL
Back to United Airlines Inc