AD 2004-11-13

Registered aircraft · 1,301

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-11-13')
    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-11-13')
  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.

N748AVNavigator Aviation II Msn 6862 Trust · Wilmington, DEBuilt 2015 · S/N 6862N748UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1311N749USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1313N750AVNavigator Aviation II Msn 7120 Trust · Wilmington, DEBuilt 2016 · S/N 7120N750UWBank 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 1328N755AVWells Fargo Trust Co Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 7437N755USBank 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 1348N760JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3659N760USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1354N762USUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1358N763AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4763N763JBJetblue Airways Corp · Long Island, NYBuilt 2008 · S/N 3707N763USUmb 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 1371N766JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3724N766USUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1378N767UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1382N768JBJetblue Airways Corp · Long Island City, NYBuilt 2009 · S/N 3760N768USUmb 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 2019N775JBJetblue Airways Corp · Long Island City, NYBuilt 2009 · S/N 3800N775XFWilmington 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 4127N779JBJetblue Airways Corp · Long Island City, NYBuilt 2009 · S/N 3811N784JBJetblue Airways Corp · Long Island City, NYBuilt 2011 · S/N 4578N789JBJetblue Airways Corp · Long Island, NYBuilt 2011 · S/N 4612N793JBJetblue Airways Corp · Long Island City, NYBuilt 2011 · S/N 4647N794JBJetblue Airways Corp · Long Island City, NYBuilt 2011 · S/N 4904N796JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5060N8001NAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5678N8009TAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5788N801AWU S Bank Na Trustee · Boston, MABuilt 1998 · S/N 0889N801UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 686N8027DAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6437N802AWU S Bank Na Trustee · Boston, MABuilt 1998 · S/N 0924N802UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 690
Back to AD 2004-11-13