AD 2016-25-23

Registered aircraft · 616

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

N278GXUmb Bank Na Trustee · Salt Lake City, UTBuilt 2003 · S/N 1954N278NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2010 · S/N 4253N279NVSunrise Asset Management LLC · Las Vegas, NVS/N 5250N280NVDustland LLC · Las Vegas, NVS/N 5320N281AVAircol 14 Trust · Wilmington, DEBuilt 2010 · S/N 4281N281GXUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2830N281NVDustland LLC · Las Vegas, NVS/N 5381N282GXUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2851N282NVSunrise Asset Management LLC · Las Vegas, NVS/N 2875N283NVSunrise Asset Management LLC · Las Vegas, NVS/N 2920N284AVAircol 16 · Wilmington, DEBuilt 2010 · S/N 4284N284NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2012 · S/N 5045N285NVAllegiant Air LLC · Las Vegas, NVBuilt 2012 · S/N 5067N286NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2010 · S/N 4447N287NVSunrise 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 4574N290NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2004 · S/N 2191N291GXGlobal Crossing Airlines Inc · Miami, FLBuilt 2007 · S/N 3349N291NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2004 · S/N 2206N292NVBank Of Utah Trustee · Salt Lake City, UTS/N 4891N293NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4913N294NVBank Of Utah Trustee · Salt Lake City, UTS/N 4941N295NVBank Of Utah Trustee · Salt Lake City, UTS/N 4942N296NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 2674N297NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 2778N298NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 2800N299NVAllegiant Air LLC · Las Vegas, NVBuilt 2011 · S/N 4870N3014RAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5842N345AVAircol 20 · Wilmington, DEBuilt 2010 · S/N 4345N353ASAersale Inc · Coral Gables, FLS/N 553N357DCAwas 3896 Trust · Wilmington, DES/N 3896N3618FPharmair Corp · Miami, FLBuilt 2006 · S/N 2748N380ACUmb Bank Na Trustee · Salt Lake City, UTS/N 3383N397ACTvpx Trust Co LLC Trustee · North Salt Lake, UTS/N 2982N398AVAircol 6 Statutory Trust · Wilmington, DEBuilt 2009 · S/N 3988N4005XAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5753N401AVAircol 8 · Wilmington, DEBuilt 2009 · S/N 4001N401UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 435N402UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 439N4032TAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6644N404UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 450N406UAUnited Airlines Inc · Chicago, ILBuilt 1994 · S/N 454N411AEBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 4411N411AVAircol 9 · Wilmington, DES/N 4011N416AVAircol 19 · Wilmington, DEBuilt 2009 · S/N 4167N422AVUmb Bank N A Trustee · Salt Lake City, UTBuilt 2010 · S/N 4200N426AVAircol 10 · Wilmington, DEBuilt 2009 · S/N 4026N426UAUnited Airlines Inc · Chicago, ILBuilt 1995 · S/N 510
Back to AD 2016-25-23