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.

N947ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29536N947JBJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6448N947NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 31190N948ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30086N948AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4933N948JBJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6560N948NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 31189N949ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29537N949JTJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6575N949NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 31192N950AMUmb Bank Na Owner Trustee · Salt Lake City, UTS/N 35115N950ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30087N950AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2008 · S/N 3545N950JTJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6609N950NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31194N951AAAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29538N951AVWilmington Trust Company Trustee · Wilmington, DEBuilt 2008 · S/N 3574N951NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 33327N952AAAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30088N952CAAc Spe 3 LLC · Orlando, FLBuilt 1991 · S/N 25238N952JBJet Blue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6663N952NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31196N953ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29539N953JMAlta Airlines Holdings LLC · Salt Lake City, UTS/N 25151N953NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 33328N954ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30089N954AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2008 · S/N 3699N954JBJet Blue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6725N954NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31197N955ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29540N955AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 3835N955JBJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6757N955NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31199N956ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30090N956AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6050N956JTJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6791N956NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 31200N957AMUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 39957N957ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29541N957AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6057N957JBJet Blue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6809N957NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31202N958AMUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 39958N958ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30091N958AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6103N958JBJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6859N958NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 31203N959ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30828N959AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6110N959BLRegistered aircraftN-number assigned (import), not yet registeredS/N 60959
Back to AD 2007-19-13