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.

N935CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282401N935FACaylin LLC · Wilmington, DEBuilt 2007 · S/N 18281935N935SCLima Aviation LLC · Oregon City, ORBuilt 2020 · S/N 172S12475N9362MRegistered aircraftBuilt 2012 · S/N 172S11195N93673Flight Trainer LLC · Wilmington, DEBuilt 2012 · S/N 172S11184N936CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282402N936CSTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 18283336N936SPHard Way LLC · Dover, DEBuilt 2020 · S/N 18283107N93707Vertol Systems Co Inc · Destin, FLBuilt 2012 · S/N 172S11159N9370RFlight Trainer LLC · Wilmington, DEBuilt 2012 · S/N 172S11189N9370UShort Approach LLC · Sammamish, WABuilt 2012 · S/N T18209059N9371YBob Gist Insurance Agency Inc · Jonesboro, ARBuilt 2012 · S/N T18209061N9373FDirty Side Down Aviation LLC · Georgetown, TXBuilt 1997 · S/N 17280160N9379FAtp Aircraft 1 LLC · Wilmington, DEBuilt 1999 · S/N 17280764N937DRStratton Michael C · Hermiston, ORBuilt 1997 · S/N 17280217N937EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2023 · S/N 172S12985N937SAAdvanced Aviation Group LLC · Frederick, MDBuilt 2003 · S/N 172S9377N9381BDoctor Bad Ass LLC · Kalispell, MTBuilt 2012 · S/N T20609039N938CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282403N938DDSkytech Investment Drilling Inc · Phoenix, AZBuilt 2006 · S/N T20608615N938EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2023 · S/N 172S12988N938SAAa-Aero LLC · Lewes, DEBuilt 2003 · S/N 172S9388N9392FBas Part Sales LLC · Greeley, COBuilt 1997 · S/N 17280205N939AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2026 · S/N 172S13564N939DJJaffray Management LLC · Green Cove Springs, FLBuilt 2003 · S/N 18281226N939SPAero Aircraft 12 LLC · Jacksonville, FLS/N 172S8876N93HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2000 · S/N 172S8643N93SDRealtyaviation LLC · Key Largo, FLBuilt 2018 · S/N 18283036N9402DH C E Leasing LLC · Cleveland, TNBuilt 2012 · S/N 18282312N9404FBas Part Sales LLC · Greeley, COBuilt 1997 · S/N 17280229N94079Burney Jeffrey W · Sorrento, FLBuilt 2012 · S/N T18209057N940CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282405N940HPKansas Highway Patrol · Topeka, KSS/N 20608343N940MAMoore Charles H · Richmond, TXBuilt 1998 · S/N 18280360N940MRRooney Michael · Pittsburgh, PABuilt 2018 · S/N T20609530N940RMSchool Of Missionary Aviation Technology · Ionia, MIBuilt 2003 · S/N 172S9386N94141Romer-Pollis Victoria Elizabeth · Lake Havasu City, AZBuilt 2012 · S/N T20609051N9417ZAmerican Aviation Inc · Brooksville, FLBuilt 1997 · S/N 17280265N941BMGk Transportation LLC · Clarksville, TNBuilt 1998 · S/N 18280408N941CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281941N941EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S12976N941JDiane And Cliff Knight Properties LLC · Houston, TXBuilt 2025 · S/N T20609806N941KBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2020 · S/N 172S12576N941RBTexas Flight Training Aircraft 8 LLC · Wilmington, DEBuilt 2003 · S/N 172S9443N941SBSarasota Seabreeze Flyers Inc · Venice, FLBuilt 2026 · S/N 18283346N941SFSuncoast Flyers Inc · Venice, FLBuilt 2026 · S/N T20609836N941TLandings At Quonset Airport LLC · Exeter, RIBuilt 2006 · S/N T18208486N941TH941th LLC · Bethany, OKBuilt 2024 · S/N 172S13141N9421ZL&W Leasing LLC · Smyrna, TNBuilt 1997 · S/N 17280267N9424FOwens Mark T · Zionsville, INBuilt 1998 · S/N 17280390
Back to AD 2003-24-13