OpenAirDocs.org
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.

N1823CA&E Flying Club Of Los Angeles · Hawthorne, CABuilt 1998 · S/N 18280171N1823EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12171N1825EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12172N18260Atc Trucking Inc · Miami, FLBuilt 2005 · S/N T20608543N1827AShmily Aviation LLC · Tampa, FLBuilt 2005 · S/N 18281615N18282House John R · Roseville, CABuilt 2024 · S/N T18209136N1828EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12173N1828MCampbell Larry Lance · White Lake, MIBuilt 2000 · S/N 18280893N182ABFoyhwg Inc · Holbrook, NYS/N 18280023N182AHShelby Ronnie F · Comanche, OKBuilt 2011 · S/N T18209037N182AMScavella George A Jr · Hauppauge, NYBuilt 1998 · S/N 18280116N182AXN182ax LLC · Newark, DEBuilt 2002 · S/N 18281072N182BGSuburban Air Corp · Castro Valley, CAS/N 18281536N182CKDowning Richard C · Arlington, TXBuilt 1997 · S/N 18280018N182DDGulf Coast Helicopters Inc · Pearland, TXS/N 18280063N182DPCopeland Aviation LLC · Cedar Park, TXBuilt 2002 · S/N 18281124N182DUAlba Alfonso Jose Munk · Key Biscayne, FLS/N T18208374N182EERegistered aircraftBuilt 1998 · S/N 18280295N182EHHolland Max Eugene · Nebo, NCBuilt 2025 · S/N 18283332N182ELElmore Donald B · Orange Beach, ALBuilt 1997 · S/N 18280009N182EMPxw Services · Manassas, VABuilt 2010 · S/N 18282233N182FNSumner Investments LLC · Denham Springs, LABuilt 1997 · S/N 18280004N182GAGaman LLC · Tulsa, OKBuilt 2006 · S/N T18208587N182GFGormley Lane Martin · Stanwood, WAS/N 18280058N182GHTroy-Oakland Pilots Flying Club Inc · Troy, MIBuilt 1998 · S/N 18280003N182GMBaker Charles W · Lake Worth, FLBuilt 2005 · S/N 18281635N182GNWorthington Greg · San Francisco, CABuilt 2002 · S/N T18208112N182HEBronx Girl LLC · Cedar City, UTBuilt 2018 · S/N 18283054N182HFCook Daniel E · Gulf Breeze, FLBuilt 2005 · S/N 18281586N182HXSkylane Holdings LLC · Kilgore, TXS/N 18281141N182HZElings Heath R · Conrad, MTBuilt 2002 · S/N T18208129N182JDRegistered aircraftBuilt 2000 · S/N 18280770N182JSJohn W Spurlock Md Ltd · Bethlehem, PABuilt 1999 · S/N 18280655N182JZMercer Fraser Co · Eureka, CAFirst renewal noticeBuilt 2004 · S/N T18208258N182KGKeefe Patrick M · Watersmeet, MIS/N 18280020N182KHDowning Billy G · Imboden, ARBuilt 1998 · S/N 18280246N182LKEllison William G · Telluride, COS/N T18208182N182LMCommercial Diving Inc · Melbourne, FLBuilt 2004 · S/N 18281412N182LPTristar Aviation Management Nevada LLC · Las Vegas, NVBuilt 2006 · S/N T18208572N182LUTvpx Aircraft Solutions Inc Owner Trustee · North Salt Lake, UTBuilt 2000 · S/N 18280793N182MASterling Flight Training LLC · Jacksonville, FLBuilt 2015 · S/N 172S11590N182MCOwle Aviation LLC · Mount Vernon, WABuilt 2007 · S/N T18208761N182MEMcfann Aiden J · Timnath, COBuilt 2002 · S/N T18208133N182MGTurnidge Austin Michael · Seattle, WABuilt 2001 · S/N T18208046N182MUTru Flight Materials LLC · Wilmington, DEBuilt 2004 · S/N T18208334N182MVCarpe Diem Aviation LLC · Edgartown, MABuilt 2007 · S/N 18281917N182MWMcadam Brad · Fredericksburg, VABuilt 2024 · S/N 18283281N182NWNorthwestern Michigan College · Traverse City, MIBuilt 2010 · S/N 172S11043N182PADecicco John Anthony · Clovis, CABuilt 2008 · S/N T18208863N182PFKeehner Sean W Trustee · Pasadena, MDBuilt 2012 · S/N 18282327
Back to AD 2003-24-13