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.

N420ERAtp Aircraft 2 LLC · Wilmington, DEBuilt 1998 · S/N 17280634N420FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 2004 · S/N 18281494N420HPBraden Health LLC · Greensboro, NCBuilt 2005 · S/N 18281637N420SPWings Over Texas Holdings LLC · Denton, TXBuilt 2000 · S/N 172S8351N420URcs Services LLC · California, MDBuilt 1997 · S/N 17280120N420WABlue Yonder Enterprises LLC · Los Altos, CABuilt 2017 · S/N 18283027N4210MParagon Air Group · Fort Worth, TXBuilt 1998 · S/N T20608009N42178Montana Dept Of Transportation · Helena, MTBuilt 1999 · S/N T20608032N4218UJakks Inc · Wilmington, DEBuilt 1999 · S/N T20608035N421CSCrowbar Enterprises LLC · Inola, OKBuilt 2021 · S/N 18283121N421ERCc Aviation Inc · Tracy, CABuilt 2004 · S/N 172S9679N421FPJustus Christopher S · Corona, CABuilt 1998 · S/N 17280638N421FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 2004 · S/N 18281495N421KRAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2004 · S/N T18208308N421RWPac1 LLC · Clinton, IABuilt 2004 · S/N 172S9593N421SARedbreast Aviation LLC · Boonton, NJBuilt 2004 · S/N 18281378N4225NRy Cor LLC · Stevens Point, WIBuilt 1999 · S/N 18280445N42273Reeds Pharmacy LLC · Berkeley Springs, WVBuilt 1999 · S/N 18280444N422CBHeavy Metal Air LLC · Farmingdale, NYBuilt 2005 · S/N 172S10011N422EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2017 · S/N 172S12022N422HABrightwater Enterprises LLC · Lakeway, TXBuilt 2005 · S/N 172S9830N422KBKaempfer Melissa Jean · Lenoir City, TNBuilt 1999 · S/N 18280512N422LSSkyknight LLC · Greeneville, TNBuilt 2011 · S/N 172S11117N422MTMissouri Dept Of Transportation · Jefferson City, MOBuilt 2008 · S/N 18282051N422SHSig Aero LLC · Lewes, DEBuilt 2019 · S/N 18283090N4231TInternational Air Services Inc Trustee · Carson City, NVS/N 172S12370N423CAAerochatt LLC · Cleveland, TNBuilt 2015 · S/N 172S11612N423CMHurricane Creek Flying Club LLC · Walla Walla, WABuilt 2000 · S/N 20608109N423EWings Over Texas Holdings LLC · Denton, TXBuilt 2014 · S/N 172S11447N423RCConcord Trailer World Inc · Concord, CABuilt 2019 · S/N T20609592N423SCJuliet Charlie Aviation LLC · Oregon City, ORBuilt 2020 · S/N 172S12542N423SPSierra Papa LLC · Salt Lake City, UTBuilt 2000 · S/N 172S8352N423TABas Part Sales LLC · Greeley, COBuilt 2003 · S/N T18208208N424DN424d LLC · Naples, FLBuilt 2024 · S/N T18209162N424EChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11448N424EKDeland Air And Sea Brokerage Inc · Deland, FLBuilt 2009 · S/N T18208981N424FARobinson Todd Allen · San Luis Obispo, CABuilt 2003 · S/N T20608424N424PEUniversity Of Alaska Anchorage · Anchorage, AKBuilt 2017 · S/N 172S12058N424STMisto Louis III · Westerly, RIBuilt 2005 · S/N 18281739N424TRCovin Equipment LLC · Arlington, TXBuilt 2005 · S/N 18281562N424WHSchmidt Richard A · West Linn, ORBuilt 2004 · S/N T18208294N4258FGoldfinch LLC · New York, NYBuilt 2024 · S/N T18209135N425CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 2001 · S/N 172S8687N425CRAtp Aircraft 8 LLC · Wilmington, DEBuilt 2014 · S/N 172S11449N425EJCity Of Portland · Portland, ORBuilt 2015 · S/N 18282372N425KPBrown David B · Cumberland, VAS/N 18281383N425PKGood Flight LLC · San Luis Obispo, CABuilt 2004 · S/N 18281449N42632Hebert Mark R Trustee · Lakeville, MNBuilt 2022 · S/N 18283184N426CPCivil Air Patrol · Montgomery, ALBuilt 2001 · S/N 172S8688N426EPKentucky Airmotive Inc · Mount Sterling, KYBuilt 1998 · S/N 17280647
Back to AD 2003-24-13