AD 2000-05-08

Registered aircraft · 695

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:2000-05-08')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-05-08')
  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.

N724UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 1122N725UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 1135N730AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6132N730USAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 1182N732USAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 1203N733UWAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 1205N737USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1245N738USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1254N740UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1265N741UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1269N742PSBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1275N744PBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1287N745VJBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1289N746UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1297N747UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1301N748UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1311N749USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1313N750UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1315N751UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1317N752USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1319N753USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1326N754UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1328N755USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1331N756USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1340N757UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1342N758USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1348N760USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1354N762USUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1358N763USUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1360N764USUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1369N765USUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1371N766USUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1378N767UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1382N768USUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1389N769USUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1391N770UWUmb Bank N A Trustee · Salt Lake City, UTBuilt 2000 · S/N 1393N771XFWilmington Trust Co Trustee · Wilmington, DEBuilt 2003 · S/N 1980N772XFWilmington Trust Co Trustee · Wilmington, DEBuilt 2003 · S/N 1997N773XFWilmington Trust Co Trustee · Wilmington, DEBuilt 2003 · S/N 2012N774XFWilmington Trust Co Trustee · Wilmington, DEBuilt 2003 · S/N 2019N775XFWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 2198N776XFWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 2209N778XFBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4127N801AWU S Bank Na Trustee · Boston, MABuilt 1998 · S/N 0889N801UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 686N802AWU S Bank Na Trustee · Boston, MABuilt 1998 · S/N 0924N802UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 690N803AWU S Bank Na Trustee · Boston, MABuilt 1998 · S/N 0931N803UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 0748N804AWU S Bank Na Trustee · Boston, MABuilt 1999 · S/N 1043
Back to AD 2000-05-08