AD 2012-06-11

Registered aircraft · 411

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

N915USAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6387N916USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6420N917UYAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6427N918USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6443N919USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6479N920USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6490N921USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6523N922USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6537N923JBJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 5960N923USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6543N924USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6569N925UYAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6613N926UWAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6618N927UWAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6625N928AMAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7515N929AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7525N929JBJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6031N930AUAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7539N931AMAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7541N932AMAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7419N933AMAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7564N934AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7500N934JBJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6130N935JBJet Blue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6185N937JBJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6245N941MBUmb Bank Na Trustee · Salt Lake City, UTS/N 0941N942JBJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6279N943JTJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6326N944JTJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6359N945JTJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6390N946JLJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6425N947JBJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6448N948JBJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6560N949JTJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6575N950JTJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6609N952JBJet Blue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6663N954JBJet Blue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6725N955JBJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6757N956JTJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6791N957JBJet Blue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6809N958JBJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6859N959JBJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6903N961JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 6930N962JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 6988N964JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7018N965JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 6512N966ADBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 1966N966ASUmb Bank Na Trustee · Salt Lake City, UTS/N 1241N966JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7230N967JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7257
Back to AD 2012-06-11