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.

N9522ADunn Legacy Inc · Saint Petersburg, FLBuilt 1998 · S/N 17280411N9522SSnohomish Flying Service Inc · Snohomish, WABuilt 1998 · S/N 17280432N95242Kane Aviation Holdings LLC · Bernardsville, NJBuilt 1998 · S/N 18280146N9525DFlying Neutrons LLC · Lebanon, OHBuilt 1998 · S/N 18280147N9525PGeorgetown Flying Club LLC · Pawleys Island, SCBuilt 1997 · S/N 18280177N9525VFirst Eclipse Ltd · Richmond, VABuilt 1998 · S/N 17280315N95260Barr Air Patrol LLC · Mesquite, TXBuilt 1998 · S/N 18280182N9526GAtlas Aviation Tampa Inc · Tampa, FLBuilt 1998 · S/N 17280434N9528WWings Over Texas Holdings LLC · Denton, TXBuilt 1998 · S/N 17280467N9529WFlight Operations Aircraft LLC · Wilmington, DEBuilt 1998 · S/N 17280470N952JAHuerta Holdings Inc · Santa Ana, CABuilt 2007 · S/N 172S10474N952SCMike Charlie Aviation LLC · Scottsdale, AZBuilt 2014 · S/N 172S11406N9530HHorizon Aircraft Sales & Leasing Inc · Chesapeake, VABuilt 2013 · S/N 172S11295N95314Menagerie Enterprises Inc · Denison, TXBuilt 2014 · S/N 172S11403N9531DAtp Aircraft 4 LLC · Wilmington, DEBuilt 1999 · S/N 17280473N9533GSmith James R · Delaware, NJBuilt 1998 · S/N 18280354N9536DCalifornia Management And Consulting LLC · North Hollywood, CABuilt 1998 · S/N 17280481N9536FTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 20608336N9537QBoeing Empolyees Flying Assn · Renton, WABuilt 1998 · S/N 17280483N9539DBohemia Aviation LLC · Niagara, WIS/N 18280184N9539LSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1998 · S/N 18280185N9539PNichols Aviation LLC · Middletown, DEBuilt 1998 · S/N 18280186N9539RAdams Scott A · Glenview, ILS/N 18280172N953ACConeburripul Corp · Miami, FLBuilt 1998 · S/N 17280549N953AFRegistration Pending · Addison, TXRegistration pendingBuilt 2026 · S/N 172S13567N953RRJcb Aviation LLC · Paragould, ARBuilt 2007 · S/N 18282009N9542WState Of North Carolina · Raleigh, NCBuilt 1998 · S/N 18280136N9543FEvans Michael · Punta Gorda, FLBuilt 1998 · S/N 18280219N9543GHi Low Aviation LLC · Alpine, TXBuilt 1998 · S/N 18280245N9543PHerr Bridget J · Boles, ARBuilt 1999 · S/N 17280644N9544QPhoto Services Unlimited · Augusta, MEBuilt 1998 · S/N 18280291N9544SJourney Holdings LLC · Reform, ALBuilt 1998 · S/N 18280149N9545FEastern Cincinnati Aviation Inc · Batavia, OHBuilt 1998 · S/N 17280380N9547WWatch Ya Head Aviation I LLC · Zionsville, INBuilt 1998 · S/N 17280508N9548WZh Aviation LLC · Wilmington, DEBuilt 1999 · S/N 17280512N9549FJogger Industries LLC · Sherwood, NDBuilt 1998 · S/N 17280514N954ACAir Future Airways Corp · Miami, FLBuilt 1997 · S/N 17280053N954FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13279N954JAAdvanced Aviation Group LLC · Frederick, MDS/N 172S10500N954MGPirolo Michael · Orange, CABuilt 2008 · S/N T18208890N954MLLakeshore Aviation LLC · Denver, NCBuilt 2024 · S/N T18209149N9550GCopper Skies Aviation LLC · Mesa, AZBuilt 1998 · S/N 17280516N9550QDecatur Aero Club Inc · Decatur, ILBuilt 1998 · S/N 17280517N9550SBald Eagle Enterprises Inc · Nashville, TNBuilt 1999 · S/N 17280758N9551WBcbc Aero Services LLC · Dover, DEBuilt 1998 · S/N 18280207N9552AAmeriflyers Of Texas Inc · Addison, TXBuilt 1998 · S/N 17280531N9552RCauv LLC · Cincinnati, OHBuilt 1998 · S/N 18280167N9553ATitusville Aero Club Inc · Titusville, PABuilt 1998 · S/N 17280376N9553SHunters Adventures LLC · Kennesaw, GABuilt 1998 · S/N 18280254N9554TOceanic Airlines LLC · Portsmouth, NHBuilt 1999 · S/N T20608003
Back to AD 2003-24-13