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.

N684NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8047N685FEFederal Express Corp · Memphis, TNBuilt 1999 · S/N 0803N685NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8115N686FEFederal Express Corp · Memphis, TNBuilt 1999 · S/N 0804N686NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8141N686TAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5238N687FEFederal Express Corp · Memphis, TNBuilt 2007 · S/N 0873N687NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8160N688FEFederal Express Corp · Memphis, TNBuilt 2007 · S/N 0874N688TAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5243N689FEFederal Express Corp · Memphis, TNBuilt 2007 · S/N 0875N689TAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5333N69020United Airlines Inc · Chicago, ILBuilt 2007 · S/N 31687N690FEFederal Express Corp · Memphis, TNBuilt 2007 · S/N 0876N690NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8434N691FEFederal Express Corp · Memphis, TNBuilt 2007 · S/N 0877N691NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8614N692FEFederal Express Corp · Memphis, TNBuilt 2007 · S/N 0878N692NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8611N693NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8659N694NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8632N696NKSpirit Airlines LLC · Dania Beach, FLBuilt 2019 · S/N 8824N700KWEastern Airlines LLC · Kansas City, MOBuilt 1992 · S/N 25443N7019KAmazon.Com Services LLC · Seattle, WAS/N 1359N701FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6793N702CAAc Spe 5 LLC · Orlando, FLBuilt 1994 · S/N 27217N702FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6825N703CKKalitta Air LLC · Ypsilanti, MIBuilt 1990 · S/N 24226N703JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3381N703KWEastern Airlines LLC · Kansas City, MOBuilt 1991 · S/N 24343N704FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6845N7057KAmazon.Com Services LLC · Seattle, WAS/N 1546N705FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6891N705JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3416N705KWEastern Airlines LLC · Kansas City, MOBuilt 1992 · S/N 24342N706FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6926N706JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3451N706KWEastern Airlines LLC · Kansas City, MOBuilt 1990 · S/N 24339N708FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2015 · S/N 7042N708JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3479N708MBUmb Bank Na Trustee · Salt Lake City, UTBuilt 2001 · S/N 30878N709FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2016 · S/N 7097N709JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3488N710FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2016 · S/N 7179N711FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7184N712FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2016 · S/N 7204N712JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3517N713FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7286N714FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7294N715FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2016 · S/N 7313
Back to AD 2007-19-13