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.

N540DCSkylane Aviation LLC · Hazelwood, MOBuilt 2000 · S/N 18280842N540EREmbry-Riddle Aeronautical University Inc · Prescott, AZS/N 172S13308N540KMKreuter Engineering · New Paris, INBuilt 2000 · S/N 20608135N540KSKent State University · Stow, OHBuilt 2016 · S/N 172S11672N540NDAerosim Academy Inc · Sanford, FLBuilt 2010 · S/N 172S10984N541ESouthern Illinois University · Murphysboro, ILBuilt 2011 · S/N 17281593N541EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2025 · S/N 172S13311N541KSKent State University · Stow, OHBuilt 2016 · S/N 172S11671N541LCBarbers Point Flight School LLC · Kapolei, HIBuilt 2022 · S/N 172S12860N541WSFox Leasing Group LLC · Hollywood, FLBuilt 2003 · S/N 172S9340N5421SAmeriflyers Of Texas Inc · Addison, TXBuilt 1999 · S/N 172S8080N5424CBello Aviation LLC · Naples, FLFirst renewal noticeS/N T20608494N542CPCivil Air Patrol · Maxwell Afb, ALBuilt 2011 · S/N T18209033N542ECWang Warner Weihsu · Vienna, WVBuilt 2005 · S/N 18281691N542EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12872N542KSKent State University · Stow, OHBuilt 2025 · S/N 172S13367N542THNorthern Cowboy Holdings LLC · Prior Lake, MNBuilt 2019 · S/N 172S12253N543EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2025 · S/N 172S13314N543MCJoe Morten & Son Inc · S Sioux City, NEBuilt 1999 · S/N 18280548N543NDN543nd LLC · Manassas, VABuilt 2010 · S/N 172S10985N543THRidgeline Assets LLC · Wilmington, DEBuilt 2019 · S/N 172S12255N544EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2025 · S/N 172S13318N544KGDawson Aircraft Inc · Clinton, ARS/N T18209006N544KSKent State University · Stow, OHBuilt 2026 · S/N 172S13510N544SPSilverhawk Aviation Academy LLC · Caldwell, IDS/N 172S8399N545FCatching Freedom LLC · Bozeman, MTS/N 172S12357N545KSKent State University · Stow, OHBuilt 2026 · S/N 172S13512N545MCBarnes Robert Edward Jr · Mason, OHBuilt 1999 · S/N 18280530N545NDChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10857N545QCatching Freedom LLC · Bozeman, MTS/N 172S12371N545UCatching Freedom LLC · Bozeman, MTS/N 172S12311N545YCatching Freedom LLC · Bozeman, MTS/N 172S12327N545ZDornoch Services LLC · Dover, DEBuilt 2008 · S/N 172S10770N5467CSteamboat Springs Flying Club Inc · Steamboat Springs, COBuilt 1998 · S/N 18280230N546ASouthern Illinois University · Murphysboro, ILBuilt 2011 · S/N 17281594N546EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2026 · S/N 172S13538N546KWard Mark E · Brookfield, WIBuilt 2001 · S/N 18281013N546MCLeaseair LLC · Wilmington, DEBuilt 2000 · S/N 172S8376N546NDSpartan Education LLC · Tulsa, OKBuilt 2010 · S/N 172S11045N547CSForever Dream LLC · Wilmington, DEBuilt 2019 · S/N 18283084N547ESouthern Illinois University · Murphysboro, ILBuilt 2011 · S/N 17281596N547EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2026 · S/N 172S13541N547MChapman Joseph Quinn · Seminole, FLBuilt 2022 · S/N 18283167N547MCS & J Ventures Inc · Wilmington, DEBuilt 2000 · S/N 18280692N547NDSpartan Education LLC · Tulsa, OKBuilt 2010 · S/N 172S11049N548ASouthern Illinois University · Murphysboro, ILBuilt 2011 · S/N 17281597N548EPGulf Coast Aviation LLC · New Orleans, LABuilt 2007 · S/N 172S10530N548EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2026 · S/N 172S13544N548NDAerosim Academy Inc · Sanford, FLBuilt 2010 · S/N 172S11050N548RGosnell Christopher Carter · Magnolia, ARBuilt 2005 · S/N 18281576
Back to AD 2003-24-13