AD 2017-24-03

Registered aircraft · 937

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:2017-24-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:2017-24-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.

N129AABank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6401N130ANBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6407N131NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6472N132ANBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6473N133ANBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6482N134ANBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6495N135NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6520N136ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6532N137AAAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6647N138ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6650N139ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6687N140ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6667N141NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6656N142ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6711N1438Bank Of Utah Trustee · Salt Lake City, UTBuilt 1998 · S/N 1438N143ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6745N144ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6723N145ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6783N146AAAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6761N147AAAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6802N148ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6790N149ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6812N150NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6828N151ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6840N152AAAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6887N153ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6908N154AAAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 6928N155NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 6940N156ANAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 6983N157AAAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 6998N158ANAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7009N158ASAersale Inc · Coral Gables, FLS/N 1578N159ANAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7034N160ANAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7069N161AAAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7085N162AAAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 6621N163AAAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 6866N164NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 6909N165NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 6956N166NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 6973N167ANAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7013N188NVAllegiant Air LLC · Las Vegas, NVBuilt 2013 · S/N 5669N189NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2013 · S/N 5687N1902UUnited Airlines Inc · Chicago, ILBuilt 2006 · S/N 2714N190NVAllegiant Air LLC · Las Vegas, NVBuilt 2015 · S/N 6669N1914UUnited Airlines Inc · Chicago, ILS/N 2223N191NVAllegiant Air LLC · Las Vegas, NVBuilt 2015 · S/N 6704N192NVAllegiant Air LLC · Las Vegas, NVBuilt 2015 · S/N 6787N193NVAllegiant Air LLC · Las Vegas, NVBuilt 2015 · S/N 6835N194NVAllegiant Air LLC · Las Vegas, NVBuilt 2015 · S/N 6889
Back to AD 2017-24-03