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.

N919WCCarroll Walter · Villa Hills, KYBuilt 2019 · S/N T20609580N919ZATextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2025 · S/N 172S13350N91CSSkye Furniture Inc T/A Sky Aviation · Mechanicsville, VABuilt 2023 · S/N T20609755N91CYVan Bortel Aircraft Inc · Arlington, TXBuilt 2023 · S/N T18209102N91FFFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 172S12951N91FRJanie Air Inc · Roseville, CABuilt 2008 · S/N T18208859N91FSEastern Kentucky University · Richmond, KYBuilt 1997 · S/N 17280302N91HAHoneybee Air LLC · Newark, NJBuilt 2000 · S/N 18280913N91PFSkyline Solutions Inc · Deland, FLBuilt 2006 · S/N 172S10302N92004Oklahoma State University · Stillwater, OKBuilt 2012 · S/N 17281621N9200BChristiansen Aviation LLC · Wilmington, DEBuilt 2012 · S/N 17281620N9202UOklahoma State University · Stillwater, OKBuilt 2012 · S/N 17281622N920BWWilliams Rebecca J · Alto, NMBuilt 2001 · S/N 18280979N920CFWingsleasing LLC · Wichita, KSBuilt 1997 · S/N 17280112N920CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8341N920CYAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2015 · S/N T20609202N920EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2020 · S/N 172S12512N920MAPerry Castonguay Farms Inc · Omega, OKBuilt 1999 · S/N 18280628N920MTAcron Aviation Academy Inc · Sanford, FLBuilt 2006 · S/N 172S10214N920NCState Of North Carolina · Raleigh, NCBuilt 2000 · S/N 18280920N920TAAtp Aircraft 4 LLC · Wilmington, DEBuilt 2004 · S/N 17281206N920WBJet Air Inc · Iowa City, IABuilt 2008 · S/N 172S10837N921BBNorthwestern Michigan College · Traverse City, MIBuilt 2024 · S/N 172S13232N921CTN921ct LLC · Elkton, KYS/N 18281220N921EZAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2000 · S/N 172S8499N921KSWilliams Scott Thomas · Lake Havasu, AZBuilt 2006 · S/N T20608693N921LSNg Research · Manassas, VAS/N T20608976N921PJbt Legacy LLC · Ocklawaha, FLBuilt 2025 · S/N T20609814N921TAAtp Aircraft 4 LLC · Wilmington, DEBuilt 1997 · S/N 17280244N921UN921un Ventures LLC · Mercer Island, WABuilt 2004 · S/N T20608501N92228Dhs Operations LLC · Wilmington, DEBuilt 2014 · S/N 172S11498N9222HDhs Operations LLC · Wilmington, DEBuilt 2014 · S/N 172S11497N9223CDhs Operations LLC · Wilmington, DEBuilt 2014 · S/N 172S11499N9223EDhs Operations LLC · Wilmington, DEBuilt 2014 · S/N 172S11500N9223XDhs Operations LLC · Wilmington, DEBuilt 2014 · S/N 172S11501N92264Dhs Operations LLC · Wilmington, DEBuilt 2014 · S/N 172S11502N92266Dhs Operations LLC · Wilmington, DEBuilt 2014 · S/N 172S11503N9229FCooke John W III · Carthage, TXBuilt 1997 · S/N 17280294N922BCTanaka Akira · Torrance, CAS/N T18208121N922CPCivil Air Patrol · Maxwell Afb, ALBuilt 2001 · S/N 172S8911N922CSWorm Rudolf Heiko · Saint Petersburg, FLBuilt 2021 · S/N T20609622N922LHClover Park Technical College · Lakewood, WABuilt 2026 · S/N 172S13554N922MKNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282195N922TAAtp Aircraft 4 LLC · Wilmington, DEBuilt 1997 · S/N 17280249N9230YDhs Operations LLC · Wilmington, DEBuilt 2014 · S/N 172S11505N923AZN923az LLC · Miami, FLBuilt 2025 · S/N 172S13280N923CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 18283127N923CSGlobal Aircraft Leasing Inc · Wilmington, DEBuilt 2021 · S/N T20609623N923CTBragdon Emil · Fort Worth, TXS/N 172S8663N923DBGrenville Andrew · Decatur Island, WABuilt 2002 · S/N 18281087
Back to AD 2003-24-13