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.

N335SPMaui Aviators LLC · Pukalani, HIBuilt 2003 · S/N 172S9495N336CPCivil Air Patrol · Montgomery, ALBuilt 2010 · S/N T18209012N336MCLewis University · Romeoville, ILBuilt 2022 · S/N 172S12880N337BMSky Drivers LLC · La Fayette, GABuilt 1999 · S/N 18280629N337CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 18283116N337CRElder Bruce W · Farmington, NMBuilt 2004 · S/N T18208259N337DBOlson Vienette · White Bear Lake, MNBuilt 2001 · S/N 18281027N337MEFlytcentrix LLC · Lewes, DES/N 172S8468N338GSSanders Flight Training Center Inc · Jasper, ALBuilt 2025 · S/N 172S13326N338MEBoulant Michael Lee Charles · Las Vegas, NVBuilt 2000 · S/N 18280730N338SAGonzalez Jesse · Colorado Springs, COBuilt 1999 · S/N T20608041N338WSWinsors Wings LLC · Rogersville, MOBuilt 2008 · S/N T20608828N339MEShinkle Gordon · Gillette, WYBuilt 2000 · S/N 18280734N339SABig River Farms Inc · Natchez, MSBuilt 1999 · S/N 18280508N339SPCahill Michael · Moon Township, PABuilt 2003 · S/N 172S9496N33FMAtp Aircraft 7 LLC · Wilmington, DEBuilt 2012 · S/N 172S11196N33HARykris Investments LLC · Bowling Green, KYBuilt 2011 · S/N 18282279N33LAOscar Tango LLC · Mesa, AZBuilt 2020 · S/N 172S12446N340CSTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N T20609840N340HPBeartooth Aviation LLC · Kalispell, MTBuilt 2000 · S/N 18280889N340MTAcron Aviation Academy Inc · Sanford, FLBuilt 2006 · S/N 172S10374N341CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 172S13499N341DREcho Sierra Inc · Potomac Falls, VABuilt 1999 · S/N 18280467N341PCWoods Ronnie Lee · Weatherford, TXBuilt 1997 · S/N 18280014N341SPSo Cal Leasing LLC · El Cajon, CABuilt 2003 · S/N 172S9497N342CSTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N T20609842N342MEAerostatics LLC · Gainesville, FLBuilt 2000 · S/N 18280738N342SASunrise Aviation Inc · Ormond Beach, FLS/N 172S10475N342TSDaniels Law · Sherman Oaks, CABuilt 2001 · S/N T18208040N343CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 18283310N343CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12344N343METhurman Craig Johnson · Ona, WVBuilt 2000 · S/N 18280739N343PTDiamond Head Aviation LLC · Kunia, HIBuilt 2005 · S/N 172S9831N343SASunrise Aviation Inc · Ormond Beach, FLBuilt 2007 · S/N 172S10477N343SPEight16 LLC · Lewes, DEBuilt 2003 · S/N 172S9498N343TCTwo Rivers Aircraft Managmenet LLC · Williamsburg, VABuilt 2004 · S/N T18208344N344CACivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282137N344JEAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13472N344RBContinental Aerospace Technologies Inc · Mobile, ALBuilt 2011 · S/N 172S11133N344SPSun City Aviation LLC · Davie, FLBuilt 1999 · S/N 172S8267N345BPeraton Services LLC · Venice, CABuilt 1999 · S/N 172S8177N345CMScherson David Alejandro · Folsom, CABuilt 2010 · S/N T18209016N345CSFlight Training Aircraft LLC · Wilmington, DEBuilt 2015 · S/N 172S11527N345DPBack Country Hacks LLC · Olalla, WABuilt 2001 · S/N T20608269N345FHHeavy Metal Air LLC · Farmingdale, NYBuilt 2012 · S/N 172S11160N345MEOtt James E · Redlands, CABuilt 2000 · S/N 172S8577N345RKButler Management LLC · Sherman Oaks, CABuilt 2007 · S/N T18208790N345TJOpa Flys LLC · Magnolia, TXBuilt 2004 · S/N 18281469N345WCEnriquez Antonio · Austin, TXBuilt 2023 · S/N T18209105N3469246dk LLC · Ramona, CABuilt 2004 · S/N T18208248
Back to AD 2003-24-13