OpenAirDocs.org
AD 2003-24-13

Registered aircraft · 7,866

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.

N1307CHouse Of Raeford Farms Inc · Rose Hill, NCBuilt 2006 · S/N 172S10337N1309GPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10342N1309MReny Donald Cyril Jr · League City, TXBuilt 2008 · S/N 18282050N130CPCivil Air Patrol · Maxwell Afb, ALBuilt 2014 · S/N T20609133N130DWAttoyac Air LLC · Gonzales, TXBuilt 2021 · S/N T20609662N130JAHagele Aviation LLC · Hillsboro, ORBuilt 2002 · S/N 172S9165N130MEPetersens Marine Services Corp · Ridge, NYBuilt 2000 · S/N 18280686N130SJAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1999 · S/N T20608130N13151F N A Aviation LLC · Wakefield, MABuilt 2006 · S/N 172S10344N1315BN1315b Aviation LLC · Wilmington, DEBuilt 2002 · S/N T18208147N1318QMustang Sally Aviation LLC · Camden, SCBuilt 2008 · S/N 172S10657N131AZSuraair Holdings Inc · Wilmington, DEBuilt 2012 · S/N 172S11165N131DLEscondido Aviation LLC · Marfa, TXBuilt 2007 · S/N T18208717N131DTAerownership North American Services Inc Trustee · Wilmington, DEBuilt 2017 · S/N T20609239N131WCVoigt Aviation Inc · Park Rapids, MNS/N 20608034N1322KCleared Into Bravo LLC · Sunnyvale, CABuilt 2006 · S/N 172S10345N1322YAlcyone Trust Corp Trustee · Wichita, KSBuilt 2008 · S/N T18208811N1322ZInternational Realty Group LLC · Bakersfield, CABuilt 2024 · S/N T18209134N1323DEl LLC · Center, COBuilt 2008 · S/N T20608805N1323KFlight Operations Aircraft LLC · Wilmington, DEBuilt 2006 · S/N 172S10348N1323NJohnston Jeffrey Heath · Midland, TXBuilt 2006 · S/N T18208665N1323XMustang Sally Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10367N13259Nuthatch Air Services LLC · New York, NYBuilt 2006 · S/N T18208663N1325DMontero Carlos · San Lorenzo, CABuilt 2006 · S/N T18208658N1325YDuty First Holdings LLC · Wichita, KSBuilt 2006 · S/N T18208660N1327EDeguerin Dick · Houston, TXBuilt 2006 · S/N T20608689N1327KLoveland Aviation LLC · Scottsdale, AZBuilt 2006 · S/N T20608690N1327NGulf Coast Aviation LLC · New Orleans, LABuilt 2006 · S/N 172S10380N1327ZN1327z LLC · Palm City, FLBuilt 2005 · S/N 172S9867N1328NFirst Agri Inc · Sudan, TXBuilt 2005 · S/N T18208403N13291Conspec Inc · Wichita, KSBuilt 2006 · S/N T20608694N1329DHewitson Enterprises Inc · Avenal, CABuilt 2006 · S/N T18208664N132MEPena Jairo · Catharpin, VABuilt 2000 · S/N 18280690N132PFAbove And Beyond Aviation LLC · Austin, TXBuilt 1997 · S/N 17280176N132PSU S Department Of The Interior · Boise, IDS/N 20608278N132VUPerformance Aircraft Sales Inc · Lincoln, NEBuilt 2003 · S/N 17281189N1330GNorth Plains Honey Co LLC · Bozeman, MTBuilt 2006 · S/N T20608696N1330NEdb Air Inc · Wilsonville, ORBuilt 2006 · S/N 172S10396N1331213312 LLC · Union Gap, WABuilt 2006 · S/N 172S10401N1333EEndeavour Flight Training Inc · Opa Locka, FLBuilt 2006 · S/N 172S10404N1338BSilver Creek Aviation Services · Fort Worth, TXBuilt 2011 · S/N 20608331N133CPCivil Air Patrol · Maxwell Afb, ALBuilt 2018 · S/N 172S12131N133VUPerformance Aircraft Sales Inc · Lincoln, NEBuilt 2003 · S/N 17281190N1341PN8075q LLC · Corpus Christi, TXBuilt 2007 · S/N 18281876N13433Seamoose Aviation LLC · Shelton, CTBuilt 2007 · S/N 18281878N1348LFlight World Inc · San Juan, PRBuilt 2005 · S/N 172S9939N134BChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9345N134DBBlue Skies27 LLC · Los Angeles, CABuilt 2000 · S/N 18280808N134DJH2k Farms LLC · Phoenix, AZBuilt 2019 · S/N 18283065N134GWFord Matthew L · Clayton, GABuilt 2002 · S/N T18208134
Back to AD 2003-24-13