AD 2012-02-03

Registered aircraft · 1,019

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

N247NVSunrise 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 28958N252NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7868N253ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 3690N253NVAllegiant Air LLC · Las Vegas, NVBuilt 2017 · S/N 7900N254NVAllegiant Air LLC · Las Vegas, NVBuilt 2017 · S/N 7913N255NVAllegiant Air LLC · Las Vegas, NVBuilt 2017 · S/N 7989N256NVSunrise Asset Managment LLC · Las Vegas, NVBuilt 2018 · S/N 8220N257NVAllegiant Air LLC · Las Vegas, NVBuilt 2018 · S/N 8329N259NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4057N260NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4104N261NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4115N26208United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30580N26210United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28770N26215United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28775N26226United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28935N26232United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28942N262NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4122N27205United 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 2995N276NVAllegiant Air LLC · Las Vegas, NVBuilt 2019 · S/N 8671N27722United 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 28949N278NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2010 · S/N 4253N281AVAircol 14 Trust · Wilmington, DEBuilt 2010 · S/N 4281N284AVAircol 16 · Wilmington, DEBuilt 2010 · S/N 4284N284NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2012 · S/N 5045N285GXUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 1936N285NVAllegiant Air LLC · Las Vegas, NVBuilt 2012 · S/N 5067N286NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2010 · S/N 4447N286WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 32471N287NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2010 · S/N 4508N288NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2010 · S/N 4537N289GXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 3016N289NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2011 · S/N 4574N291GXGlobal Crossing Airlines Inc · Miami, FLBuilt 2007 · S/N 3349N291NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2004 · S/N 2206N293NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4913N29717United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28936N299NVAllegiant Air LLC · Las Vegas, NVBuilt 2011 · S/N 4870N300EKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1997 · S/N 27716
Back to AD 2012-02-03