AD 2011-16-03

Registered aircraft · 1,606

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-16-03')
    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-16-03')
  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.

N135NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6520N135UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 0818N136ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6532N136UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 0819N137AAAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6647N137ARWyatt Aerospace LLC · Chandler, AZFirst renewal noticeS/N 362N137UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 0820N138ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6650N138UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 0821N139ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6687N139UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 0822N140ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6667N140UPUnited Parcel Service Co · Louisville, KYBuilt 2002 · S/N 0823N141NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6656N141UPUnited Parcel Service Co · Louisville, KYBuilt 2002 · S/N 0824N142ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6711N142UPUnited Parcel Service Co · Louisville, KYBuilt 2002 · S/N 0825N1438Bank Of Utah Trustee · Salt Lake City, UTBuilt 1998 · S/N 1438N143ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6745N143UPUnited Parcel Service Co · Louisville, KYBuilt 2002 · S/N 0826N144ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6723N144UPUnited Parcel Service Co · Louisville, KYBuilt 2002 · S/N 0827N145ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6783N145UPUnited Parcel Service Co · Louisville, KYBuilt 2002 · S/N 0828N146AAAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6761N146UPUnited Parcel Service Co · Louisville, KYBuilt 2003 · S/N 829N147AAAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6802N147UPUnited Parcel Service Co · Louisville, KYBuilt 2003 · S/N 830N148ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6790N148UPUnited Parcel Service Co · Louisville, KYBuilt 2003 · S/N 0831N149ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6812N149UPUnited Parcel Service Co · Louisville, KYBuilt 2003 · S/N 832N150NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6828N150UPUnited Parcel Service Co · Louisville, KYBuilt 2003 · S/N 833N150UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5504N151ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6840N151UPUnited Parcel Service Co · Louisville, KYBuilt 2003 · S/N 834N151UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5513N1523Msn 1523 LLC · San Diego, CABuilt 2001 · S/N 1523N152AAAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6887N152UPUnited Parcel Service Co · Louisville, KYBuilt 2003 · S/N 835N152UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5588N153ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6908N153UPUnited Parcel Service Co · Louisville, KYBuilt 2003 · S/N 0839N153UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5594N154AAAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 6928N154UPUnited Parcel Service Co · Louisville, KYBuilt 2004 · S/N 0840N154UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5644N155NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 6940N155UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5659
Back to AD 2011-16-03