AD 2011-12-01

Registered aircraft · 4,702

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-12-01')
    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-12-01')
  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.

N150FEFederal Express Corp · Memphis, TNBuilt 2017 · S/N 42729N150NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6828N150UBrown Jim L · Soddy Daisy, TNS/N 42-44629N150UPUnited Parcel Service Co · Louisville, KYBuilt 2003 · S/N 833N150UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5504N151Tatonduk Outfitters Ltd · Fairbanks, AKS/N 45179N1511AAtlas Air Inc · Purchase, NYBuilt 1989 · S/N 24318N151ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6840N151ATPurkinje Ltd LLC · Wilmington, DES/N 49-3151N151FEFederal Express Corp · Memphis, TNBuilt 2017 · S/N 43630N151UPUnited 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 6887N152FEFederal Express Corp · Memphis, TNBuilt 2017 · S/N 43552N152UPUnited 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 6908N153FEFederal Express Corp · Memphis, TNBuilt 2017 · S/N 63095N153NAMeyerhoff Jens · Fountain Hills, AZFirst renewal noticeS/N 53-4568N153UPUnited 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 6928N154CFNelson Craig Martin · Eastsound, WABuilt 1960 · S/N 51985N154FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 42730N154TSFalcon Aviation Holdings LLC · Hawthorne, CABuilt 2002 · S/N 30515N154UPUnited Parcel Service Co · Louisville, KYBuilt 2004 · S/N 0840N154UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5644N155CAHeavylift Cargo Airlines Inc · Kingman, AZS/N 46073N155FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 43631N155NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 6940N155UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5659N156ANAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 6983N156FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 63096N156UPUnited Parcel Service Co · Louisville, KYBuilt 2004 · S/N 0845N156UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5684N15710United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28780N15712United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28783N157AAAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 6998N157DCExperimental Aircraft Association Inc · Oshkosh, WIBuilt 1949 · S/N 49-3141N157FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 42731N157UPUnited Parcel Service Co · Louisville, KYBuilt 2004 · S/N 0846N157UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5696N158ANAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7009N158ASAersale Inc · Coral Gables, FLS/N 1578N158FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 63097N158JPAerotrust Services Corp Trustee · Wilmington, DES/N 53195N158JZAcv Group LLC · Mckinleyville, CABuilt 1949 · S/N 49-3158N158UPUnited Parcel Service Co · Louisville, KYBuilt 2004 · S/N 0847N159ANAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7034
Back to AD 2011-12-01