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.

N2241VEdwards John D · Yardley, PABuilt 2007 · S/N 172S10481N2241XMandes George · Homer, AKS/N T20608736N2242CCac Of Ar LLC · White Hall, ARBuilt 2000 · S/N 18280779N2244WTextron Aviation Inc · Wichita, KSBuilt 2007 · S/N T18208714N22467Mustang Sally Aviation LLC · Camden, SCBuilt 2007 · S/N 172S10487N2247TYellow Jacket Flying Club Inc · Atlanta, GABuilt 2007 · S/N 18281934N224CSAtb Special Purpose LLC · Laredo, TXBuilt 2016 · S/N T20609221N224EMFsm Aviation LLC · Edmond, OKS/N 18281350N224MAAir Future Airways Corp · Miami, FLBuilt 2000 · S/N 172S8613N224TFCdtskyview LLC · Medford, ORBuilt 2008 · S/N T18208906N224VSM&G Aircraft Management LLC · Englewood, COBuilt 2022 · S/N 172S12893N2252ZBerman Rayanne S · Hatfield, PABuilt 2006 · S/N T18208490N2254URaritan Valley Flying School · Princeton, NJBuilt 1999 · S/N 17280684N2255HWinged Vision Inc · Gaithersburg, MDBuilt 2007 · S/N T20608738N2255MCooper Gary D · Fayetteville, ARBuilt 2007 · S/N T20608739N2258ZPope Charles A · Sandy Hook, MSBuilt 2007 · S/N 18281937N22593State Of Nc · Raleigh, NCS/N 18281938N225EAArellano Erick · Brownsville, TXBuilt 2024 · S/N 18283273N225EBEbac LLC · Wichita, KSBuilt 2025 · S/N T20609819N225FAMcclure Nicholas W · Midland, TXBuilt 2003 · S/N 18281252N225METvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N T20608190N225RARochester Air Center LLC · Canandaigua, NYBuilt 2005 · S/N 172S9803N225SFAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 172S13441N225TFTop Flight Aviation Inc · Corona, CABuilt 2004 · S/N 172S9755N225VPAerotrust Services Corp Trustee · Wilmington, DEBuilt 2025 · S/N T20609833N225WCBozeman Skyhawk LLC · Bozeman, MTBuilt 2006 · S/N 172S10272N225WSSpartan Education LLC · Tulsa, OKBuilt 2005 · S/N 172S9800N2260EJm-Bac Holdings LLC · Arcadia, OKBuilt 2007 · S/N 18281939N2265WStratus Aviation LLC · Fergus Falls, MNS/N T18208720N22669R S Bowen Enterprises LLC · Flowery Branch, GABuilt 2007 · S/N 18281942N2266KFelix Ken Allen · Rye, COBuilt 2007 · S/N T18208721N2268AAerofeather Aviation Inc · Suffolk, VABuilt 1998 · S/N 17280686N2268BNitro Aviation LLC · Englewood, COBuilt 2005 · S/N T20608574N2269BAh1f Associates LLC · Clifton Park, NYS/N T20608742N226AVN286sa LLC · Manassas, VABuilt 2007 · S/N 172S10651N226CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282345N226EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13513N226GHTextron Aviation Inc · Wichita, KSS/N T20609870N226JWThompson Edward Allen · Sunset Beach, NCBuilt 2004 · S/N T18208330N226LSilver Creek Aviation Services · Fort Worth, TXBuilt 2004 · S/N 20608226N226MELawson Tim · San Clemente, CABuilt 2000 · S/N T20608191N226SMSarahmaura Aviation Inc · Wayne, NJS/N 18281153N226TMWadeberg LLC · San Francisco, CABuilt 2007 · S/N T18208796N2270GNorris Edgar L Jr · Charlotte, NCBuilt 2007 · S/N T18208726N2270QSure Aviation LLC · North East, MDBuilt 2007 · S/N T18208728N2272CBartow Municipal Airport Development Authority · Bartow, FLBuilt 2005 · S/N 172S9954N2272DLucky Marmot Aviation LLC · Traverse City, MIBuilt 2007 · S/N T20608743N2272PSchmitz William M · Napa, CABuilt 2007 · S/N T20608745N2272VGryffin Ventures LLC · Jupiter, FLBuilt 2000 · S/N 17280839N2274BAon-Adharc Aircraft Leasing LLC · Sellersburg, INBuilt 1999 · S/N 17280689
Back to AD 2003-24-13