AD 2000-03-51

Registered aircraft · 131

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

N906ATDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 55087N910ATDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 55086N913DECorsair Two LLC · Hillsboro, ORBuilt 1993 · S/N 49956N915ATDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 55085N919ATDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 55084N920ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55083N921ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55082N922ATDelta Air Lines Inc · Atlanta, GABuilt 2005 · S/N 55050N923ATDelta Air Lines Inc · Atlanta, GABuilt 2005 · S/N 55051N924ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55080N925ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55079N926ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55078N927ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55077N928ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55076N929ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55075N929DNDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 53459N930ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55072N930DNDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 53458N930TBBoeing Co · Renton, WABuilt 1995 · S/N 53388N931TBBoeing Company · Renton, WABuilt 1998 · S/N 53532N932ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55073N932NAAstro Zero G One Corp · Dover, DES/N 47476N933ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55071N934ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55070N935ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55069N936ATDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 55058N937ATDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 55091N938ATDelta Air Lines Inc · Atlanta, GABuilt 2006 · S/N 55098N939ATDelta Air Lines Inc · Atlanta, GABuilt 2006 · S/N 55099N940ATDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 55004N942ATDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 55005N943ATDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 55006N944ATDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 55007N945ATDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 55008N946ATDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 55009N947ATDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 55010N948ATDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 55011N949ATDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 55003N950ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55012N951ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55013N952ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55014N953ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55015N954ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55016N955ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55017N957ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55019N959ATDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 55021N960ATDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 55022N961ATDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 55023N963ATDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 55024N963DNBoeing Company · Renton, WABuilt 1999 · S/N 53533
Back to AD 2000-03-51