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.

N5181BSoutheastern Oklahoma State University · Durant, OKBuilt 2002 · S/N 17281103N5181EMustang Sally Aviation LLC · Camden, SCBuilt 2002 · S/N 172S9058N5181VWarden Stephen M · Sugar Land, TXBuilt 2002 · S/N 18281102N51824US Department Of Homeland Security · Washington, DCBuilt 2003 · S/N T20608390N51827B D Aviation LLC · Sauget, ILBuilt 2002 · S/N 17281108N5182AIasco Flight Training Inc · Redding, CABuilt 2002 · S/N 17281106N5182RHalf Wagon Innovations LLC · Cresson, TXBuilt 2000 · S/N 18280707N51847Rippe Ryan · Fairbury, NEBuilt 2002 · S/N T20608363N51849O'Ryan Air LLC · Wichita, KSBuilt 2002 · S/N T20608364N5184GSicking Ryan · Gainesville, TXBuilt 2002 · S/N 18281104N5184PBarr Air Patrol LLC · Mesquite, TXBuilt 2002 · S/N 18281105N5185UMoyer Aviation Inc · Tobyhanna, PABuilt 2002 · S/N 172S9059N5185YPiedmont Flight Inc · Winston Salem, NCBuilt 2002 · S/N 172S9060N5187AHada Benjamin · Andrews, TXBuilt 2002 · S/N 18281111N5188BRegier Tom · Dinuba, CABuilt 2002 · S/N T18208141N5188LMascari Nicholas M · Mundelein, ILBuilt 2002 · S/N 18281112N5188TCohen Edward R · Loomis, CABuilt 2002 · S/N 18281113N5189DRiverside Pipe LLC · Farmington, NMBuilt 2002 · S/N T18208142N518CRM & A Aircraft LLC · Wilmington, DEBuilt 1998 · S/N 18280281N518SPGreater Flint Pilots Associations Inc · Flushing, MIBuilt 2000 · S/N 172S8379N5190AArias Antonio · Lakeway, TXS/N T18208143N5190JAoa Kissimmee Inc · Kissimmee, FLBuilt 2002 · S/N 172S9151N5190RIasco Flight Training Inc · Redding, CABuilt 2002 · S/N 17281111N5191FArapahoe Aero Aircraft Sales LLC · Englewood, COBuilt 2002 · S/N 18281115N5193MTar Pit Investments LLC · Austin, TXBuilt 2002 · S/N T18208146N5194NAndros Aviation LLC · Santa Margarita, CABuilt 2002 · S/N 20608177N5195UChi Aerospace Inc · Portsmouth, NHS/N T18208941N5195YUrbana Aircraft LLC · Urbana, MDBuilt 2002 · S/N 172S9089N51964Shorebird LLC · West Chester, PABuilt 2009 · S/N T20608936N5196GOlasz Jonathan S · West Barnstable, MABuilt 2002 · S/N 172S9092N5196KMiller Andrew Howard · Granbury, TXBuilt 2009 · S/N T18208944N5196PEsbenshade Wilmer R · New Holland, PABuilt 2002 · S/N 18281125N5197GDirect-To LLC · Cedar Park, TXS/N T20608940N5197TUw Flying Club Inc · Sun Prairie, WIBuilt 2002 · S/N 172S9131N5198GConaway David L · Las Vegas, NVBuilt 2002 · S/N T18208150N5198JMichigan Dept Of Natural Resources · Roscommon, MIBuilt 2009 · S/N 18282147N5198QValiair Lc Trustee · Casper, WYBuilt 2010 · S/N 18282210N5198TBlack Dog Aviation LLC · Troy, MIBuilt 2002 · S/N 20608178N5199BFly172s LLC · Peoria, AZBuilt 2002 · S/N 172S9093N5199JG&M Aircraft Inc · Wheat Ridge, COBuilt 2002 · S/N 172S9097N519AMRegistration Pending · Manheim, PARegistration pendingBuilt 2023 · S/N 18283225N519ERStick & Rudder Club Inc · Waukegan, ILBuilt 2002 · S/N 172S9107N519NDChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10810N51CHEcho Acquisitions LLC · Dover, DES/N 18280112N51HFSan Mateo County Sheriff'S Office · Redwood City, CABuilt 2012 · S/N 20608347N51UDAlf Ix LLC · Chicago, ILBuilt 2017 · S/N 172S12088N5200ABarr Air Patrol LLC · Mesquite, TXBuilt 2002 · S/N 18281128N52034Arq Aviation LLC · Wilmington, NCBuilt 2002 · S/N 172S9100N5204NN5204n LLC · Palm City, FLBuilt 2002 · S/N 172S9102N52057Redstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 2002 · S/N 17281116
Back to AD 2003-24-13