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.

N571CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13251N571DTHardy Donald K · Beach, NDBuilt 2002 · S/N T18208120N571JAJa Flight Services LLC · Sugar Grove, ILBuilt 2007 · S/N 172S10549N571MCThompson Gary R · Discovery Bay, CABuilt 2001 · S/N 18281038N571NDVertol Systems Co Inc · Destin, FLBuilt 2009 · S/N 172S10853N571SPChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 172S8496N571TCPardue Troy W · Downsville, LABuilt 2006 · S/N 20608271N572BWBridgewater State University · Bridgewater, MABuilt 2003 · S/N 172S9426N572JAJ.A. Flight Services LLC · Sugar Grove, ILBuilt 2007 · S/N 172S10553N572NDAerosim Academy Inc · Sanford, FLBuilt 2009 · S/N 172S10940N572SPOld Friend Air LLC · Junction City, ORBuilt 2000 · S/N 172S8498N573KKTextron Aviation Inc · Wichita, KSS/N 18283370N573NDAir Shares LLC · Casper, WYBuilt 2009 · S/N 172S10941N574BWBridge State University · Bridgewater, MABuilt 2000 · S/N 17280948N574CACivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282121N574HFKilo Romeo LLC · Anchorage, AKBuilt 2001 · S/N T20608308N574NDSunrise Aviation Inc · Ormond Beach, FLBuilt 2009 · S/N 172S10943N575DKTextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2025 · S/N 18283291N575NDAir Shares LLC · Casper, WYBuilt 2009 · S/N 172S10954N575PPHenderson Joseph H · Greenville, SCBuilt 2008 · S/N T18208886N575SPCharlie Leasing LLC · Green Bay, WIBuilt 2000 · S/N 172S8504N575YSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2004 · S/N 172S9656N576BWBridgewater State University · North Dartmouth, MAS/N 17280494N576CACivil Air Patrol · Montgomery, ALBuilt 2008 · S/N 18282122N576DSLcb Leasing · Bristow, VABuilt 2010 · S/N 18282229N576NDAerosim Academy Inc · Sanford, FLBuilt 2009 · S/N 172S10962N576SPSo Cal Leasing LLC · El Cajon, CABuilt 2000 · S/N 172S8501N577AUBeck Patrick · Algonquin, ILBuilt 2015 · S/N 18282370N577EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13091N577FAN577fa LLC · Redondo Beach, CABuilt 2004 · S/N 172S9577N577FGRidgeline Assets LLC · Wilmington, DEBuilt 2023 · S/N 172S13079N577NDAir Shares LLC · Casper, WYBuilt 2010 · S/N 172S10986N577SPTexas State Technical College · Waco, TXBuilt 2000 · S/N 172S8503N577TZWestbank Fishing LLC · Kiln, MSBuilt 2002 · S/N 18281123N578BWBridgewater State University · Bridgewater, MABuilt 1998 · S/N 17280522N578CAChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10807N578EREmbry Riddle Aeronautical University Inc · Prescott, AZS/N 172S13094N578FGTextron Aviation Inc · Wichita, KSS/N 172S13642N578MCChristiansen Aviation LLC · Wilmington, DEBuilt 2004 · S/N 172S9578N579BWBridgewater State University · Bridgewater, MABuilt 2000 · S/N 17280944N579CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 18283101N579ER22 H20 LLC · Montgomery, TXBuilt 2005 · S/N 18281599N579TTFairmont Aviation Aircraft Transport&Leasing Coinc · Panama CityS/N T20608260N579WGTrede 2021 C172 LLC · Aurora, ORBuilt 2021 · S/N 172S12752N57CSSparkjoy Backcountry LLC · Boulder, COBuilt 2025 · S/N 18283295N57DTRegistered aircraftBuilt 2018 · S/N T20609548N57FASilver Express Co DBA · Miami, FLBuilt 1997 · S/N 17280225N57FFWingsleasing LLC · Wichita, KSBuilt 2023 · S/N 172S12927N57KVBird Nest Aviation LLC · Sheldon, IABuilt 2025 · S/N T20609808N57LBTellum Aviation Services LLC · Encinitas, CABuilt 2005 · S/N T20608569
Back to AD 2003-24-13