OpenAirDocs.org
AD 2003-24-13

Registered aircraft · 7,866

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.

N110SQLand Air & Sea LLC · Concord, NCBuilt 2006 · S/N 172S10384N1117PD W Shimoda LLC · Itasca, ILBuilt 2005 · S/N 18281580N111AKKershaw Andrew H · Spring, TXBuilt 2025 · S/N 18283325N111HKSky Peace Aviation LLC · Springdale, ARBuilt 2015 · S/N 18282377N111WYN111wy LLC · Wilmington, DEBuilt 2002 · S/N T18208144N1120ZWhite Wing Air LLC · Garden Grove, CAS/N 172S10313N1122TAircraft Solutions Group LLC · Englewood, COBuilt 2019 · S/N 172S12416N1123FUrsus Air Services · Anchorage, AKBuilt 2002 · S/N 20608173N1125GBlue Knot LLC · Teguesta, FLBuilt 2023 · S/N T18209117N1127DWings Over Texas Holdings LLC · Denton, TXBuilt 2006 · S/N 172S10247N1128WChance Aviation LLC · Sugar Land, TXBuilt 2017 · S/N T20609512N1129CLanier Equipment Leasing LLC · Gainesville, GABuilt 2018 · S/N 172S12227N1129KOrange County Flight Center Inc · Santa Ana, CABuilt 2006 · S/N 172S10315N1129PBonzo Air LLC · Saint Petersburg, FLBuilt 2005 · S/N 18281584N112PFEastern Kentucky University · Richmond, KYBuilt 1998 · S/N 17280400N112PZSkymaxx Inc · Daytona Beach, FLBuilt 2005 · S/N 172S9833N112SPMinnesota Department Of Public Safety · Saint Paul, MNBuilt 2019 · S/N 18283086N112SVGb Aviation Of Alabama LLC · Millry, ALBuilt 2003 · S/N 172S9380N1132WC Flying K Aviation LLC · Savery, WYFirst renewal noticeBuilt 2006 · S/N 172S10125N1132XWest Coast Equipment Leasing LLC · Englewood, COBuilt 2006 · S/N 172S10316N11345Enviroplus Consulting Inc · Rosamond, CABuilt 2006 · S/N T20608668N1134DFma Auto Sales LLC · Greensboro, NCBuilt 2005 · S/N 18281605N11379Bas Part Sales LLC · Greeley, COBuilt 1999 · S/N 20608077N1137Y412 Jackson Site Development LLC · Oxford, MSBuilt 2005 · S/N 18281602N113AKFlight Training Aircraft LLC · Wilmington, DEBuilt 2006 · S/N 172S10182N113CPCivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N T20609735N113HPState Of Ohio · Columbus, OHBuilt 2002 · S/N 18281159N113KHTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N T20609859N113PFPremier Flight Center LLC · Hartford, CTBuilt 1998 · S/N 17280401N113SVChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9512N113TLKramer David P · Lebanon, TNBuilt 2003 · S/N T18208219N11414Van Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N T18208413N1142UCorporacion Dbm LLC · Miami, FLBuilt 2005 · S/N 18281604N1143XTj Allen Bulk Services LLC · Newport, NYBuilt 2006 · S/N T18208648N1145BKampton William Charles · Napa, CABuilt 2006 · S/N T18208649N114FBFly Appleton LLC · Appleton, WIBuilt 2005 · S/N 172S9811N114TLLa Soplaera Realty LLC · Niwot, COBuilt 2003 · S/N T18208220N114VKKennedy Virgil C DBA · San Marcos, TXBuilt 2001 · S/N 172S8695N1152ZRainier Flight Service LLC · Renton, WABuilt 2006 · S/N 172S10339N1154GPlane Nonsense Inc · Middletown, DEBuilt 2006 · S/N 172S10126N1154WAerosim Academy Inc · Sanford, FLBuilt 2007 · S/N 172S10608N1155MLagasse Michael · Newburyport, MABuilt 2006 · S/N T20608683N1155PN1155p Corp Trustee · Wilmington, DEBuilt 2003 · S/N 20608193N1157RSale Reported · Miami, FLSale reportedBuilt 1998 · S/N 17280627N1158QN1158q LLC · Palm City, FLBuilt 2006 · S/N 172S10354N1158VAtp Aircraft 7 LLC · Wilmington, DEBuilt 2006 · S/N 172S10355N1159KCavu Aero LLC · Marietta, GABuilt 2006 · S/N 172S10357N1159ZThunderfighter LLC · Englewood, COBuilt 2006 · S/N 172S10362N115BRJp Air LLC · Rockledge, FLBuilt 2016 · S/N 18282415N115CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12330
Back to AD 2003-24-13