AD 2000-22-07

Registered aircraft · 442

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-22-07')
    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-22-07')
  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.

N929JBJetblue 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 7541N931TBBoeing Company · Renton, WABuilt 1998 · S/N 53532N932AMAmerican 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 6245N942JBJetblue 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 6988N963DNBoeing Company · Renton, WABuilt 1999 · S/N 53533N964JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7018N965JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 6512N966JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7230N967JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7257N968JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7305N969JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7353N970JBJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7415N970UYAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3924N971JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7390N972JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7455N972UYAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4123N973JTJetblue Airways Corp · Long Island City, NYBuilt 2018 · S/N 8581N973UYAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4893N974JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7448N974UYAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4898N975JTJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7520N975UYAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4935N976JTJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7529N976UYUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5235N977JEJetblue Airways Corp · Long Island City, NYBuilt 2018 · S/N 8641N977UYAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5409
Back to AD 2000-22-07