AD 2003-24-13

Registered aircraft · 7,870

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

N515DPBell Denise Augusta · Orlando, FLBuilt 2005 · S/N T18208430N515DSN515ds LLC · Marion, INBuilt 2000 · S/N T20608179N515KPKading Air LLC · Urbandale, IABuilt 2020 · S/N 18283113N515PRDog Is My Copilot LLC · Polson, MTBuilt 1999 · S/N T20608020N515SPFriedlander Ernest · San Francisco, CABuilt 2000 · S/N 172S8374N5160YArnett Randall C · Anchorage, AKBuilt 2002 · S/N T18208117N51637South Dakota State University · Brookings, SDS/N 172S9033N5163HLsn Air LLC · Morrison, COBuilt 2001 · S/N 172S8933N5163ZGevojanyan Gary · Burbank, CAS/N 172S9032N5164FBarr Air Patrol LLC · Mesquite, TXBuilt 2002 · S/N 18281082N5164UElias Maria · El Paso, TXS/N T18208122N5164XBlr Flyers LLC · Missoula, MTBuilt 2002 · S/N T18208123N51651Terry Robert · Billings, MTBuilt 2002 · S/N T18208124N5165MAl & Zal Corp · Gaylord, MIBuilt 2002 · S/N 17281092N5166HKeltz Brandon E · Montrose, COBuilt 2002 · S/N T18208125N5166YSchmenk Brent · Frisco, TXBuilt 2002 · S/N 18281089N5168VSky-Vu Flyers Inc · Fishers, INS/N 172S9037N5169EVenbro Holdings LLC · Brooklyn, NYBuilt 2002 · S/N 172S9038N516CLRimbeaux B C · Santa Fe, NMBuilt 2001 · S/N T20608288N516CSMccullough Construction Inc · South Jordan, UTBuilt 1998 · S/N 17280428N516DMSmall Howard · West Hartford, CTS/N 18280028N516EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12867N516LPSun City Aviation LLC · Davie, FLBuilt 1998 · S/N 18280179N516NDSunrise Aviation Inc · Ormond Beach, FLBuilt 2008 · S/N 172S10786N516RALolay Inc · Los Angeles, CABuilt 2008 · S/N T20608806N516SPOrlando Aeroclub Inc · Orlando, FLBuilt 2000 · S/N 172S8375N516TCVan Bortel Aircraft Inc · Arlington, TXBuilt 2004 · S/N T18208324N51703Stingair Inc · Wilmington, DEBuilt 2009 · S/N T20608933N51710Mrizek Andrew J · San Jose, CABuilt 2002 · S/N T20608356N5172WOcala Aviation Services Inc · Ocala, FLBuilt 2002 · S/N 172S9043N51732Imsar LLC · Springville, UTBuilt 2002 · S/N 18281088N5173VEastern Kentucky University · Richmond, KYBuilt 2002 · S/N 172S9046N5174YWingspan Aviation LLC · Manassas, VAS/N T20608935N5175PSbkr LLC · Greenville, PABuilt 2002 · S/N 18281155N5175YLutz Aviation LLC · Perkinsville, VTBuilt 2002 · S/N 172S9050N51782Ranger Lumber Corp · Springfield, MABuilt 2002 · S/N 18281096N51783Silver Eagle Aerial Inc · Warrensburg, MOBuilt 2008 · S/N T20608895N51784Winingar Thomas M · Brock, TXBuilt 2002 · S/N 18281097N51785Photos Unlimited · Rancho Cordova, CABuilt 2002 · S/N 18281098N5178SG & M Aircraft Inc · Wheat Ridge, COBuilt 2002 · S/N 17281097N5178USoutheastern Oklahoma State University · Durant, OKBuilt 2002 · S/N 17281098N5178YSoutheastern Oklahoma State University · Durant, OKS/N 17281099N5179BCorporate Flight Intl LLC · Glenwood Springs, COBuilt 2002 · S/N T18208137N517BRJ Bar Aviation LLC · Ojai, CABuilt 2020 · S/N T20609605N517MAKilo Charlie Aeronautics LLC · Baton Rouge, LABuilt 2017 · S/N 18283007N517NDSunrise Aviation Inc · Ormond Beach, FLS/N 172S10787N51800Southeastern Oklahoma State University · Durant, OKBuilt 2002 · S/N 17281101N51804Summit Aviation Inc · Belgrade, MTBuilt 2009 · S/N 172S10898N51816Barr Air Patrol LLC · Mesquite, TXBuilt 2002 · S/N 18281120N5181ASoutheastern Oklahoma State University · Durant, OKBuilt 2002 · S/N 17281102
Back to AD 2003-24-13