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.

N379HAWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2015 · S/N 1672N380HAAelf Msn 1104 LLC · Chicago, ILBuilt 2010 · S/N 1104N381HAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2010 · S/N 1114N382HAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2010 · S/N 1171N383HAHawaiian Airlines Inc · Seattle, WABuilt 2011 · S/N 1217N384HAHawaiian Airlines Inc · Seattle, WABuilt 2011 · S/N 1259N385HAHawaiian Airlines Inc · Seattle, WABuilt 2012 · S/N 1295N386HAAlaska Airlines Inc · Seatac, WABuilt 2012 · S/N 1302N388HAAlaska Airlines Inc · Seattle, WABuilt 2012 · S/N 1310N389HABank Of Utah Trustee · Salt Lake City, UTS/N 1316N390HAWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 1389N391HAHawaiian Airlines Inc · Seatac, WABuilt 2013 · S/N 1399N392HAWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 1404N393HAAlaska Airlines Inc · Seatac, WABuilt 2013 · S/N 1422N395HAAlaska Airlines Inc · Seattle, WABuilt 2013 · S/N 1469N396HAHawaiian Airlines Inc · Seattle, WABuilt 2014 · S/N 1488N399HAHawaiian Airlines Inc · Seattle, WABuilt 2014 · S/N 1496N399MTBank Of Utah Trustee · Salt Lake City, UTS/N 29741N455ACBank Of Utah Trustee · Salt Lake City, UTS/N 1364N4621KUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 1902N463ACUmb Bank Na Trustee · Salt Lake City, UTBuilt 2007 · S/N 35299N4649KUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 1863N4663KUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 1865N4787KUmb Bank Na Trustee · Seatac, WABuilt 2018 · S/N 1874N508BCAlta 777 LLC · Salt Lake City, UTS/N 30873N509BCJet Midwest Inc · Kansas City, MOBuilt 2003 · S/N 33370N519BCAlta 777 LLC · Salt Lake City, UTS/N 32321N529CGCargo Aircraft Management Inc · Wilmington, OHS/N 529N57016United Airlines Inc · Chicago, ILBuilt 2000 · S/N 28679N577NANasa Langley Research Center · Hampton, VAS/N 32892N577TABank Of Utah Trustee · Salt Lake City, UTS/N 355N5827KUmb Bank Na Trustee · Seatac, WABuilt 2010 · S/N 1081N5843KUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 1071N5869KUmb Bank Na Trustee · Salt Lake City, UTBuilt 2011 · S/N 1205N5879KUmb Bank Na Trustee · Salt Lake City, UTBuilt 2011 · S/N 1226N5881KUmb Bank Na Owner Trustee · Salt Lake City, UTBuilt 2010 · S/N 1167N5897KUmb Bank Na Trustee · Salt Lake City, UTBuilt 2011 · S/N 1245N60VLBank Of Utah Trustee · Salt Lake City, UTS/N 39254N666CATvpx Trust Co LLC Trustee · North Salt Lake, UTS/N 36157N69020United Airlines Inc · Chicago, ILBuilt 2007 · S/N 31687N7019KAmazon.Com Services LLC · Seattle, WAS/N 1359N7057KAmazon.Com Services LLC · Seattle, WAS/N 1546N705DNJetran LLC · Horseshoe Bay, TXBuilt 2009 · S/N 29742N709DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 40559N70VLBank Of Utah Trustee · Salt Lake City, UTS/N 30440N710DNJetran LLC · Horseshoe Bay, TXBuilt 2010 · S/N 40560N717ANAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 31543N718ANAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 41665N719ANAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 41668N720ANBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33522
Back to AD 2011-07-05