AD 2004-22-01

Registered aircraft · 3,402

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:2004-22-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:2004-22-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.

N14735United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28950N147AAAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6802N147FEFederal Express Corp · Memphis, TNBuilt 2017 · S/N 63094N147UPUnited Parcel Service Co · Louisville, KYBuilt 2003 · S/N 830N148ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6790N148FEFederal Express Corp · Memphis, TNBuilt 2017 · S/N 42728N148UPUnited Parcel Service Co · Louisville, KYBuilt 2003 · S/N 0831N1499AAndromeda Leasing I LLC · Purchase, NYBuilt 1996 · S/N 27428N149ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6812N149FEFederal Express Corp · Memphis, TNBuilt 2017 · S/N 62498N149UPUnited Parcel Service Co · Louisville, KYBuilt 2003 · S/N 832N149XAEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1993 · S/N 27149N150FEFederal Express Corp · Memphis, TNBuilt 2017 · S/N 42729N150NNAmerican 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 5504N1511AAtlas Air Inc · Purchase, NYBuilt 1989 · S/N 24318N151ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6840N151FEFederal 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 63095N153UPUnited 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 6928N154FEFederal 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 6998N157FEFederal 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 7009
Back to AD 2004-22-01