AD 2003-11-23

Registered aircraft · 171

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

N620NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 5624N621NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5672N622NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5804N623NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5861N624NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5880N626NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 5999N627NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6082N628NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6193N629NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6300N630NKWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2014 · S/N 6304N631NKUmb Bank Na - Trustee · Salt Lake City, UTBuilt 2014 · S/N 6327N633NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6345N634NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6370N635NKBank 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 6463N639JBJetblue 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 6507N641JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2848N641NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6566N642NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6586N643JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2871N643NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6616N644JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2880N644NKSpirit Airlines LLC · Dania Beach, FLBuilt 2016 · S/N 7156N645JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2900N645NKSpirit Airlines LLC · Dania Beach, FLBuilt 2016 · S/N 7008N646JBJetblue Airways Corp · Long Island, NYBuilt 2006 · S/N 2945N646NKSpirit Airlines LLC · Dania Beach, FLBuilt 2016 · S/N 7062N647NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 7635N648JBJetblue Airways Corp · Long Island, NYBuilt 2006 · S/N 2970N648NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 7656N649JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2977N649NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 7679N650NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 7724N651JBJetblue Airways Corp · Long Island, NYBuilt 2007 · S/N 2992N651NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 8018N652JBJetblue Airways Corp · Long Island City, NYBuilt 2007 · S/N 3029N652NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 8021N653JBJetblue Airways Corp · Long Island City, NYBuilt 2007 · S/N 3039N653NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8012N654NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8176N655JBJetblue Airways Corp · Long Island, NYBuilt 2007 · S/N 3072N655NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8376
Back to AD 2003-11-23