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.

N960AUAuburn University · Auburn, ALBuilt 2017 · S/N 172S12098N960CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281990N960CSCentury Equipment Co Inc · Salt Lake City, UTBuilt 2012 · S/N T20609064N960MSMt San Antonio Community College District · Walnut, CABuilt 2001 · S/N 172S8859N960TAInnoutaero LLC · Stockton, CAS/N 172S8960N961AUAuburn University · Auburn, ALBuilt 2018 · S/N 172S12154N961BARobertson Breon J · Mc Allister, MTBuilt 2000 · S/N T20608183N961LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 172S12031N961RWBerchick Inc · Corrales, NMBuilt 2004 · S/N T18208303N962AUAuburn University · Auburn, ALBuilt 2019 · S/N 172S12292N962CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281972N962JBNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282149N962LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 172S12032N962PBNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282159N963ACYoung Paul J · Hudson, MABuilt 1999 · S/N 172S8259N963AUAuburn University · Auburn University, ALBuilt 2020 · S/N 172S12478N963CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281973N963EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2023 · S/N 172S13007N963JADeland Aviation LLC · Deland, FLBuilt 2007 · S/N 172S10521N963LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 172S12033N963SPAero Aircraft 11 LLC · Jacksonville, FLBuilt 1999 · S/N 172S8166N963TASvetfur Aviation LLC · Camden, SCBuilt 2004 · S/N 172S9610N964AC63 Victor LLC · Fremont, OHBuilt 1999 · S/N 20608073N964AUAuburn University · Auburn University, ALBuilt 2020 · S/N 172S12479N964CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282410N964DAHeritage Aviation Management Ltd · Conroe, TXBuilt 2020 · S/N T20609610N964EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S13010N964JRFvx Research · Manassas, VABuilt 2013 · S/N T20609108N964LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 172S12034N964NWJpana Air Wa LLC · Seattle, WABuilt 2007 · S/N T20608709N964SPDirty Side Down Aviation LLC · Georgetown, TXBuilt 1999 · S/N 172S8176N964WFTempietto Inc · Aptos, CABuilt 2003 · S/N 18281291N965AUAuburn University · Auburn University, ALBuilt 2020 · S/N 172S12480N965BBBascom Kimber Keith · Mckinney, TXBuilt 2013 · S/N 172S11251N965CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281965N965CWAir Capital Aviators Club · Wichita, KSBuilt 2000 · S/N 18280769N965EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S13013N965LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 172S12035N966ACWhiskey Charlie Aero LLC · Poway, CABuilt 2001 · S/N 172S8845N966AUAuburn University · Auburn University, ALBuilt 2020 · S/N 172S12481N966CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281966N966CSEvergreen III LLC · Renton, WABuilt 2012 · S/N T20609066N966LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 172S12036N967CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281967N967LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 172S12037N967MMMoney Multiplier Meridian LLC · Port Orange, FLBuilt 2022 · S/N T20609692N967SAElizabeth City State University · Elizabeth City, NCBuilt 2002 · S/N 172S9067N9681Srividya Aviators LLC · North Brunswick, NJBuilt 1998 · S/N 18280233N9681FSplashdown Aviation LLC · Dunedin, FLBuilt 1998 · S/N 18280268N968CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281968
Back to AD 2003-24-13