AD 2006-26-13

Registered aircraft · 599

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:2006-26-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:2006-26-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.

N683DADelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 27103N684DADelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 27104N685DADelta Air Lines Inc · Atlanta, GABuilt 1995 · S/N 27588N686AABank Of Utah Trustee · Salt Lake City, UTBuilt 1992 · S/N 25343N686DADelta Air Lines Inc · Atlanta, GABuilt 1995 · S/N 27589N687DLDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 27586N688DLDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 27587N688SLAero Micronesia Inc DBA · Barrigada, GUBuilt 1991 · S/N 25140N689DLDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 27172N690DLDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 27585N692AAAersale Inc · Doral, FLBuilt 1993 · S/N 26972N692DLDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29724N693DLDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29725N694ANBank Of Utah Trustee · Salt Lake City, UTBuilt 1994 · S/N 26974N694DLDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29726N695DLDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29727N696ANBank Of Utah Trustee · Salt Lake City, UTBuilt 1994 · S/N 26976N696DLDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29728N697ANBank Of Utah Trustee · Salt Lake City, UTBuilt 1994 · S/N 26977N697DLDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30318N698DLDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29911N699DLDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29970N700KWEastern Airlines LLC · Kansas City, MOBuilt 1992 · S/N 25443N702CAAc Spe 5 LLC · Orlando, FLBuilt 1994 · S/N 27217N703CKKalitta Air LLC · Ypsilanti, MIBuilt 1990 · S/N 24226N703KWEastern Airlines LLC · Kansas City, MOBuilt 1991 · S/N 24343N705KWEastern Airlines LLC · Kansas City, MOBuilt 1992 · S/N 24342N705TWDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28479N706KWEastern Airlines LLC · Kansas City, MOBuilt 1990 · S/N 24339N706PCOmega Air Inc · San Antonio, TXS/N 20177N707CAOmega Air Inc · San Antonio, TXS/N 18586N707MQAircraft Endeavors LLC · San Antonio, TXBuilt 1977 · S/N 21368N708AAWorld Aviation Services LLC · Medley, FLBuilt 1981 · S/N 22465N708SSierra Pacific Airlines Inc · Tucson, AZBuilt 1995 · S/N 27424N709SSierra Pacific Airlines Inc · Tucson, AZBuilt 1997 · S/N 28722N711ZXDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28481N717TWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 28485N718TWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 28486N720CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1977 · S/N 21298N721TWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29954N722TWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29385N723TWDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29378N724CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1971 · S/N 20383N724TWR&W Flying Inc · Greenbrier, ARS/N 28488N726USUSA Jet Airlines Inc · Belleville, MIBuilt 1981 · S/N 22469N727HLAviation Sales And Charter LLC · Dover, DES/N 22642N727NKAntares Aviation LLC · Boca Raton, FLBuilt 1979 · S/N 21945N727TWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30340N727USUSA Jet Airlines Inc · Belleville, MIBuilt 1981 · S/N 22470N727YKFayaka Airways LLC · San Francisco, CANon-citizen corporation, flight hours not reportedS/N 21442
Back to AD 2006-26-13