AD 2000-12-01

Registered aircraft · 1,270

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-12-01')
    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-12-01')
  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.

N265WNSouthwest Airlines Co · Dallas, TXBuilt 2007 · S/N 32522N266WNSouthwest Airlines Co · Dallas, TXBuilt 2007 · S/N 32523N267WNSouthwest Airlines Co · Dallas, TXBuilt 2007 · S/N 32525N268WNSouthwest Airlines Co · Dallas, TXBuilt 2007 · S/N 32524N269WNSouthwest Airlines Co · Dallas, TXBuilt 2007 · S/N 32526N271NVAllegiant Air LLC · Las Vegas, NVBuilt 2006 · S/N 2932N27205United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30577N27213United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28773N27239United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28951N27246United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28956N272NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2007 · S/N 2995N272WNSouthwest Airlines Co · Dallas, TXBuilt 2007 · S/N 32527N273NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2007 · S/N 3076N273RHDepartment Of The Air Force (Usaf) · Hill Afb, UTBuilt 2003 · S/N 29890N273WNSouthwest Airlines Co · Dallas, TXBuilt 2007 · S/N 32528N27421United Airlines Inc · Chicago, ILBuilt 2008 · S/N 37094N274NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2007 · S/N 3079N274WNSouthwest Airlines Co · Dallas, TXBuilt 2007 · S/N 32529N275WNSouthwest Airlines Co · Dallas, TXBuilt 2007 · S/N 36153N276GXFalcon Msn 2695 Trust · Wilmington, DEBuilt 2006 · S/N 2695N276WNSouthwest Airlines Co · Dallas, TXBuilt 2007 · S/N 32530N27722United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28789N27724United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28791N27733United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28800N27734United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28949N277EAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2001 · S/N 32359N277NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2007 · S/N 3205N277WNSouthwest Airlines Co · Dallas, TXBuilt 2007 · S/N 32531N278GXUmb Bank Na Trustee · Salt Lake City, UTBuilt 2003 · S/N 1954N278NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2010 · S/N 4253N278WNSouthwest Airlines Co · Dallas, TXBuilt 2007 · S/N 36441N279WNSouthwest Airlines Co · Dallas, TXBuilt 2007 · S/N 32532N280WNSouthwest Airlines Co · Dallas, TXBuilt 2007 · S/N 32533N281AVAircol 14 Trust · Wilmington, DEBuilt 2010 · S/N 4281N281GXUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2830N281WNSouthwest Airlines Co · Dallas, TXBuilt 2007 · S/N 36528N28252U S Marshall Serv Justice & Alien Trans Sys(Jpats) · Oklahoma City, OKBuilt 2002 · S/N 28252N282AAAerownership North American Services Inc Trustee · Dover, DES/N 26282N282ADAar Aircraft & Engine Sales & Leasing Inc · Wood Dale, ILBuilt 2000 · S/N 28232N282GXUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2851N282WNSouthwest Airlines Co · Dallas, TXBuilt 2007 · S/N 32534N283WNSouthwest Airlines Co · Dallas, TXBuilt 2007 · S/N 36610N284AVAircol 16 · Wilmington, DEBuilt 2010 · S/N 4284N284WNSouthwest Airlines Co · Dallas, TXBuilt 2007 · S/N 32535N285GXUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 1936N285WNSouthwest Airlines Co · Dallas, TXBuilt 2007 · S/N 32536N285XAVent Airlines Inc · Dover, DEBuilt 1993 · S/N 26285N286WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 32471N287WNSouthwest Airlines Co · Dallas, TXBuilt 2007 · S/N 32537N288WNSouthwest Airlines Co · Dallas, TXBuilt 2007 · S/N 36611
Back to AD 2000-12-01