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.

N356DHCompass Rose Aviation LLC · Derby, KSBuilt 2026 · S/N 18283356N356ESPremier Flight Center LLC · Hartford, CTBuilt 1997 · S/N 17280051N356MEGlass Cockpit Aviation-Sunvalley LLC · Hailey, IDBuilt 2000 · S/N 18280844N356SFSheehan Aviation Family Enterprises LLC · Boise, IDS/N T20608496N357BCChristopher Brian A · Panama City Beach, FLBuilt 1998 · S/N 18280242N357CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281509N357DRImsar LLC · Springville, UTBuilt 2019 · S/N T20609590N357DWFlight Training Aircraft LLC · Wilmington, DEBuilt 2005 · S/N 172S9820N357ESReeno Aviation LLC · Lewisville, NCBuilt 1997 · S/N 17280007N357HMH & M Aviation LLC · Madison, MSBuilt 2004 · S/N 18281338N357HRMartin Hein Ranch Co · Visalia, CABuilt 2012 · S/N T20609050N357KFAirmart Inc · Lexington, KYBuilt 1998 · S/N 18280189N357MEMichigan Dept Of Natural Resources · Roscommon, MIBuilt 2000 · S/N 18280854N357MGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 172S10259N357ZCowden Flying Services Inc · Ft Worth, TXS/N 18280093N35812Cielo Vista Inc · Milford, DEBuilt 1998 · S/N 18280154N358CBHurn Farm Enterprises LLC · Grand Beach, MIBuilt 2025 · S/N 18283314N358CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281510N358ESSoutheastern Veterinary Relief Services LLC · Orange Park, FLBuilt 1997 · S/N 17280008N358GMTextron Aviation Inc · Wichita, KSS/N T20609873N358MERibelin Holdings LLC · Yacolt, WABuilt 2000 · S/N 18280847N358TWTubreaux Aviation Services LLC · Shreveport, LABuilt 2004 · S/N 172S9751N359CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281535N359SPSilverhawk Aviation Academy Oregon LLC · Ontario, ORBuilt 2003 · S/N 172S9500N359TWDouble Bogey Aviation LLC · Midland, TXBuilt 2004 · S/N 18281477N35VAN27ax LLC · Tulsa, OKBuilt 2019 · S/N T20609561N35ZQZq Navigation LLC · Bellingham, WABuilt 2023 · S/N 18283244N360CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281519N360CWCentral Washington University · Ellensburg, WABuilt 1998 · S/N 17280312N360ECdw Flyers LLC · Kinnelon, NJBuilt 2022 · S/N 18283198N360ESEdb Air Inc · Wilsonville, ORBuilt 1997 · S/N 17280010N360MEB L T 360 Aviation LLC · Dalhart, TXBuilt 2000 · S/N 18280849N360SPN360sp LLC · Palm City, FLBuilt 2001 · S/N 172S8777N361CPBarr Air Patrol LLC · Mesquite, TXBuilt 2001 · S/N 172S8840N361DBLcb Leasing · Manassas, VAFirst renewal noticeBuilt 2010 · S/N 18282245N361ESGrady Paul D · Reno, NVBuilt 1997 · S/N 17280011N361GAGlidewell Aviation Inc · Parkland, FLBuilt 2003 · S/N 172S9521N361LRegistered aircraftBuilt 2004 · S/N 172S9569N361LULewis University · Romeoville, ILBuilt 2020 · S/N 172S12564N361MState Of Montana Dept Of Natural Resources · Helena, MTBuilt 2025 · S/N T20609811N361SPTextron Aviation Inc · Wichita, KSS/N T20609876N361TEBald Knoll Aviation LLC · Cliff, NMBuilt 1998 · S/N 18280162N361TKReckless Air LLC · Greenback, TNBuilt 2019 · S/N 18283085N362ESIasco Flight Training Inc · Redding, CABuilt 1997 · S/N 17280013N362KTOverstreet Investments Inc · Boonville, MOBuilt 2018 · S/N 18283043N362LULewis University · Romeoville, ILBuilt 2023 · S/N 172S12983N362MState Of Montana Dept Of Natural Resources · Helena, MTBuilt 2025 · S/N T20609812N362MEDesmond James M · Oceanside, CABuilt 2000 · S/N 18280851N362QRegistered aircraftBuilt 2018 · S/N 172S12188N362SPEastern Cincinnati Aviation Inc · Batavia, OHBuilt 2001 · S/N 172S8779
Back to AD 2003-24-13