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.

N892EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12685N893AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2026 · S/N 172S13539N893CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281863N894CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281864N894EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 172S13236N894KCFlight Training Aircraft LLC · Wilmington, DEBuilt 2008 · S/N 172S10742N894MRAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N T20608576N895AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2026 · S/N 172S13540N895PC925dt LLC · Picayune, MSBuilt 2008 · S/N T20608892N896AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2026 · S/N 172S13542N896CPCivil Air Patrol · Maxwell Afb, ALS/N 18282394N897AFAmeriflyers Of Texas Inc · Addison, TXS/N 172S13543N897CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282395N897EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12689N897LPMarcus Air LLC · Plano, TXBuilt 2001 · S/N 172S8897N897SMDomich Jeffrey E · Petaluma, CABuilt 2011 · S/N 18282309N898MXHicks Jeff D · Caldwell, IDBuilt 2006 · S/N T18208507N899AAAoa Kissimmee Inc · Kissimmee, FLBuilt 2016 · S/N 172S11767N899CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281866N899CSGilbert John · Austin, TXBuilt 2011 · S/N T20608999N899ETAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2016 · S/N T20609203N899JHMickle Aviation Inc Trustee · Wilmington, DEBuilt 2021 · S/N 18283134N899JRAb Prop Plane II LLC · Metairie, LABuilt 2021 · S/N 172S12708N899MEGv Air Inc · Medford, ORBuilt 2011 · S/N T20609036N89KDTextron Aviation Inc · Wichita, KSS/N T20609865N89LUTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13585N89PABrewer Robert Kevin · North Bend, ORBuilt 2000 · S/N T20608157N89SGalaxy Aviation LLC · Nantucket, MABuilt 2017 · S/N T20609524N89VY7ae LLC · La Habra Heights, CABuilt 2000 · S/N T20608249N8EMHaase Robert F · Vienna, VABuilt 2011 · S/N T18209042N8PRegistered aircraftBuilt 2025 · S/N T18209179N8PK8 Papa Kilo LLC · Saint Petersburg, FLBuilt 2025 · S/N T20609794N8WHGarrett Ag Equipment Ltd · Danbury, TXBuilt 2004 · S/N 18281499N9004WMustang Sally Aviation LLC · Camden, SCBuilt 2010 · S/N 172S11047N9005RBeneat John · Georgetown, TXBuilt 2010 · S/N 18282224N9008HTextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2011 · S/N 18282227N900BWWilliams Rebecca J · Alto, NMBuilt 2025 · S/N T20609789N900CAAtp Aircraft 1 LLC · Wilmington, DEBuilt 1997 · S/N 17280114N900HPKansas Highway Patrol · Topeka, KSBuilt 2012 · S/N 20608344N900KKSpears Aerial Crop Care LLC · Mamou, LABuilt 2005 · S/N T18208401N900NFPetros LLC · Bend, ORS/N T18208494N900WEWe Logistics LLC · Locust Valley, NYBuilt 2021 · S/N T20609629N9010KMitchell Richard · Voorhees, NJBuilt 2024 · S/N 18283285N901CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8326N901RMBusey Technology Company LLC · Vienna, VAS/N 18282285N901SRFalckon LLC · North Providence, RIBuilt 2019 · S/N T20609593N90227Waring Marvin Barton · Anacortes, WABuilt 2010 · S/N T20608985N9022HTurner Kent B · Addison, TXBuilt 2010 · S/N 18282254N9025FSoulant Michael B · Montgomery, TXBuilt 2010 · S/N T20608986N9027CElizabeth City State University · Elizabeth City, NCBuilt 2010 · S/N 172S11069
Back to AD 2003-24-13