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.

N414ERRegistration Pending · Wilmington, DERegistration pendingBuilt 2017 · S/N 172S12026N414MEEight Ball Flying Club Inc · Van Nuys, CABuilt 2000 · S/N 18280865N414PKTakeoff Properties LLC · Belmont, NCBuilt 2023 · S/N 18283243N414TBTextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2026 · S/N 172S13494N415LEStadelman Edwin F · East Falmouth, MABuilt 1999 · S/N 20608042N415RCAvco Patrol LLC · Lyndon, KSBuilt 1998 · S/N 18280302N415RJAviation Training LLC · Wilmington, DEBuilt 2005 · S/N 172S9943N415SPAmeriflyers Of Texas Inc · Addison, TXBuilt 1999 · S/N 172S8346N4169WSebago Flight Service Inc · Cumberland, MEBuilt 2014 · S/N T20609154N416CPChristiansen Aviation LLC · Wilmington, DEBuilt 2020 · S/N 172S12504N416CSTextron Aviation Inc · Wichita, KSBuilt 2016 · S/N 18282416N416FRChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11444N416SPRegistered aircraftBuilt 2000 · S/N 172S8349N416WREagle Flying Club Of Embry-Riddle Aero Univ Inc · Daytona Beach, FLBuilt 2002 · S/N 172S9160N4172PDmac Aircraft LLC · Savannah, GABuilt 1997 · S/N 17280288N417CPCivil Air Patrol · Maxwell Afb, ALBuilt 2017 · S/N 18283025N417DDSc Flyers Inc · Wilmington, DEBuilt 2002 · S/N 18281169N417ERBrunner Aerospace LLC · Georgetown, TXBuilt 2014 · S/N 172S11445N417ESPearce James R · Germantown, TNBuilt 1997 · S/N 18280082N417JMTulsa Aviation Partners LLC · Tulsa, OKBuilt 2000 · S/N 18280837N417PDDagenais Paul Robert · Escanaba, MIBuilt 2021 · S/N T20609632N417RGWagner Aviation LLC · Laura, OHBuilt 1998 · S/N 18280231N4183NEndeavour Flight Training Inc · Miami, FLBuilt 1998 · S/N 18280150N418DMMria LLC · Phoenix, AZBuilt 2015 · S/N 18282418N418ESWright Aero Inc · Saint Cloud, MNBuilt 1998 · S/N 17280358N418WRBeegles Aircraft Service LLC · Greeley, COBuilt 1997 · S/N 18280034N4190PChaleff George S · Johnson, VTBuilt 1998 · S/N 17280620N4190VAtp Aircraft 2 LLC · Wilmington, DEBuilt 1998 · S/N 17280626N41912Eastern Kentucky University · Richmond, KYBuilt 1998 · S/N 17280628N4193RHunter Jeffrey Jay · Shreveport, LABuilt 1998 · S/N 17280636N4193YVan Dorpe Ross · Saint Charles, ILBuilt 1998 · S/N 18280359N4195EHusky Central LLC · Hugo, OKBuilt 1998 · S/N 18280363N4195RPlain LLC · Traverse City, MIBuilt 1998 · S/N 18280364N4196DCub Club Incdba · Fort Myers, FLBuilt 1999 · S/N 18280461N4196GProuse Craig H · Groveland, CABuilt 1998 · S/N 18280367N4197QSumner Properties LLC · Somersworth, NHBuilt 1998 · S/N 18280370N4197XBarr Air Patrol LLC · Mesquite, TXBuilt 1999 · S/N 18280449N4199TEnga James Craig · Madison, SDBuilt 1998 · S/N 18280372N419CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12348N419CSGarza Richard · Monterey, CABuilt 2016 · S/N 18282419N419EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2019 · S/N 172S12278N419FRAtp Aircraft 8 LLC · Wilmington, DEBuilt 2014 · S/N 172S11446N419JARaw Aviation LLC · Wichita, KSBuilt 2007 · S/N 18281885N41DLLdair Inc · Roanoke, VABuilt 2002 · S/N 18281142N42004Haskell Airport Inc · Coweta, OKBuilt 1999 · S/N 18280446N42007Southeastern Oklahoma State University · Durant, OKBuilt 1999 · S/N 17280744N4202LAa-Aero LLC · Fairfield, NJBuilt 1999 · S/N 17280747N4203PHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1999 · S/N 17280748N42058State Of North Carolina · Raleigh, NCBuilt 1998 · S/N 18280441N420CSSugar Lips Aviation LLC · Kalispell, MTBuilt 2005 · S/N 18281650
Back to AD 2003-24-13