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.

N1SLHotel Kilo Aviation LLC · Anchorage, AKBuilt 1999 · S/N T20608051N2000CTextron Aviation Inc · Wichita, KSS/N 172S13601N2002FTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 18283349N2004UEpic Aviation Inc · Denison, TXBuilt 2025 · S/N 172S13449N20067Epic Aviation Inc · Denison, TXBuilt 2025 · S/N 172S13448N2006PKnox Timothy A · Tulsa, OKBuilt 2005 · S/N 18281684N2007VCompass Rose Aviation LLC · Derby, KSBuilt 2026 · S/N 18283338N2007XEpic Aviation Inc · Denison, TXBuilt 2025 · S/N 172S13447N20126Papa Whiskey Enterprises LLC · Merrimack, NHBuilt 2001 · S/N 18280951N2012FEpic Aviation Inc · Denison, TXBuilt 2025 · S/N 172S13452N2012YLake Robert P · Fruita, COBuilt 2006 · S/N 18281770N20135Africair Inc · Miami, FLBuilt 2025 · S/N T20609825N2013WEpic Aviation Inc · Denison, TXBuilt 2025 · S/N 172S13451N2014SGaige Gerald · Gassville, ARBuilt 2006 · S/N 18281772N2016FEpic Aviation Inc · Denison, TXBuilt 2025 · S/N 172S13450N2017CHigher Flyer LLC · Northport, ALBuilt 1999 · S/N 18280463N201ELAa-Aero LLC · Lewes, DEBuilt 2026 · S/N 172S13545N201FSRegistration Pending · Peoria, AZRegistration pendingBuilt 2000 · S/N 172S8453N201KSKing Aircraft LLC · San Diego, CABuilt 2019 · S/N 172S12251N201THG & M Aircraft Inc · Wheat Ridge, COBuilt 1997 · S/N 17280201N201TWTom Wood Aviation Inc · Fishers, INBuilt 2025 · S/N 172S13294N201WLWingsleasing LLC · Wichita, KSBuilt 2026 · S/N 172S13570N2020CN2020c LLC · Abilene, TXBuilt 2005 · S/N 18281700N2027PHake Equipment Leasing LLC · Farmington Hills, MIBuilt 2005 · S/N 18281724N2028BWeber Richard · Mountain View, CAFirst renewal noticeS/N 18280952N202AJEnterprise Aviation Services LLC · Albuquerque, NMBuilt 2007 · S/N 172S10450N202BWCoastal Defense Inc · Mill Hall, PABuilt 2000 · S/N 20608088N202CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12334N202MCBeemer Companies · Fairmont, MNBuilt 2011 · S/N T20609030N202SPColorado State Patrol · Denver, COBuilt 2011 · S/N T18209049N2030CSky Bear LLC · Lakewood, CABuilt 2005 · S/N 172S9941N203CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12501N203DBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2024 · S/N T18209130N203KSMichael Lichtman Inc · Oceanside, CAFirst renewal noticeBuilt 2001 · S/N 172S8856N203SPColorado State Patrol · Denver, COBuilt 2011 · S/N T18209040N20401Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12519N2040HAbc Plane LLC · Freeport, TXS/N 18281639N20412Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12520N20416Carl L Mccallister Inc · Wilmington, DEBuilt 2005 · S/N 18281642N20417Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12522N20422Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12523N20425Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12524N2044YPsalm 19:1 Aviation LLC · Annapolis, MDBuilt 2005 · S/N 18281643N2046KChristiansen Aviation LLC · Wilmington, DEBuilt 2017 · S/N 172S12092N2047CPropp & Wings LLC · Missoula, MTBuilt 2005 · S/N T18208445N20489Lone Oak Properties LLC · Flagstaff, AZBuilt 2005 · S/N T18208446N2049PVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N T18208448N204JHLivin The Dream Too LLC · St Paul, MNBuilt 2006 · S/N T20608638N204RSKenai Peninsula Air Transportation & Lodging LLC · Lake Havasu, AZBuilt 2011 · S/N T20609029N20502Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12525
Back to AD 2003-24-13