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.

N14669Lowman Henry B Trustee · El Granada, CABuilt 2007 · S/N 172S10444N1468EMachado Donald C Jr · Honolulu, HIBuilt 2007 · S/N 172S10446N146FAcrehood Air LLC · St Augustine, FLBuilt 2004 · S/N 18281437N146NEAngle Mark W · Lake Orion, MIBuilt 1998 · S/N 18280221N146TCN146tc LLC · Minneapolis, MNBuilt 2002 · S/N 172S9146N146WHAmick Ralph O · Hatteras, NCS/N 18280304N1472PFlight School Of Texas LLC · Wilmington, DEBuilt 2005 · S/N 172S9899N147AJAviation Solutions LLC · Louisville, KYBuilt 2006 · S/N T18208482N147CETwin P Aviation LLC · Fort Worth, TXBuilt 2013 · S/N T18209098N147GWAllen Air LLC · Creola, ALBuilt 2011 · S/N T20609022N147HAPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10219N147HBCooley Timothy · Gilbert, AZBuilt 2017 · S/N 18283011N147PASetki Air LLC · Wilmington, DEBuilt 2024 · S/N T20609772N147SASteeda Autosports Inc · Pompano Beach, FLBuilt 2014 · S/N T20609155N14814Florida Flight Training Center Inc · Venice, FLBuilt 2007 · S/N 172S10451N14829Ssea Properties LLC · Double Oak, TXBuilt 2007 · S/N 172S10585N1483CWang Helin · Dana Point, CABuilt 2005 · S/N T18208419N1483L83l Ventures LLC · San Carlos, CABuilt 2007 · S/N 18281960N1484BMann Aviation Inc · Long Beach, CABuilt 2007 · S/N 172S10452N1485CLiebowitz Alan · Sioux Falls, SDBuilt 2005 · S/N T18208421N1488CChristiansen Aviation LLC · Wilmington, DEBuilt 2022 · S/N 172S12896N1488TTanana Leasing LLC · Fairbanks, AKS/N T20608541N1489LBusiness Mens Flying Club Inc · Naperville, ILBuilt 2007 · S/N 18281901N148DWVantage Aviation USA LLC · Tampa, FLBuilt 2013 · S/N T20609091N148GHLattimore Partners LLC · Fort Worth, TXBuilt 2005 · S/N T18208417N148SMSarasota Westwind Flyers Inc · Sarasota, FLS/N 18280040N1492UD & S Aviation LLC · Spring, TXBuilt 2007 · S/N 18281962N1493RChaffin Alex · Fayetteville, ARBuilt 2005 · S/N 18281694N1496CSbma Services LLC · Mcclellan, CABuilt 2005 · S/N 18281693N149ABVarga Miklos · Helendale, CABuilt 2005 · S/N T18208372N149CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282190N149DWRbf Aero · Wilmington, DEBuilt 2013 · S/N T20609097N149FCDepartment Of Agriculture And Consumer Services · Tallahassee, FLBuilt 2017 · S/N 18283002N149GRJoemchem LLC · Sparta, TNBuilt 2007 · S/N T18208698N149LAColumbia Leasing LLC · Hillsboro, ORBuilt 2024 · S/N 172S13125N149MEMccrary Mike M · Fairhope, ALBuilt 2000 · S/N 18280721N149UDW Air LLC · Chicago, ILBuilt 2003 · S/N 17281185N14PVRogers Michael P · Neenah, WIBuilt 2003 · S/N 172S9528N14QWDinucci Mario · Auburn, CABuilt 2006 · S/N 18281760N14WGWest Coast Equipment Leasing LLC · Aurora, ORFirst renewal noticeBuilt 2019 · S/N 172S12415N14WLTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N T20609857N1502EElizbeth City State University · Elizabeth City, NCBuilt 2005 · S/N 172S9900N15031Young J D · Plano, TXBuilt 2007 · S/N T20608725N1507XGolf November Aero LLC · Sunnyvale, CABuilt 2005 · S/N 172S9903N150CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 18283268N150SUOhio State University · Columbus, OHBuilt 2015 · S/N 172S11565N150TESummit Air LLC · San Diego, CABuilt 2009 · S/N 172S10996N150TH150th Aero Flying Club · Morristown, NJBuilt 2003 · S/N 172S9453N151BSEvans Linda J · North Wales, PABuilt 2001 · S/N 18280934N151FCDepartment Of Agriculture And Consumer Services · Tallahassee, FLBuilt 2006 · S/N 18281874
Back to AD 2003-24-13