AD 2000-07-27

Registered aircraft · 1,686

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-07-27')
    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-07-27')
  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.

N207FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2010 · S/N 4307N207NVAllegiant Air LLC · Las Vegas, NVBuilt 2013 · S/N 5638N208NVAllegiant Air LLC · Las Vegas, NVBuilt 2013 · S/N 5640N209NVAllegiant Air LLC · Las Vegas, NVBuilt 2013 · S/N 5901N210NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2013 · S/N 5540N211NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2013 · S/N 5442N212NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2013 · S/N 5498N215NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2000 · S/N 1292N21723United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28790N218NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2000 · S/N 1229N219NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2000 · S/N 1255N220NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2000 · S/N 1262N226VLSetna Io LLC · Lincolnshire, ILS/N 2264N228NVSunrise Asset Management LLC · Las Vegas, NVBuilt 1997 · S/N 716N230ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 3667N230ARWyatt Aerospace LLC · Chandler, AZS/N 230N230FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6773N230NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2001 · S/N 1372N231XCMojave Jet LLC · Nolensville, TNS/N 231N232FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6838N233FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 7095N233NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2003 · S/N 2001N235FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 7272N235NVSunrise Asset Management LLC · Las Vegas, NVS/N 1130N236FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7389N23707United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28768N23708United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28769N23721United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28940N238FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7458N238NVUmb Bank Na Trustee · Salt Lake City, UTS/N 2133N239NVUmb Bank N A Trustee · Salt Lake City, UTS/N 2144N24202United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30429N24211United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28771N24212United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28772N24224United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28933N245ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 35099N245NVSunrise Asset Management LLC · Las Vegas, NVS/N 1550N246NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7664N24702United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28763N24706United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28767N24715United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28786N24729United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28945N24736United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28803N247NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7704N248NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7781N249NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7766N250NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7743N251NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7838N25201United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28958N252NJAviation Trust Company LLC Trustee · Oklahoma City, OKS/N 252
Back to AD 2000-07-27