AD 2003-13-10

Registered aircraft · 1,011

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-13-10')
    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-13-10')
  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.

N14807Hammock Flying Service Inc · Smithville, ARBuilt 1972 · S/N 25078N148AWAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2008 · S/N 53879N149PDAdministracion De Los Servicios Generales · San Juan, PRS/N 54143N14HXHelicopter Express LLC · Chamblee, GABuilt 1997 · S/N 53184N150AMAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 54046N152AMAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 54049N153PAGm Leasing Company LLC · Broussard, LABuilt 2013 · S/N 54455N155TVU S Helicopters Inc · Marshville, NCBuilt 1990 · S/N 51339N157BAAirmart Inc · Lexington, KYBuilt 1986 · S/N E-2339N158ABBell Textron Inc · Fort Worth, TXBuilt 1970 · S/N 68-16810N15MXBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 54327N160AMAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 54038N1612Gm Leasing Co LLC · Broussard, LABuilt 1996 · S/N 53044N163RLRotorcraft Leasing Company LLC · Broussard, LAS/N 53163N165SPSouthern Utah University · Cedar City, UTBuilt 2000 · S/N 53458N168TBSouthwest Aviation Enterprises · Haslet, TXBuilt 2000 · S/N 53434N169RLRotorcraft Leasing Co LLC · Broussard, LABuilt 1993 · S/N 52063N16SPState Of New York · Albany, NYBuilt 2002 · S/N 53532N17238Bennett Aviation LLC · Lafayette, LABuilt 1991 · S/N 51492N173MSFlorida Keys Mosquito Control District · Marathon, FLBuilt 2000 · S/N 52256N173RLRotorcraft Leasing Co LLC · Broussard, LABuilt 1993 · S/N 52066N173SFGm Leasing Company LLC · Broussard, LAS/N 53978N173SJAnthony Ghidossi Chemical LLC · Marysville, WABuilt 1981 · S/N 5170N175HAShearer John · The Dalles, ORBuilt 1978 · S/N HA3075N175JKJk Aviation LLC · Kerman, CABuilt 2000 · S/N 0143FFN176ETSan Juan Aviation LLC · Wilmington, DEBuilt 1980 · S/N 760095N179RLRotorcraft Leasing Co LLC · Broussard, LABuilt 1994 · S/N 52102N179SFN179sf LLC · Chandler, AZBuilt 1996 · S/N 53196N17DEBell Textron Inc · Fort Worth, TXBuilt 2006 · S/N 53700N17SPNew York State Police · Albany, NYBuilt 2000 · S/N 53444N17TWWhirlybird Aviation LLC · Bend, ORBuilt 1998 · S/N 52213N181MAMinuteman Aviation Inc · Missoula, MTBuilt 2007 · S/N 53789N183PSkytech Cc LLC · Santa Rosa Beach, FLBuilt 2000 · S/N E-3346N184AMAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 54044N184SFGm Leasing Co LLC · Broussard, LABuilt 1996 · S/N 53087N189AMAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 54047N18BHAbc Helicopters Inc · Jefferson, WIBuilt 1997 · S/N 53217N18SPState Of New York · Albany, NYBuilt 2002 · S/N 53533N1903ADale County Sheriffs Office · Ozark, ALBuilt 2001 · S/N 53475N190AETextron Financial Corp · Wichita, KSBuilt 2014 · S/N 54511N192RLRotorcraft Leasing Co LLC · Broussard, LABuilt 1996 · S/N 52192N193AMAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 54004N194TAJsj Aviation LLC · Helena, MTBuilt 1991 · S/N 51542N1957ZDakota Rotors LLC · Custer, SDBuilt 1994 · S/N 52109N196TAHelo N426ha LLC · Richmond, VABuilt 2009 · S/N 53925N19HXPremier Aircraft Services LLC · Bakersfield, CABuilt 1984 · S/N 51096N1MHIsaiah 40v31 LLC · Orlando, FLBuilt 2013 · S/N 54398N201PAAsa Security LLC · Anchorage, AKBuilt 1992 · S/N 51567N202MHSouthern Utah University · Cedar City, UTBuilt 1993 · S/N 52057N202PHCoastal Air Services Inc · Panama City, FLBuilt 1983 · S/N 51076
Back to AD 2003-13-10