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.

N2108LSoutheast Aircraft Leasing LLC · Jacksonville, FLBuilt 2004 · S/N 172S9605N2108ZPinnacle Aviation Services Inc · Encinitas, CABuilt 2004 · S/N 17281207N2109JRaf Ks LLC · Wichita, KSBuilt 2007 · S/N T20608717N2109LCaban-Loperena Jumil · Moca, PRBuilt 2004 · S/N 172S9609N210BCDurant Bruno Gerard · Coalmont, TNBuilt 1998 · S/N 18280308N210HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2002 · S/N 172S9040N210SUOhio State University · Columbus, OHBuilt 2020 · S/N 172S12431N21147Woolf Sarah Clark · Fresno, CABuilt 2004 · S/N T18208234N2114QJet Air Inc · Iowa City, IABuilt 2004 · S/N 172S9616N2114RPower Michael L · Bend, ORBuilt 2004 · S/N T18208226N2114UBravo Zulu Aviation LLC · Torrance, CAS/N 172S9618N2115KLiprie Randal C · Lake Charles, LABuilt 2004 · S/N 18281322N21180L&W Leasing LLC · Murfreesboro, TNS/N 172S9624N2118ASouth Dakota Highway Patrol · Pierre, SDBuilt 2004 · S/N T20608451N2118JLamb Chops Inc · Bakersfield, CABuilt 2004 · S/N T18208238N2118LIasco Flight Training Inc · Redding, CABuilt 1999 · S/N 17280676N21198Jackie Hood Farms LLC · Moulton, ALBuilt 2005 · S/N 18281647N2119EMid-Island Air Service Inc · Ronkonkoma, NYBuilt 2004 · S/N 17281212N2119QMustang Sally Aviation LLC · Camden, SCBuilt 2004 · S/N 172S9623N211FJFox Point Airways LLC · Sheridan, WYBuilt 2006 · S/N T20608673N211FTUniversity Of The South · Sewanee, TNBuilt 2021 · S/N 172S12774N211GTB & B Crane Service LLC · North Myrtle Beach, SCBuilt 2011 · S/N T20609008N211MRPowerbelt LLC · Glendale, CABuilt 2000 · S/N 18280813N211TDChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 172S8524N21200Paramus Flying Club Inc · Fairfield, NJBuilt 2005 · S/N 18281732N21212Sale Reported · Phoenix, AZSale reported, canceledBuilt 2007 · S/N 172S10441N2121FSouth Dakota State University · Brookings, SDBuilt 2007 · S/N 172S10437N2121XTaylor Commercial Properties LLC · Jackson, TNBuilt 2004 · S/N 18281480N2122MHalsted Aviation LLC · West Chicago, ILBuilt 2007 · S/N 172S10442N2122ZObrien Air LLC · Prescott, AZBuilt 2004 · S/N T18208242N2123EDream Flights LLC · Brewton, ALBuilt 2004 · S/N 18281331N2123YPalin Investments 3 LLC · Vancouver, WABuilt 2007 · S/N 18281893N2125ACable Thomas G · Rockford, MIBuilt 2003 · S/N 18281230N2125MNfh Aviation LLC · Pikeville, KYBuilt 2000 · S/N 17280905N21263Suburban Air Corp · Castro Valley, CABuilt 2003 · S/N 172S9429N2126FVista Aviation Inc · Pacoima, CABuilt 2007 · S/N 172S10458N21276Schrager Daniel L Trustee · Concord, MABuilt 2003 · S/N 172S9433N2128YE-Cubed Industries LLC · Big Piney, WYBuilt 2003 · S/N T18208206N2129CFlot Group LLC · Apex, NCBuilt 2003 · S/N 172S9436N2129JRidgeline Assets LLC · Wilmington, DEBuilt 2003 · S/N 172S9441N212BSEuros Aircraft Leasing LLC · College Station, TXBuilt 1999 · S/N 172S8243N212CFWest Coast Equipment Leasing LLC · Englewood, COBuilt 1998 · S/N 17280418N212FSTrinity River Lumber Co · Weaverville, CAS/N T20609720N212ZSkies The Limit LLC · Fuquay Varina, NCBuilt 2016 · S/N T20609228N2130FSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2003 · S/N 172S9419N2131ATru Flight Materials LLC · Wilmington, DEBuilt 2005 · S/N 18281649N2131UAgh Property Investments Inc · Key West, FLBuilt 2003 · S/N 18281227N21326Ttf Flying LLC · Anderson, SCBuilt 2007 · S/N 18281897N2132WWheeler Equipment Leasing LLC · Gainesville, GABuilt 2003 · S/N 172S9421N21331J-Air Eagle LLC · San Antonio, TXBuilt 2007 · S/N 18281898
Back to AD 2003-24-13