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.

N53576Venbro Holdings LLC · Brooklyn, NYS/N 172S9398N53577New Horizon Aviation Inc · Warwick, RIBuilt 2003 · S/N 172S9399N53587Chapel Hill Flying Club Inc DBA · Sanford, NCBuilt 2003 · S/N 172S9407N5359KAbove And Beyond Aviation LLC · Austin, TXBuilt 2003 · S/N 172S9447N535CHThibault Dominic · Titusville, FLS/N T18209212N535EMCity Of Hawthorne · Hawthorne, CABuilt 2010 · S/N T20608989N535EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2024 · S/N 172S13168N535HFPars Avn Corp · Wilmington, DEBuilt 2000 · S/N 17280926N535KSKent State University · Stow, OHBuilt 2013 · S/N 172S11321N535VWAtp Aircraft 4 LLC · Wilmington, DEBuilt 2000 · S/N 172S8384N53610Joe Wigginton Leasing LLC · Henderson, NVS/N 18281223N53614Orange County Flight Center Inc · Santa Ana, CABuilt 2003 · S/N 172S9413N53636Sterling Flight Training · Jacksonville, FLS/N 172S9415N5363QCary Gosney Crna Inc · Sonora, CABuilt 2003 · S/N T18208203N5363ZClover Park Technical College · Lakewood, WABuilt 2003 · S/N 17281173N5364ABradley Flying Association · Peoria, ILFirst renewal noticeBuilt 2003 · S/N 172S9417N536DDHughes Jacob · Denver, COBuilt 2004 · S/N T18208317N536EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2024 · S/N 172S13171N536GRNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282182N536HFVan Anda Aviation LLC · Apopka, FLBuilt 2000 · S/N 17280954N536KSKent State University · Stow, OHBuilt 2025 · S/N 172S13365N536LAhmed Ejaz DBA · Carrollton, GABuilt 2017 · S/N 18283023N536NDPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2009 · S/N 172S10932N536SPEastern Cincinnati Aviation · Batavia, OHBuilt 2000 · S/N 172S8388N536THLanier Equipment Leasing LLC · Gainesville, GABuilt 2021 · S/N 172S12636N537AMMazel Wings LLC · Camden, DEBuilt 2025 · S/N T18209176N537EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2025 · S/N 172S13305N537HFSilver Express Co · Miami, FLBuilt 2000 · S/N 17280891N537HPBarr Air Patrol LLC · Mesquite, TXS/N 18280031N537KSKent State University · Stow, OHBuilt 2014 · S/N 172S11388N537NDSpartan Education LLC · Tulsa, OKBuilt 2009 · S/N 172S10990N537SAMills Michael R · Saratoga Springs, NYBuilt 2021 · S/N 18283133N537SP5280 Flying Club LLC · Castle Pines, COBuilt 2000 · S/N 172S8393N538CPCivil Air Patrol · Maxwell Afb, ALBuilt 2011 · S/N T18209030N538EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13078N538HFSun Aircraft Management LLC · Ormond Beach, FLBuilt 2000 · S/N 17280873N538KSKent State University · Stow, OHBuilt 2014 · S/N 172S11389N538NDAerosim Academy Inc · Sanford, FLBuilt 2008 · S/N 172S10832N538SPRc Flying Partners LLC · Fair Oaks, CABuilt 2000 · S/N 172S8395N539CPCivil Air Patrol · Maxwell Afb, ALBuilt 2011 · S/N T18209031N539KSKent State University · Stow, OHBuilt 2015 · S/N 172S11646N539MYMiller Aviation LLC · Murfreesboro, TNBuilt 2010 · S/N 18282238N539NDAerosim Academy Inc · Sanford, FLBuilt 2008 · S/N 172S10850N53AAMustang Sally Aviation LLC · Camden, SCBuilt 2016 · S/N 172S11737N53FFWingsleasing LLC · Wichita, KSBuilt 2022 · S/N 172S12876N53FVTorres Ramon Luis · San Juan, PRS/N 18281083N53KPMateos Louise M · Santa Clara, CABuilt 2005 · S/N 18281541N53LULetourneau University · Longview, TXBuilt 2024 · S/N 172S13200N540CFCertified Aviation LLC · Morristown, NJBuilt 2005 · S/N 172S9898N540CPCivil Air Patrol · Maxwell Afb, ALBuilt 2014 · S/N T20609139
Back to AD 2003-24-13