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.

N26149Textron Aviation Inc · Wichita, KSS/N 172S13643N26150Textron Aviation Inc · Wichita, KSS/N 172S13646N26153Textron Aviation Inc · Wichita, KSS/N 172S13649N261AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281186N261CACivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282136N261CPCivil Air Patrol · Maxwell Afb, ALBuilt 2011 · S/N T20609025N261EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13501N261JBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2020 · S/N 172S12575N261SCIndia Aviation LLC · Oregon City, ORBuilt 2025 · S/N 172S13439N2621ZWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1998 · S/N 17280559N2625CL&W Leasing LLC · Murfreesboro, TNBuilt 1998 · S/N 17280436N26264Edb Air Inc · Wilsonville, ORBuilt 1998 · S/N 18280265N2626ZJf Aviation LLC · Minot, NDBuilt 2007 · S/N T20608761N262AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281187N262CLGiga Energy Inc · Buna, TXBuilt 2004 · S/N 18281497N262CPCivil Air Patrol · Maxwell Afb, ALBuilt 2017 · S/N 18283017N262MTBurns Mark R · Streetsboro, OHBuilt 2016 · S/N 18282449N262SHTextron Aviation Inc · Wichita, KSS/N T20609860N2630UShaka Skies LLC · Kihei, HIBuilt 1998 · S/N 17280568N2632YAtp Aircraft 4 LLC · Wilmington, DEBuilt 1998 · S/N 17280570N2634EAzul Services LLC · Bozeman, MTBuilt 1998 · S/N 17280572N26379Wings Over Texas Holdings LLC · Denton, TXBuilt 1998 · S/N 17280573N2638ULindsey Aviation Services · Haslet, TXBuilt 1999 · S/N T20608061N263EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13503N263MECommercial Aerial Images Inc · Costa Mesa, CABuilt 2000 · S/N T20608199N263RCRichland County Sheriffs Department · Columbia, SCBuilt 2013 · S/N T20609107N263SFAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 172S13406N26481Accessible Aviation Inc · Tupelo, MSBuilt 1998 · S/N 17280578N26499Advanced Aviation Group LLC · Frederick, MDBuilt 1999 · S/N 17280730N2649JN2649j LLC · Palm City, FLBuilt 1998 · S/N 17280599N264EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13504N264ME618 Aviation LLC · Kosse, TXBuilt 2000 · S/N T20608200N264SFAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 172S13407N26502Bugsmasher Aviation LLC · Benton, KSBuilt 1998 · S/N 17280600N26504Vista Aviation Inc · Pacoima, CABuilt 1998 · S/N 17280601N26509Bell Air LLC · Belleville, KSBuilt 1998 · S/N T2068004N2650VSampson Merle A · Inver Grove Height, MNBuilt 1998 · S/N T2068005N2651RAtls Aviation LLC · Stuart, FLBuilt 1998 · S/N 17280542N2656GAtp Aircraft 4 LLC · Wilmington, DEBuilt 1998 · S/N 17280569N265MESunset Leasing Inc · Sarasota, FLBuilt 2000 · S/N 18280771N265SFAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 172S13409N26613Coomes Thomas R · Hollis, OKBuilt 1998 · S/N 18280326N26616Sea Wing LLC · Camarillo, CABuilt 1998 · S/N 18280329N2662ARogers Construction Services Inc · Boca Raton, FLBuilt 1998 · S/N 18280331N2662BGjl Aviation LLC · Fort Worth, TXBuilt 1998 · S/N 18280332N2662FGarmin International Inc · Olathe, KSBuilt 1998 · S/N 18280337N2662ZBidcal Inc · Chico, CABuilt 1998 · S/N 18280338N26630Iasco Flight Training Inc · Redding, CABuilt 1998 · S/N 17280565N2663XAvolant Aviation LLC · Mooresville, NCBuilt 1999 · S/N 17280643N2664UHill Flying Club Inc · St George, UTBuilt 1998 · S/N 18280298
Back to AD 2003-24-13