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.

N21339Pilots Flying School LLC · Englishtown, NJBuilt 2003 · S/N 172S9551N2133LGietzen Jeff · Seattle, WABuilt 2003 · S/N 18281287N2134MChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9552N21359Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N T18208687N2135DN2135d LLC · Eustis, FLBuilt 2007 · S/N 18281899N2135KJet Air Inc · Iowa City, IABuilt 2003 · S/N 172S9556N2135SEastern Cincinnati Aviation Inc · Batavia, OHBuilt 2003 · S/N 172S9558N21369Smk Holdings LLC · Sandy, UTBuilt 2003 · S/N 18281292N2137H3 Pandas LLC · Farmington, NMBuilt 2007 · S/N T20608721N2138BSouthwest Aviation Enterprises · Haslet, TXBuilt 2003 · S/N T20608437N2138WChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9561N21394Long Island Aviators LLC · Seaford, NYBuilt 2007 · S/N 172S10449N2139UJust Plane Stuff Inc · Jackson, MSBuilt 2007 · S/N 172S10448N213AAAir Mac Ventures LLC · Houston, TXBuilt 2007 · S/N 172S10511N213CMBollingberg Kurt O · Cathay, NDBuilt 1997 · S/N 18280046N213GGShortcut LLC · Kihei, HIBuilt 2002 · S/N 18281130N213LPT31 Aviation LLC · Dallas, TXBuilt 2004 · S/N 18281312N213NBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2020 · S/N 172S12572N213SMArrowhawk Imaging LLC · Morgantown, WVBuilt 2003 · S/N 20608206N21413Botwinick Jeffrey Richard Patrick · Syracuse, NYBuilt 2003 · S/N 18281273N2141DFoturis Inc · Kingston, PABuilt 2003 · S/N 18281297N2141YAnson Air LLC · Sugar Land, TXBuilt 2003 · S/N 172S9562N2142SDbm Farms Inc · Clarksdale, MSBuilt 2003 · S/N T18208224N2144VAnson Air LLC · Sugar Land, TXBuilt 2003 · S/N 18281276N21454Textron Aviation Inc · Wichita, KSBuilt 2003 · S/N 18281228N2145JSchool Of Missionary Aviation Technology · Ionia, MIBuilt 2003 · S/N 172S9418N2145RCabernet To Cactus LLC · Scottsdale, AZBuilt 2003 · S/N T20608427N2145TCff Air Inc · Wilmington, DES/N 17281174N2145ZTextron Aviation Inc · Wichita, KSS/N T18208204N2146AZhukov Igor · Live Oak, FLBuilt 2003 · S/N 18281265N2146CVan Bortel Aircraft Inc · Arlington, TXBuilt 2003 · S/N T18208222N21483Lima-001 LLC · Muscatine, IABuilt 2003 · S/N 172S9515N2148WSav LLC · Shelton, WABuilt 2003 · S/N T20608421N21493Macmillan Robert J · Merritt Island, FLBuilt 2003 · S/N T20608423N214BKS&N Pearl LLC · Port Orange, FLBuilt 2021 · S/N 18283138N214CFKlug Air LLC · Wilmington, DES/N 18281056N214FAGeorgia Forestry Commission · Macon, GABuilt 2003 · S/N 18281214N214GCCloud Robert Trustee · Kerrville, TXBuilt 2024 · S/N 18283286N214GZAerospring Leasing LLC · Wasilla, AKBuilt 2005 · S/N 172S9862N214LE3 Weens LLC · Hoschton, GABuilt 2004 · S/N 18281416N214MHShadow Ventures LLC · Chesapeake, VAS/N T20608214N214VWMilford Aviation LLC · Greensburg, INBuilt 2008 · S/N T20608837N2150GMsb Aviation LLC · Rockvale, TNS/N 172S9516N2150KCarey David John II · Mccall, IDBuilt 2003 · S/N T20608407N2151XWcps Aviation LLC · Marietta, GABuilt 2003 · S/N 18281233N2151YMtjc Services LLC · Chester, WVBuilt 2003 · S/N T18208207N2152KSkylane Flights LLC · West Palm Beach, FLBuilt 2007 · S/N 18281908N2152SMoore Aviation Inc · Beaver Falls, PABuilt 2003 · S/N 172S9444N2152VJameson Paul E · Palm Coast, FLBuilt 2003 · S/N 172S9445N2153AAcuna Edward DBA · Pearland, TXBuilt 2003 · S/N 172S9448
Back to AD 2003-24-13