AD 2011-07-05

Registered aircraft · 351

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2011-07-05')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-07-05')
  ORDER BY 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.

N771UAUnited Airlines Inc · Chicago, ILBuilt 1995 · S/N 26932N772ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29580N772BCBoeing Aircraft Holding Company · Renton, WABuilt 2003 · S/N 32320N772ETAlta 777 LLC · Salt Lake City, UTBuilt 2001 · S/N 29747N772UAUnited Airlines Inc · Chicago, ILBuilt 1995 · S/N 26930N773ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29583N773UAUnited Airlines Inc · Chicago, ILBuilt 1995 · S/N 26929N774ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29581N774CLIagcas LLC · Miami, FLFirst renewal noticeS/N 28348N774UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 26936N775ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29584N775DBTvpx Ars Inc Trustee · North Salt Lake, UTS/N 27108N775KWAlf V LLC · Chicago, ILS/N 28281N775LGLogistic Air Inc · Reno, NVS/N 32893N775UAUnited Airlines Inc · Chicago, ILBuilt 1995 · S/N 26947N776ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29582N776KWAlf V LLC · Chicago, ILS/N 32650N776LGLogistic Air Inc · Reno, NVS/N 33394N776UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 26937N777ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29585N777AZWilmington Trust Company Trustee · Wilmington, DEBuilt 2002 · S/N 29743N777LALogistic Air Inc · Reno, NVS/N 32894N777UAUnited Airlines Inc · Chicago, ILBuilt 1995 · S/N 26916N778ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29587N778LGLogistic Air Inc · Reno, NVS/N 32895N778UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 26940N779ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29955N779UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 26941N78001United Airlines Inc · Chicago, ILBuilt 1998 · S/N 27577N78002United Airlines Inc · Chicago, ILBuilt 1998 · S/N 27578N78003United Airlines Inc · Chicago, ILBuilt 1998 · S/N 27579N78004United Airlines Inc · Chicago, ILBuilt 1998 · S/N 27580N78005United Airlines Inc · Chicago, ILBuilt 1998 · S/N 27581N78008United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29478N78009United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29479N78013United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29861N78017United Airlines Inc · Chicago, ILBuilt 2002 · S/N 31679N780ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29956N780UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 26944N781ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29586N781UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 26945N782ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30003N782UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26948N783ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30004N783UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26950N784ANUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 29588N784UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26951N785ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30005N785UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26954N786ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30250
Back to AD 2011-07-05