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.

N249WARace Mark · Tyler, TXBuilt 1998 · S/N 182-80103N24AFAbove & Beyond Aviation LLC · Austin, TXBuilt 1998 · S/N 17280439N24BQAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13217N24CYAllman Darrell W Jr · Edmond, OKBuilt 2022 · S/N 18283165N24GLTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N T20609851N250AUPeregrine Howard Partners II Lp · New Orleans, LABuilt 2024 · S/N 172S13265N250ESilver Creek Aviation Services · Fort Worth, TXBuilt 2005 · S/N 20608250N250EWPlane Fun Inc Tr Trustee · Snellville, GABuilt 2020 · S/N 18283106N250MELake Superior Aviation Llp · Duluth, MNBuilt 2000 · S/N T20608189N250SUOklahoma State University · Stillwater, OKBuilt 2016 · S/N 172S11675N250YZAtp Aircraft 2 LLC · Wilmington, DEBuilt 2015 · S/N 172S11608N25110Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13287N25111Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13290N25112Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13293N25113Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13296N25114Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13298N25115Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13299N25116Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13300N25118Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13302N25121Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13306N25122Career Track 3 LLC · Wilmington, DES/N 172S13309N25123Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13312N25126Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13313N25129Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13319N25130Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13320N25132Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13321N25135Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13327N25136Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13330N25139Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13333N25141Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13336N25143Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13337N25145Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13338N25150Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13339N25152Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13342N25153Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13345N25157Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13348N25158Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13351N25160Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13354N25161Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13357N25163Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13360N25167Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13363N25170Career Track 5 LLC · Wilmington, DEBuilt 2025 · S/N 172S13366N25171Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13368N25172Career Track 5 LLC · Wilmington, DEBuilt 2025 · S/N 172S13369N25173Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13370N25176Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13371N25177Career Track 5 LLC · Wilmington, DEBuilt 2025 · S/N 172S13372N25180Career Track 5 LLC · Wilmington, DEBuilt 2025 · S/N 172S13375N25181Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13376N25182Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13377
Back to AD 2003-24-13