AD 2002-18-01

Registered aircraft · 972

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

N755AVWells Fargo Trust Co Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 7437N760JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3659N763AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4763N763JBJetblue Airways Corp · Long Island, NYBuilt 2008 · S/N 3707N766JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3724N768JBJetblue Airways Corp · Long Island City, NYBuilt 2009 · S/N 3760N775JBJetblue Airways Corp · Long Island City, NYBuilt 2009 · S/N 3800N779JBJetblue 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 5060N804JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5142N805JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5148N806JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5302N807JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5312N809JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5349N821AVAircol 22 · Wilmington, DEBuilt 2011 · S/N 4821N821JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5417N827JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5677N827QDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 0827N828JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5723N834JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5782N837VABank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4558N851ASUmb Bank Na Trustee · Salt Lake City, UTS/N 1185N862AVAircol 23 · Wilmington, DEBuilt 2011 · S/N 4862N900UWAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7617N901AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7636N902AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7519N903AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7566N903JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5783N904AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7613N905AUBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7700N905JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5854N906AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7651N907AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7732N907JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5865N908AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7775N909AMWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 7756N910AUWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 7876N912UYAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6264N913JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5909N913USAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6255N914UYAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6337N915USAmerican 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 6479
Back to AD 2002-18-01