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.

N23655Redline Aviation LLC · Wilmington, DEBuilt 1998 · S/N 18280378N2365FBottorff Jon C · Fishers, INBuilt 1999 · S/N T20608102N2365JBrosius Michael W · North Platte, NEBuilt 1999 · S/N T20608099N2365NDulles Aviation · Bristow, VABuilt 1998 · S/N 18280373N2366GDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 18280379N2366MWestbank Fishing LLC · Kiln, MSBuilt 1999 · S/N 18280447N2366NKohnen Patrick Kennedy · Flagstaff, AZS/N 18280382N2366YAvco Patrol LLC · Lyndon, KSBuilt 1999 · S/N 18280539N23673National Training 1 LLC · Wilmington, DEBuilt 1998 · S/N 17280563N23675Atlanta Aviation Academy Inc · Lawrenceville, GABuilt 1999 · S/N 17280651N23676A&E Flying Club Of Los Angeles Inc · Hawthorne, CABuilt 1998 · S/N 18280324N23677Doering Jim · Arcadia, CABuilt 1998 · S/N 18280389N23678Warner Donald R · Milford, MIBuilt 2007 · S/N 172S10591N2367MPeterson Aviation LLC · Oregon, WIBuilt 1998 · S/N 18280386N2367X182 Jkp LLC · Fall River, MABuilt 1998 · S/N 18280252N2368GRegistered aircraftBuilt 1999 · S/N 18280541N2368SShane LLC · Wilmington, DEBuilt 1999 · S/N 18280390N2369KMgm Aviation LLC · Montara, CABuilt 1998 · S/N 18280394N2369ZDhs Operations LLC · Wilmington, DEBuilt 1999 · S/N 17280658N236SP83l Ventures LLC · San Carlos, CABuilt 1999 · S/N 172S8213N236TFChristiansen Aviation LLC · Wilmington, DEBuilt 2018 · S/N 172S12134N2370EPowers Thomas Jr · Westerly, RIS/N 18280540N2370FChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280618N2370JOrtega Aviation Services LLC · Wichita, KSBuilt 2005 · S/N 172S10100N2370WSall LLC · Mill Valley, CABuilt 1998 · S/N 18280405N2370XSouthwest Aircraft Enterprises · Haslet, TXBuilt 1999 · S/N T20608026N2371HSan Jose Aviation LLC · Mission, TXBuilt 1999 · S/N T20608060N23735Leighton Farms Ltd · Griswold, IABuilt 1999 · S/N 18280458N2373GCentral Iowa Aviation LLC · Ankeny, IABuilt 1998 · S/N 172S8073N2373KReading Aero Club Inc · Reading, PABuilt 1999 · S/N 172S8074N2373MChristiansen Aviation LLC · Wilmington, DEBuilt 2007 · S/N 172S10592N2373ZN3812q LLC · San Diego, CABuilt 1999 · S/N 172S8075N2374EN2374e LLC A Series Of Aero Lease LLC · San Antonio, TXBuilt 1999 · S/N 17280716N23756Sweet Fred A · Loves Park, ILBuilt 1998 · S/N 18280429N2375JBarr Air Patrol LLC · Mesquite, TXBuilt 1999 · S/N 18280451N2376RRegistered aircraftBuilt 1999 · S/N 18280431N2376VPeyrot Eric M · Summerland Key, FLBuilt 1998 · S/N 18280432N2376XMueller Howard W · Winston Salem, NCBuilt 1999 · S/N 18280433N2377PLammers William Scott · Deer Park, ILBuilt 1998 · S/N 18280434N2377YTerral William C · Farmerville, LABuilt 1998 · S/N 18280436N23781Paragon Air Group · Fort Worth, TXBuilt 1999 · S/N T20608017N23782Zylstra Cycle Co Inc · Ames, IAFirst renewal noticeBuilt 1999 · S/N 18280448N2378XState Of Utah · Salt Lake City, UTBuilt 1999 · S/N T20608023N2378YLindsey Aviation Services · Haslet, TXBuilt 1999 · S/N T20608025N23798Jet Air Inc · Iowa City, IABuilt 1998 · S/N 17280603N2379FWebster Douglas Clark · Las Vegas, NVBuilt 1999 · S/N T20608019N237AJSuo Anttila Ahti · Albuquerque, NMBuilt 2000 · S/N 18280794N237CADepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608239N237CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282348N237FBGomez Preston Andreas · Bismarck, NDBuilt 2007 · S/N 18281916
Back to AD 2003-24-13