AD 2000-05-08

Registered aircraft · 695

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-05-08')
    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-05-08')
  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.

N335NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1662N335NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2006 · S/N 2852N336NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1683N337NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1685N337NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2004 · S/N 2170N338NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1693N338NVSunrise Asset Management LLC · Las Vegas, NVS/N 2378N339NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1709N340NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1714N341NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1738N342NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1746N343NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1752N344NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1766N345NBDelta Air Lines Inc · Atlanta, GAS/N 1774N346NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1796N347NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1800N348NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1810N349NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1815N351NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1820N352NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1824N353NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1828N354NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1833N355FLBank Of Utah Trustee · Salt Lake City, UTS/N 2553N355NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1839N357NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1875N358NBDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 1897N359NBDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 1923N360NBDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 1959N361NBDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 1976N362NBDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 1982N363NBDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 1990N364NBDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 2002N365NBDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 2013N366DXDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 8694N366NBDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 2026N367DNDelta Air Lines Inc · Altanta, GABuilt 2019 · S/N 8713N368DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 8695N368NBDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 2039N369DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 8697N369NBDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 2047N370DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 8765N370NBDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 2087N371DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 8763N371NBDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 2095N372DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8809N373DXBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8734N374DXBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8810N375DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 8812N376DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 8858N377DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 8856
Back to AD 2000-05-08