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.

N6191APearson Aero Solutions LLC · Dallas, GABuilt 2008 · S/N T18208862N6193CAirspeed Mammography Certifications LLC · Olympia, WABuilt 2008 · S/N 18282072N6193DDe Anza Building And Maintenance Inc · Los Altos, CAS/N 18281394N6193MFreiesleben Thomas K · Brookfield, WIBuilt 2008 · S/N 18282058N6193RAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2008 · S/N 18282061N61942Middle Village Enterprises LLC · Maspeth, NYBuilt 2008 · S/N 172S10772N61944Kaitooth Flight Club LLC · Kalispell, MTBuilt 2008 · S/N T20608867N61948Ac Ag Management LLC · Johnson, KSBuilt 2008 · S/N T20608868N6194VChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10771N61958Hff Leasing LLC · San Diego, CABuilt 2008 · S/N 17281541N61959Scandinavian Aviation Academy Inc · El Cajon, CABuilt 2008 · S/N 17281542N6195CRoberts Aviation LLC · Acworth, GABuilt 2008 · S/N T20608871N6195SRehg Robert F · Parker, COBuilt 2008 · S/N T18208887N6196GFirst Air Service LLC · Show Low, AZBuilt 2004 · S/N 18281397N6196PChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10754N6196XPrecheck General LLC · Alamogordo, NMBuilt 2008 · S/N T18208882N6197FRed Baron Aeroplanes LLC · Eaton, COBuilt 2008 · S/N T18208889N6197ZClermont Management Services Inc · Marietta, GABuilt 2004 · S/N 18281398N61984Tru Flight Materials LLC · Wilmington, DEBuilt 2008 · S/N T18208899N61987Twilight Flying LLC · Lafayette, LAS/N T18208900N6198NChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10792N6199SKilo Tango Aviation LLC · Watford City, NDBuilt 2004 · S/N T18208269N6199VCasperson Jeffrey Lynn · Clintonville, WIBuilt 2008 · S/N T18208898N619CBBeers Aviation LLC · Cedar, MIBuilt 1999 · S/N T2068006N619CTCoast Flight Training And Management Inc · San Diego, CABuilt 2009 · S/N 172S10937N619EREmbry-Riddle Aeronautical University · Prescott, AZBuilt 2021 · S/N 172S12749N619SPJet Air Inc · Iowa City, IABuilt 2000 · S/N 172S8608N619THAce Aviators LLC · Logan, UTBuilt 2006 · S/N 172S10343N619WAMckee John D · Dallas, TXBuilt 2004 · S/N T18208339N619WCHansford Mark T · Blue Ridge, GABuilt 2001 · S/N 18280993N61BGGray Skyhawk LLC · Fredericksburg, TXBuilt 2023 · S/N T18209121N61BXAviation Trust Co Trustee · Oklahoma City, OKBuilt 2005 · S/N T18208404N61CEBarr Air Patrol LLC · Mesquite, TXBuilt 1998 · S/N 18280321N61HSCebuhar Phillip Joseph · Inola, OKBuilt 2006 · S/N 18281856N61RRAap Holdings LLC · Montana City, MTBuilt 2005 · S/N T20608550N61USLakes Aviation LLC · Lakewood, ILBuilt 2001 · S/N 18280935N61WTMonmouth Area Flying Club Inc · Lakewood, NJBuilt 2005 · S/N 172S9818N6200DLundgren Mark C · Philipsburg, MTBuilt 2004 · S/N T18208275N6201APhenix Transportation LLC · Sheridan, WYBuilt 2004 · S/N T18208281N6201UFlashley Flies LLC · Menlo Park, CABuilt 2008 · S/N T20608881N62030Aht Aviation LLC · Doral, FLBuilt 2008 · S/N 18282096N62048Gv Air Inc · Medford, ORBuilt 2008 · S/N T20608887N6206Maunder Mark · Eastsound, WABuilt 2024 · S/N T20609757N6206XVan Bortel Aircraft Inc · Arlington, TXBuilt 2008 · S/N T20608900N6208CMustang Sally Aviation LLC · Camden, SCBuilt 2008 · S/N 172S10820N620EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13051N620HPDepartment Of Public Safety · Norman, OKBuilt 2004 · S/N T20608461N620JASilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2000 · S/N 172S8638N620SPGulf Coast Aviation LLC · New Orleans, LABuilt 2000 · S/N 172S8610N620WTStilley David · Flagstaff, AZBuilt 1999 · S/N 18280460
Back to AD 2003-24-13