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.

N679NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7825N680NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7870N681NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 7908N682NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 7957N683NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8114N684NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8047N685NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8115N686NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8141N687NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8160N701FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6793N702FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6825N704FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6845N705FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6891N706FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6926N708FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2015 · S/N 7042N709FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2016 · S/N 7097N710FRWilmington 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 7204N713FRBank 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 7313N716FRWells Fargo Trust Co Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7524N717FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7536N718FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7575N719FRWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2017 · S/N 7736N720FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 7852N721FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7884N722FRAlc A321 8579 LLC · Camden, DEBuilt 2018 · S/N 8579N723FRAlc A321 8640 LLC · Camden, DEBuilt 2018 · S/N 8640N827QDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 0827N851ASUmb Bank Na Trustee · Salt Lake City, UTS/N 1185N900UWAmerican 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 6337
Back to AD 2012-06-11