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.

N563EREmbry-Riddle Aeronautical Univerity Inc · Prescott, AZBuilt 2023 · S/N 172S13088N563FAWang Yuemin · Wauconda, ILBuilt 2003 · S/N 172S9563N563LTPrudence Aviation Group · Fort Worth, TXBuilt 2020 · S/N T20609607N563NDAerosim Academy Inc · Sanford, FLBuilt 2008 · S/N 172S10788N563SPSloan Joseph · Lancaster, CAS/N 172S8416N564ATMustang Sally Aviation LLC · Camden, SCBuilt 2005 · S/N 172S10020N564LMSky Horse LLC · Santa Cruz, CABuilt 2012 · S/N 20608340N564MCB Air Lc · Sikeston, MOBuilt 2000 · S/N 172S8512N564PCHargest Custom Cabinetry LLC · Clermont, NJBuilt 1998 · S/N 18280248N565ADPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2005 · S/N 172S9991N565CHTextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2026 · S/N 172S13493N565DBGolf Gear LLC · University Park, FLBuilt 2015 · S/N T20609174N565EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12877N565MCAviator Air Flight School LLC · Grand Prairie, TXBuilt 2000 · S/N 18280782N565NDAerosim Academy Inc · Sanford, FLBuilt 2008 · S/N 172S10797N565SATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 20608188N565SPLlp Leasing Group LLC · Lewes, DEBuilt 2000 · S/N 172S8489N5667KSmith John L · Renton, WABuilt 2001 · S/N 172S8991N566CPCivil Air Patrol · Maxwell Afb, ALBuilt 2018 · S/N 18283033N566DDeland Aviation LLC · Deland, FLBuilt 2007 · S/N 172S10529N566EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12878N566MEKaiser Aviation LLC · Spring, TXBuilt 2005 · S/N T20608566N566NDCoast Flight Training And Management Inc · San Diego, CABuilt 2008 · S/N 172S10804N566SPLlp Leasing Group LLC · Lewes, DEBuilt 2000 · S/N 172S8490N567AAAoa Kissimmee Inc · Kissimmee, FLBuilt 2014 · S/N 172S11418N567CBValiair Lc Trustee · Casper, WYBuilt 2002 · S/N T20608381N567CPCivil Air Patrol · Maxwell Afb, ALS/N 18282167N567DDAir America Flight Center LLC · Daytona Beach, FLBuilt 2005 · S/N 172S9971N567JWKingdom Power And Glory LLC · Colorado Springs, COBuilt 1999 · S/N 172S8187N567NDMoore Aviation Inc · Beaver Falls, PABuilt 2008 · S/N 172S10805N567SPAb Prop Plane II LLC · Metairie, LABuilt 2021 · S/N 172S12705N568CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 18283105N568MCChristianson Kelly · Lusk, WYBuilt 2001 · S/N T18208010N568NDAerosim Academy Inc · Sanford, FLBuilt 2008 · S/N 172S10806N569CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 18283071N569DVDelta Victor LLC · Wilmington, DEBuilt 2002 · S/N T18208173N569FGMustang Sally Aviation LLC · Camden, SCBuilt 2008 · S/N 172S10871N569NDVertol Systems Co Inc · Destin, FLBuilt 2009 · S/N 172S11004N569RJNational Training I LLC · Wilmington, DES/N 172S8896N569SPGlobal Flight Training Solutions Inc · Immokalee, FLBuilt 2000 · S/N 172S8494N56CWLaurel Aviation Inc · Decatur, ILBuilt 2024 · S/N 18283256N56GUIdagus N56gu LLC · Miami, FLBuilt 2022 · S/N 18283208N56LUService Oriented Aviation Readiness S.O.A.R. · Bolivar, MOBuilt 2016 · S/N 172S11727N570DBAtlas Aviation Tampa Inc · Tampa, FLBuilt 2005 · S/N 18281570N570FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13455N570JAJ A Flight Services LLC · Sugar Grove, ILBuilt 2007 · S/N 172S10575N570NDAerosim Academy Inc · Sanford, FLBuilt 2009 · S/N 172S10847N570SPOne Seventy To Delta LLC · Scottsdale, AZBuilt 2000 · S/N 172S8495N57133Grove Ronald DBA · San Carlos, CABuilt 2005 · S/N T20608522N571BWBridgewater State University · Bridgewater, MABuilt 2004 · S/N 172S9738
Back to AD 2003-24-13