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.

N266BBJk Air LLC · Duncan, OKBuilt 1999 · S/N T20608082N266LARaintree Aviation LLC · Mesa, AZBuilt 2012 · S/N 172S11178N266MEGershman Randy · Marshfield, WIBuilt 2000 · S/N 18280772N266SPTfs Air LLC · Loveland, COBuilt 2003 · S/N 172S9471N266TATextron Aviation Inc · Wichita, KSS/N 18283365N2672XBird Nest Aviation LLC · Sheldon, IABuilt 1998 · S/N 18280305N267ABConcrete Experts LLC · Colorado Springs, COBuilt 2007 · S/N T20608792N267FGRidgeline Assets LLC · Wilmington, DES/N 172S12725N267HPFlorida Highway Patrol · Tampa, FLBuilt 2002 · S/N 172S9267N267JMMathews Development Co · Santa Rosa Beach, FLBuilt 1999 · S/N T20608132N267MCKitchen Blaine III · Rochester, MABuilt 2006 · S/N 20608267N267MECape Aero LLC · Cape Girardeau, MOBuilt 2000 · S/N 18280774N267RHPxw Services · Bristow, VABuilt 2010 · S/N 18282208N2680XN2680x LLC · Mountain Home, ARBuilt 1998 · S/N 18280307N2682CInternational Air Services Inc Trustee · Carson City, NVS/N 18281648N2687LA R Preston Holdings LLC · Ontario, NYBuilt 1998 · S/N 18280314N268CPCivil Air Patrol · Maxwell Afb, ALBuilt 2017 · S/N 18283018N268CSInternational Air Services Inc Trustee · Carson City, NVBuilt 2013 · S/N 172S11266N268CTCoast Flight Training And Management Inc · San Diego, CABuilt 2005 · S/N 17281258N268EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13506N268FMRunamuck LLC · New Orleans, LABuilt 2024 · S/N 172S13268N268HPFlorida Highway Patrol · Tampa, FLBuilt 2005 · S/N T20608579N268MERegistered aircraftBuilt 2000 · S/N 18280776N268TZHague Robert A · Rogers, ARBuilt 2020 · S/N 18283108N268ZMewmew Investment II LLC · Palo Alto, CABuilt 2023 · S/N 172S12947N2698XHall Clinton Arthur Jr · Klamath Falls, ORBuilt 1998 · S/N 18280318N269DDAircraft Solutions Group LLC · Englewood, COBuilt 2005 · S/N 172S9981N269EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13509N269FGMustang Sally Aviation LLC · Camden, SCBuilt 2008 · S/N 172S10885N269MEGeorge'S Aviation Services · Honolulu, HIBuilt 2000 · S/N 172S8531N269SFlightco Inc · Swainsboro, GABuilt 2001 · S/N 18281061N269SAAlthof Equipment Management LLC · Jupiter, FLBuilt 2011 · S/N 18282280N269SHDan Julian LLC · Woodway, TXBuilt 2007 · S/N T18208729N26AAMustang Sally Aviation LLC · Camden, SCBuilt 2016 · S/N 172S11693N26BMRegistered aircraftBuilt 1999 · S/N 18280659N26BQAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13219N26KMPerformance Aviation Solutions LLC · Meridian, IDBuilt 2001 · S/N T18208051N26LPAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13252N26NZBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N T20608401N26VRReed Edward · Marcellus, MIBuilt 2005 · S/N T20608563N26WEGrand Aviation LLC · Asbury, NJBuilt 1998 · S/N 18280225N270CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13089N270CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282352N270DMMarbry Holdings LLC · Naples, FLBuilt 2020 · S/N 18283115N270FASchoettelkotte Christopher B · Friendswood, TXBuilt 2003 · S/N 18281270N270JARegistered aircraftBuilt 2000 · S/N 172S8619N270MEMm Aviation LLC · Casa Grande, AZBuilt 2000 · S/N T20608213N270SPSan Pedro Aviation LLC · San Antonio, TXBuilt 2025 · S/N T20609815N270UOhio University · Albany, OHBuilt 2003 · S/N 172S9520N2711RBoeing Employees Flying Association Inc · Renton, WABuilt 2001 · S/N 172S8864
Back to AD 2003-24-13