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.

N656TCPremier Legacy Aviation LLC · Lewes, DEBuilt 2006 · S/N T20608656N65729Nevrdul LLC · Cambridge, MDBuilt 2005 · S/N 172S9791N65738Mc Collom Perry C · Saint Louis, MOBuilt 2004 · S/N 172S9746N65745Mustang Sally Aviation LLC · Camden, SCBuilt 2004 · S/N 172S9748N65790Horan Peter · North Easton, MABuilt 2005 · S/N 172S9787N65795Bank Of Utah Trustee · Salt Lake City, UTS/N 172S9977N657CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281657N657EREmbry-Riddle Aeronautical University · Prescott, AZBuilt 2020 · S/N 172S12455N657SPChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 172S8062N657TPZma LLC · North Little Rock, ARBuilt 2010 · S/N 18282253N65805Wilkerson William E · Crewe, VABuilt 2004 · S/N T18208346N65841Just Plane Stuff Inc · Jackson, MSBuilt 2004 · S/N 172S9763N65853Morando Donald W · Myrtle Beach, SCBuilt 2004 · S/N 18281490N65860Edb Air Inc · Wilsonville, ORBuilt 2004 · S/N 18281491N65862Top Flight Aviation Inc · Corona, CABuilt 2004 · S/N 18281493N658AKWright David · Bellaire, TXBuilt 2010 · S/N T18209007N658CPArizona Air Salvage · Phoenix, AZBuilt 2005 · S/N 18281658N658EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2020 · S/N 172S12539N658MACantele Joseph D · Hickory Hills, ILBuilt 2000 · S/N 172S8529N658PWWheels Up Aviation LLC · Cochran, GABuilt 2008 · S/N 18282098N658XLMertz George H III · Reading, PABuilt 1997 · S/N 17280096N65903N65903 LLC · Union Gap, WABuilt 2004 · S/N 18281501N65904Electra Aviation LLC · Wilmington, DEBuilt 2004 · S/N 18281502N65908Sanders Thomas W · Overgaard, AZBuilt 2004 · S/N T18208347N65912Lima Alfa LLC · Whitefish, MTBuilt 2004 · S/N T18208348N65920Hellroaring Technologies Inc · Polson, MTBuilt 2004 · S/N T18208350N65926Pc Aviation LLC · Kanarraville, UTBuilt 2004 · S/N T18208353N65927Garmin International Inc · Olathe, KSBuilt 2004 · S/N T18208354N65932Techflitewest LLC · Brookville, OHBuilt 2004 · S/N T18208356N65937Berendschot Leonardus · Huntsville, TXBuilt 2004 · S/N 18281492N65956Ameriflyers Of Texas Inc · Addison, TXS/N 172S9829N65957Skybourne LLC · Stuart, VABuilt 2004 · S/N 18281484N65971Georgalos Aircraft LLC · Eagle Point, ORBuilt 2004 · S/N T18208340N65988Arkansas Industrial Manufacturing LLC · Wilmington, DEBuilt 2005 · S/N 18281513N65991Crysler Douglas Michael · Rockford, MIBuilt 2005 · S/N 18281514N65995Phoenix Flyers Inc · Mesa, AZBuilt 2005 · S/N 18281515N659BDHeritage Aviation Management Ltd · Conroe, TXBuilt 2020 · S/N T20609609N659EREmbry-Riddle Aeronautical University Inc · Prescott, AZS/N 172S12541N659SPChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 172S8064N659TCYokin Around LLC · Ketchum, IDBuilt 2008 · S/N T20608860N65BLWhite Craig S · Troy, OHBuilt 2001 · S/N 18281069N65EHTextron Aviation Inc · Wichita, KSS/N T18209213N65FDBarnstormer Leasing LLC · Murfreesboro, TNBuilt 2017 · S/N 18283010N65HFHorizon Flight Center LLC · Chesapeake, VABuilt 2024 · S/N 172S13138N65KCBarr Air Patrol LLC · Mesquite, TXBuilt 2001 · S/N 18281015N65TJHigh Wing 182t LLC · Helena, MTBuilt 2025 · S/N T18209169N66005Slp III 1 LLC · Columbia, MOBuilt 2005 · S/N T18208359N66010Crane William Jr · Somerville, ALBuilt 2005 · S/N 172S9771N66025Suburban Air Corp · Castro Valley, CAS/N 172S9777N66029Wpf Air LLC · Fort Myers, FLBuilt 2005 · S/N T18208365
Back to AD 2003-24-13