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.

N441RMVaquero Nm LLC · El Paso, TXS/N T20609032N442CROklahoma Aviation LLC · Bethany, OKBuilt 2015 · S/N 172S11519N442DZValiair Limited Company Trustee · Casper, WYBuilt 2004 · S/N T20608453N442ERChristiansen Aviation LLC · Wilmington, DEBuilt 2017 · S/N 172S12029N442KSChristiansen Aviation LLC · Wilmington, DEBuilt 2020 · S/N 172S12514N443EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12644N443HPMotorcarlease USA Inc · Miami Beach, FLBuilt 2000 · S/N T20608241N443KSKent State University · Stow, OHBuilt 2020 · S/N 172S12473N444BXTextron Aviation Inc · Wichita, KSS/N T20609862N444FRRainier Flight Service LLC · Renton, WABuilt 2015 · S/N 172S11577N444GW2.8 Gpa LLC · Dover, DEBuilt 2011 · S/N T20609016N444THAtlas Aviation Tampa Inc · Tampa, FLBuilt 2020 · S/N 172S12440N444VStrock Gary · Annville, PABuilt 2026 · S/N T20609846N444VBYoung Reginald S · Buffalo Junction, VABuilt 2001 · S/N 18281034N444VCGa Flying LLC · Jupiter, FLBuilt 1999 · S/N 18280483N444VWN444vw LLC · Union Gap, WABuilt 2016 · S/N 172S11666N444VXStrock Gary L · Annville, PABuilt 2016 · S/N T20609229N445AFPlane Nonsense Inc · Middletown, DEBuilt 1998 · S/N 17280445N445BDornoch Services LLC · Dover, DEBuilt 2005 · S/N 172S9776N445BWFlight Operations Aircraft LLC · Wilmington, DES/N 17280662N445CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13248N445CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282356N445DChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 172S8264N445KSPeraton Services LLC · Bozeman, MTBuilt 2020 · S/N 172S12534N446AFBeale Air Force Base Aero Club · Beale Afb, CABuilt 1998 · S/N 17280446N446CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13263N446CSSocal Pilot Center · La Quinta, CABuilt 2017 · S/N 172S12001N446ERWingsleasing LLC · Wichita, KSBuilt 2006 · S/N 172S10220N446SPLam Capital Management LLC · Sheridan, WYBuilt 1999 · S/N 172S8310N447CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282353N447ERSilver Express DBA · Miami, FLS/N 172S10221N447ESRegistered aircraftS/N 18280135N447LSSouthwest Aviation Enterprises · Haslet, TXBuilt 2014 · S/N T20609156N448AFBeale Air Force Base Aero Club · Beale Afb, CABuilt 1998 · S/N 17280448N448CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12505N448ERAtp Aircraft 4 LLC · Wilmington, DEBuilt 1998 · S/N 17280610N448ESSchaefer Mark D · Oconomowoc, WIBuilt 1998 · S/N 18280203N448RJRonald Janis · New York, NYBuilt 2019 · S/N 18283081N448TWCanyon Aviation LLC · Glenwood Springs, COBuilt 2023 · S/N T20609721N449CSHorizon Flight Center LLC · Chesapeake, VABuilt 2017 · S/N 172S12025N449SPGolden Eagle Flying Club Ltd · West Islip, NYBuilt 1999 · S/N 172S8315N44PYSegler Angela U · Marco Island, FLBuilt 2000 · S/N 172S8543N44UDB & K Aviation LLC · Danville, CABuilt 2017 · S/N 172S12072N44WSAviation Insurance Managers Inc · Uniontown, OHBuilt 2023 · S/N T18209108N450EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S12955N450TPCounty Of San Joaquin · Stockton, CABuilt 2008 · S/N T20608888N451BA1928 LLC · Salmon, IDBuilt 2005 · S/N 18281645N451CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282194N451RWajh Marine 1 LLC · Phoenix, AZBuilt 2012 · S/N T20609075N452CPCivil Air Patrol · Montgomery, ALBuilt 2013 · S/N 18282368
Back to AD 2003-24-13