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.

N9288XKs&G Management Inc · Carlsbad, NMBuilt 2011 · S/N T20609014N928AZOceano Packing Company LLC · Pismo Beach, CABuilt 2006 · S/N T20608614N928CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282396N928CTSkydonkey Aviation LLC · Valdosta, GABuilt 2016 · S/N T20609208N928FGMustang Sally Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10371N928HLJ & M Sales & Leasing LLC · Abingdon, ILS/N T20608066N928LPMontana Freedom Riders LLC · Corvallis, MTBuilt 2001 · S/N 172S8928N928MAAnson Air LLC · Sugar Land, TXFirst renewal noticeBuilt 1999 · S/N 17280785N928ZAFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 172S12786N92959Warar Manjit Singh · Shreveport, LABuilt 2011 · S/N T18209046N92966Six J Aviation LLC · Palestine, TXBuilt 2011 · S/N T20609018N92970Elizabeth City State University · Elizabeth City, NCBuilt 2011 · S/N 172S11124N92977Redse Erik S Trustee · San Francisco, CABuilt 2011 · S/N T20609020N92983Dw Above The Rest LLC · Las Vegas, NVBuilt 2011 · S/N T20609021N92FSEastern Kentucky University · Richmond, KYBuilt 1998 · S/N 17280308N92HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2000 · S/N 172S8642N92LCEastern Kentucky University · Richmond, KYBuilt 1997 · S/N 17280153N92VBClear Skies LLC · Eugene, ORBuilt 2013 · S/N T18209092N92ZSky Galaxy 1 LLC · Lake Placid, NYBuilt 2008 · S/N T18208841N9303NWings Over Texas Holdings LLC · Denton, TXBuilt 2011 · S/N 172S11118N9305NRancho Av Leasing LLC · Temecula, CABuilt 2011 · S/N 172S11132N9309CVan Bortel Aircraft Inc · Arlington, TXBuilt 2011 · S/N 18282306N930BMCoastal Aviation LLC · Nags Head, NCBuilt 2009 · S/N T18208980N930CMR F Cooper Enterprises LLC · Scottsdale, AZBuilt 2025 · S/N T20609830N930CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282398N930CTStark Holdings LLC · Kalispell, MTBuilt 2016 · S/N T20609209N9311PJjjfgt Capital Holdings LLC · Truckee, CABuilt 2011 · S/N T20609026N9318WAutoscribe Arrow LLC · Fort Lauderdale, FLBuilt 2011 · S/N T18209051N931SJTss Flying Club Inc · Bethesda, MDBuilt 2001 · S/N 18280931N931VMVermeer Great Plains Inc · Olathe, KSBuilt 2011 · S/N T18209054N9324FKrueger Michael L D O · Fresno, CABuilt 2011 · S/N T18209055N932BVNby Productions · Bristow, VABuilt 2021 · S/N T20609648N932FGTextron Aviation Inc · Wichita, KSS/N 172S13645N933CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282399N933CSTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 18283333N933FMSouthwest Aviation Enterprises · Haslet, TXBuilt 2023 · S/N T20609740N933LAMindy Limited LLC · Muscatine, IABuilt 1998 · S/N 17280640N9342FChurchill David J · Bear, DEBuilt 1998 · S/N 18280105N9342TChristiansen Aviation LLC · Wilmington, DEBuilt 2011 · S/N 172S11153N9344FAtp Aircraft 2 LLC · Wilmington, DEBuilt 1997 · S/N 17280166N9347TLewis University · Romeoville, ILBuilt 2012 · S/N 172S11166N9348FDirty Side Down Aviation LLC · Georgetown, TXBuilt 1997 · S/N 17280189N934AZN934az LLC · Miami, FLBuilt 1999 · S/N 172S8294N934CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282400N934EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2023 · S/N 172S12982N934MT8th Dimension Enterprises LLC · Englewood, COBuilt 1997 · S/N 17280058N93517Pjc700 LLC · Las Vegas, NVBuilt 2012 · S/N T18209066N9351FCarr Sam H · Spring, TXBuilt 1998 · S/N 18280104N9355TR-Trans LLC · Bad Axe, MIS/N T20609754N9357ZJlh Farms Inc · Dumas, ARBuilt 2012 · S/N T20609052
Back to AD 2003-24-13