AD 2011-01-09

Registered aircraft · 9,490

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

N111ZMAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 5983N11206United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30578N112ANAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 5991N112BJDg Group Aviation LLC · Bloomfield Hills, MIBuilt 1996 · S/N RK-112N112BZBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 19000077N112DNDelta Air Lines Inc · Atlanta, GABuilt 2021 · S/N 10085N112EDE D Santos & Associates LLC Trustee · Wilmington, DES/N 258048N112HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000174N112MYAir Force Fun LLC · Woodbury, NYBuilt 2011 · S/N 9442N112QSRegistered aircraftBuilt 2015 · S/N 9710N112USAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1134N112VLBank Of Utah Trustee · Salt Lake City, UTS/N 8011N112YVUas Transervices Inc · Boca Raton, FLBuilt 1990 · S/N UC112N113ANAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6020N113AXAlaska Central Express Inc · Anchorage, AKBuilt 1988 · S/N UC-41N113DXDelta Air Lines Inc · Atlanta, GABuilt 2021 · S/N 10100N113HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000177N113QSRegistered aircraftBuilt 2015 · S/N 9722N113SRAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1994 · S/N 5164N114AXAlpine Aviation Inc · Provo, UTBuilt 1988 · S/N UC-36N114BZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 19000092N114DNDelta Air Lines Inc · Atlanta, GABuilt 2021 · S/N 10122N114HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000179N114QSRegistered aircraftBuilt 2015 · S/N 9732N114SYSkywest Airlines Inc · St George, UTBuilt 2014 · S/N 17000410N114UWAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1148N11526Corporate Flight Managment Inc · Smyrna, TNBuilt 2001 · S/N 145410N11535Delux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145518N11536Bank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 145520N11539Delux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145536N11565Corporate Flight Management Inc · Smyrna, TNBuilt 2002 · S/N 145621N115ADAmerican Promotional Events Inc · Florence, ALBuilt 2011 · S/N 20331N115AXAlaska Central Express Inc · Anchorage, AKBuilt 1988 · S/N UC-2N115BZWilmington Trust Co Trustee · Wilmington, DES/N 19000096N115DNDelta Air Lines Inc · Atlanta, GABuilt 2021 · S/N 10132N115HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000182N115JSRegistered aircraftBuilt 2015 · S/N 9744N115LFAirlynner LLC · Jackson, WYBuilt 2008 · S/N 20226N115MHA7p Trust Co Inc Trustee · Cheyenne, WYBuilt 2011 · S/N 9463N115NNAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6063N115PKJet Midwest Inc · Kansas City, MOS/N 0088N115QSRegistered aircraftBuilt 2015 · S/N 9734N115SEAdvanta Aviation 3500 LLC · La Jolla, CABuilt 2022 · S/N 20926N115TRTasco LLC · New York, NYBuilt 2000 · S/N 9067N116ADStone Holdings LLC · Towson, MDBuilt 2002 · S/N RK-338N116ANUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6070N116BTUmb Bank Na Trustee · Salt Lake City, UTS/N 19028N116BZWilmington Trust Co Trustee · Wilmington, DES/N 19000101N116DNDelta Air Lines Inc · Atlanta, GABuilt 2021 · S/N 10121N116HFAirbourne International Inc · Wilmington, DEBuilt 2004 · S/N 20011
Back to AD 2011-01-09