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.

N115FJFargo Jet Center LLC · Fargo, NDBuilt 2008 · S/N 172S10784N115KSKent State University · Stow, OHBuilt 1999 · S/N 17280819N115LWCrest Airpark Inc · Kent, WABuilt 2005 · S/N 172S9868N115PFHigh Tech Metals Inc · Harrisburg, PABuilt 1998 · S/N 18280224N115SV115sv LLC · Lamar, MOBuilt 2004 · S/N 172S9663N115TAAtp Aircraft 7 LLC · Wilmington, DEBuilt 2018 · S/N 172S12145N11614Lewis University · Romeoville, ILBuilt 2006 · S/N 172S10360N1162UHamel Raymond F Jr · Wellesley, MABuilt 2007 · S/N 18281984N1164JTyson Bradley · Sherrills Ford, NCBuilt 2023 · S/N 18283240N1165YUgly Johns Aircraft LLC · Afton, OKBuilt 2006 · S/N T20608686N1166WFlight Operations Aircraft LLC · Wilmington, DEBuilt 2006 · S/N 172S10363N11682Jahawk Leasing LLC · Sugar Grove, ILBuilt 2006 · S/N 172S10365N116CPCivil Air Patrol · Maxwell Afb, ALBuilt 2017 · S/N 18283012N116DRegistration Pending · Reese, MIRegistration pendingBuilt 2022 · S/N 18283203N116JEAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12167N116KSKent State University · Stow, OHBuilt 1999 · S/N 17280820N116MVWing And Rotor Transportation Holdings LLC · Morristown, NJBuilt 2002 · S/N T20608357N116SLXcel Aviation LLC · Eagle, IDBuilt 2003 · S/N 18281242N116SMArchie Aero LLC · Beaverton, ORBuilt 2005 · S/N T18208426N116VGBruns Phillip T · Shiro, TXBuilt 1998 · S/N 18280346N116WBDunch David J Trustee · Poland, OHBuilt 1998 · S/N 18280170N116WETextron Aviation Inc · Wichita, KSS/N 172S13611N116ZXVranjes Peter · Johnstown, COBuilt 1997 · S/N 18280042N1171JNational Test Pilot School · Mojave, CABuilt 2007 · S/N 18281985N1173XWnc Aviation LLC · Arden, NCBuilt 2006 · S/N 172S10379N1174CGeorgia Forestry Commission · Macon, GABuilt 2007 · S/N 18281905N1174HGeremia Frank · Rocklin, CABuilt 2002 · S/N 18281145N1175KOkmok Aviation LLC · Anchorage, AKBuilt 2007 · S/N T18208690N1176AJar Air LLC · Incline Village, NVBuilt 2007 · S/N T18208673N1176RBas Part Sales LLC · Greeley, COBuilt 2005 · S/N 18281688N1176TP C O Leasing Inc · Dobbin, TXBuilt 2005 · S/N 18281587N117APAutumn Horizons LLC · Redwood City, CABuilt 2009 · S/N T18208915N117BDHall Alan Ray · Willow Park, TXBuilt 2017 · S/N 18283024N117KSKent State University · Stow, OHBuilt 1999 · S/N 17280821N117SDLong Joseph F · Carroll, OHS/N 18280926N117SVFlight Operations Aircraft LLC · Wilmington, DEBuilt 2005 · S/N 172S10073N11802N11802 LLC · Bradenton, FLBuilt 2007 · S/N 172S10463N1180NWinkelmann Aerospace LLC · Malabar, FLBuilt 2007 · S/N 172S10461N1182DDura-Built Of Delaware LLC · Lewes, DEBuilt 2025 · S/N T18209183N1183MHess Darren Michael · Wenatchee, WABuilt 2007 · S/N 18281911N1184NErickson Holdings LLC · Atlanta, GABuilt 2007 · S/N T18208696N1186TMap Aviation LLC · Coral Gables, FLBuilt 2007 · S/N 18281879N1187TBluenose LLC · Queen Creek, AZBuilt 2007 · S/N T18208670N1188LAyah Investments LLC · Kent, WABuilt 2006 · S/N 172S10370N1189WVan Bortel Aircraft Inc · Arlington, TXBuilt 2007 · S/N T18208699N1189YRegistered aircraftBuilt 2007 · S/N T18208700N118EGSpring Hill Aviation LLC · Cincinnati, OHBuilt 2018 · S/N T20609542N118ETL & W Leasing LLC · Smyrna, TNBuilt 1997 · S/N 17280019N118FSTfs Air LLC · Loveland, COBuilt 2003 · S/N 17281198N118KSKent State University · Stow, OHBuilt 1999 · S/N 17280822
Back to AD 2003-24-13