AD 2007-19-13

Registered aircraft · 2,446

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:2007-19-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:2007-19-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.

N626NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 5999N627JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2577N627NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6082N628NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6193N628VAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2007 · S/N 2993N629JBJetblue Airways · Long Island City, NYBuilt 2005 · S/N 2580N629NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6300N630JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2640N630NKWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2014 · S/N 6304N630SNMobility Air LLC · Estero, FLS/N 48630N630VABank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 3101N631NKUmb Bank Na - Trustee · Salt Lake City, UTBuilt 2014 · S/N 6327N632AVBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2013 · S/N 5632N632JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2647N633JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2671N633NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6345N633VAAj Aviation Holdings LLC · Miami Springs, FLBuilt 2007 · S/N 3230N634JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2710N634NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6370N635JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2725N635NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6383N636JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2755N636NKUmb Bank Na - Trustee · Salt Lake City, UTBuilt 2015 · S/N 6424N637JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2781N637NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6436N638JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2802N638NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6463N639ACBank Of Utah Trustee · Salt Lake City, UTS/N 1162N639JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2814N639NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6487N640JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2832N640NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6507N641AZAmazon.Com Services LLC · Seattle, WABuilt 2000 · S/N 30595N641JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2848N641NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6566N641UAUnited Airlines Inc · Chicago, ILBuilt 1991 · S/N 25091N642NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6586N642UAUnited Airlines Inc · Chicago, ILBuilt 1991 · S/N 25092N642VAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 3670N643AZAmazon.Com Services LLC · Seattle, WABuilt 2001 · S/N 32776N643JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2871N643NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6616N643UAUnited Airlines Inc · Chicago, ILBuilt 1991 · S/N 25093N644JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2880N644NKSpirit Airlines LLC · Dania Beach, FLBuilt 2016 · S/N 7156N644UAUnited Airlines Inc · Chicago, ILBuilt 1991 · S/N 25094N645ACBank Of Utah Trustee · Salt Lake City, UTS/N 1259N645GTAtlas Air Inc · Purchase, NYBuilt 1995 · S/N 27393N645JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2900N645NKSpirit Airlines LLC · Dania Beach, FLBuilt 2016 · S/N 7008
Back to AD 2007-19-13