JASC 5310
Service difficulty reports · 38,573
Reports filed under 5310 · Fuselage Main, Structure, newest first.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE jasc_code = '5310' ORDER BY difficulty_date DESC"
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.
SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE jasc_code = '5310' ORDER BY difficulty_date DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SDR SWAA095970Crease Beam · crackedDURING SCHEDULED 22Y CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 328, RBL 34. REMOVED AND REPLACED WEB PER SRM.SDR SWAA096318Door Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND R1 DOOR CENTER STUB FRAME CRACKED. REMOVED AND REPLACED FRAME PER SRM.SDR ZZDA2009260Door Frame · corrodedAFT CARGO DOOR JAMB HAS CORROSION. INSTALLED PERMANENT REPAIR AT AFT CARGO DOOR JAMB LOWER PAN SPLICE REPAIR AS PER B717 SRM 53-20-15 FIG 201 REPAIR 7.SDR AALA20090921TUL05Door Frame · crackedCRACK IN AFT CARGO DOOR FRAME WEBBING AT STA 1155. INSTALLED WEB DOUBLER PER AARD 53-10-00-24.SDR AALA20090921TUL04Door Frame · corrodedHEAVY CORROSION ON AFT CARGO DOOR FRAME STA 1155. INSTALLED C-CHANNEL DOUBLER PER EA MD-80-53-00-7477 DATED 9/16/09.SDR FDEA200909173363Skin · misinstalledMAIN CARGO AREA, STA 660, STR 4L, ABOVE STRINGER, RIVETS WITH NO SPACING. CUT OUT DAMAGED AREA OF STRAP, FABRICATED DOUBLER, TRIPLER, STRUCTURAL FILLER, 2 FILLERS, TEAR STRAP REPAIR, SHIMS, AND INSTALLED PARTS IAW SRM 51-30-2, 53-30-3, 51-30-5 AND 53-30-SDR DLM88091503Window Frame · damagedDURING HMV LIGHTNING STRIKE WAS FOUND ON FWD LWR FRAME WINDOW NR 43 BTW STA Y=617 AND 636.SDR DLM88091495Beam · corrodedDURING HMV EXFOLIATION CORROSION WAS FOUND ON DOOR JAMB LOWER BEAM STA 636 TO 693 AT C2. BEAM WAS REPAIRED IAW SRM 53-05 FIG 123.SDR DLM88091488Door Frame · corrodedDURING HMV CORROSION WAS FOUND ON LOWER C1 DOOR JAMB FROM STA Y=370-427. DOOR JAMB WAS REPLACED IAW SRM 53-05D FIG 804D.SDR SWAA095914Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND LT CREASE BEAM WEB CORRODED BETWEEN BS 400 TO BS 420. REPAIRED WEB PER SRM.SDR AALA20090916TUL13Stop Fitting · crackedCRACKED DOOR STOP FITTING AFT OF RIGHT LOWER PAD IN VAULT DOOR JAMB AT STATION 1338. REPLACED DOOR STOP FITTING UNDER SRM 51-30-2.SDR ZZDA2009221Door Frame · corrodedFWD CARGO DOOR JAMB AREA HAS CORROSION FROM STA 370-427. CUT OUT DAMAGED LOWER SECTION AND INSTALLED NEW LOWER SECTION AND SPLICES, REPAIR PER REF B717 SRM 53-20-15 REPAIR 6.SDR FDEA200909123289Beam · crackedCTR CARGO COMPT SUMP AREA FOUND BEAM CRACKED AND BROKEN. REPAIRED AREA IAW SRM 53-60-00 VOL I, FIG 3.SDR A6WA200940594Crossbeam · corrodedCORROSION ON UPPER FLANGE OF CROSSBEAM AT FS 349 AND RBL 45. CORROSION REMOVED IAW REO 601R-53-21-1047.SDR ZZDA2009239Door Frame · corrodedAFT CARGO COMPARTMENT DOOR JAMB CORRODED OUT OF LIMITS. CUT AND SPLICE PAN. REPAIRED IAW SRM 53-20-15 REPAIR 7.SDR AALA20090914AFW02Failsafe · severedWHILE REPLACING STRINGER 39L AT STA 1307, STRINGER SECTION WAS OVER 24 INCHES REQUIRING THE FRAME AT STA 1307 TO BE SEVERED ALONG THE WEB PORTION VERTICALLY BETWEEN STR 38L AND 39L. THE OUTER FAIL-SAFE CHORD WAS SEVERED VERTICALLY BETWEEN STR 36L AND 37L AND SDR C2XA09TY236Door Frame · corrodedBOTTOM AFT CORNER OF SERVICE DOOR HAS CORROSION. REPAIRED FRAME 22 IAW EC5310-01478 AND IC2009-145/07100.SDR QXEA2009091100665Structure · damagedCHAFE DAMAGE LOCATED AT APPROX FS 977.00 AND S27 LENGTH OF CHAFE APPROX 2.5" DAMAGE CAUSED BY NUTPLATE CHANNEL FOR FUSELAGE FAIRINGS. DAMAGED AREA WAS 1.10" LONG .050 WIDE AND .015 DEEP. BLENDED AREA TO .016 DEEP WITH 20 TO 1 TRANSITION IAW REO 670-53-00-01SDR 2009FA0000781Rivet · shearedRIVET AT SPAR INTER-CONNECT, AFT BULKHEAD AT REAR PORTION OF BATTERY BOX, UPPER LT SIDE, STA 65 (APPROX), RIVET HEAD SHEARED.SDR LR7A2009090900099Beam · crackedDURING SCHEDULED C-9 CHECK PER JOB CARD HC5324, FOUND RH UPPER W/W BOW BEAM O/B CAP CRACKED AT FS 497, WL 260, RBL 64. REPAIRED IAW SRM SMP583 FIG 53-10-12.SDR ASAA0976524Support · chafedFAIRING SUPPORT STRUCTURE CHAFED ON LOWER SURFACE. REMOVED AND REPLACED SUPPORT.SDR SWAA095760Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 727D, STR 17L. REMOVED AND REPLACED WEB PER SRM.SDR C2XA09SH292Window Frame · crackedSHV - DURING C-CHECK FRAME 10 CRACKED AT LT DV WINDOW CUTOUT. MAINTENANCE REMOVED AND REPLACED CHANNEL SPLICE FOR FRAME 10 BELOW LT DV WINDOW CUTOUT IAW EMB-145 SRM 51-40-02 AND CPM 51-21-04/05/06. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR QXEA2009090900658Door Frame · corrodedDURING INSPECTION FOUND CORROSION ABOVE FWD PORTION OF FWD CARGO BAY DOOR SURROUND STRUCTURE. JUST BELOW S16L AT FS 549.00. REMOVED ALL CORROSION. ALL WORK DONE IAW SRM 51-11-00, 51-12-00, 51-21-06 AND 51-42-06.SDR HEEA125992Support · crackedDURING OIL COOLER BLOWER CHANGE FOR ELEVATED VIBRATIONS FOUND CRACKS IN DECK STRUCTURE UNDER OIL COOLER BLOWER SUPPORT. MAINTENANCE REPAIRED CRACKS IN THE DECK STRUCTURE BELOW THE OIL COOLER BLOWER AND REPLACED THE OIL COOLER BLOWER DUE TO HIGH VIBRATION LEVESDR ASOA200900978Post · crackedFS 409+128 VERTICAL POST LBL 18.0 O/B POST HAS INDICATION NOTED APPROX .2" IN LENGTH 50% FSH AT AFT FLANGE WL 69.0 FAILED NDT INSPECTION. REMOVED INBD AND OTBD VERTICAL POSTS PER SRM 51-42-06. FABRICATED REPLACEMENT POST IAW SRM 51-24-21, REF SWG 601532208SDR ASAA0976521Door Frame · crackedFWD CARGO BAY DOOR CUTOUT AFT FRAME CLOSE OUT REVEAL CRACKED AT LOWER END FWD EDGE. REMOVED CRACKED REVEAL, FABRICATED REPLACEMENT REVEAL AND INSTALLED.SDR GLBA20090904LRib · bentTHE CTR RIB NR 1 WAS FOUND BENT AT APPROX FS 8241.7 AFT OF FRAME 24. DAMAGE EXTENDS FROM INNER SIDE UP APPROX 95 MM AND IS BENT AFT APPROX 2MM AND THE SKIN IS CHAFED IN THE SAME AREA APPROX 70MM X 70MM. MX REPAIRED THE AFFECTED AREA AND PERFORMED THE REQUIRSDR GLBA20090904KStructure · damagedDENT AT TS 15370 AFT OF CARGO DOOR APPROX 21 INCHES X 12 INCHES X .375 INCH DEEP. FRAME BROKEN AT FS 15370 AND STR 15L. STR 15L BROKEN IN HALF/ STR 16L CRUSHED AND CRACKED. FRAME TO SKIN CLIPS DESTROYED FROM STR 14L TO 17L. MX REPAIRED THE AFFECTED AREA ASDR 2009F00103Door Frame · damagedFUSELAGE STATION 1660 LONGERON 15 RT. REMOVE AND REPLACE THIS REPAIR AT R-2 AFT DOOR JAMB WITH REPAIR IAW APPROVED DATA. INDICATE REINSPECTION INTERVAL IF REQUIRED. (MAJOR REPAIR)SDR SWAA095674Crease Beam · corrodedDURING SCHEDULED 8Y CHECK, FOUND R1 DOOR CREASE BEAM CORRODED BETWEEN BS 294 TO BS 332, RBL 56. REPAIRED BEAM PER SRM.SDR WX0A070406Pan · crackedWO 94582 AT STA 1155 RT WINDOW BELT CRACKED AT LOWER FWD CORNER. REPAIRED PER ESO 80559 DATE 28 AUG 2009.SDR WX0A070405Pan · crackedLEFT SIDE STA 946-965 FWD TOP EAR CRACKED ON WINDOW PAN.SDR WX0A070403Window Frame · crackedTHE WINDOW PAN WAS FOUND CRACKED AT STA 886-905 RT LOWER AFT TAB. REF AA N/R 6200761.SDR WX0A070402Window Frame · crackedTHE WINDOW PAN WAS FOUND CRACKED AT STA 886-905 RT UPPER FWD TAB. REF AA N/R 6200760.SDR WX0A070401Window Frame · crackedTHE WINDOW PAN WAS FOUND CRACKED AT STA 845 RT TOP FWD TAB. REF AA N/R 6202717.SDR FDEA200909013209Crease Beam · misalignedWHILE PERFORMING PTF SECTION 46 RT CREASE BEAM MOD, PRODUCTION FOUND A MISMATCH INBD TO OUTBD BETWEEN THE CREASE BEAM INNER CHORD AT THE PRODUCTION SPLICE AT APPROX STA 1628, RBL 63. A REPAIR WAS ACCOMPLISHED AT STA 1590-1628, RBL 63, CREASE BEAM INNER CHORDSDR FDEA200908313190Splice · misalignedSPLICE 657N3338-35, WILL HAVE SHORTED AT THE FWD MOST FASTENER HOLE COMMON TO IT'S VERTIVLE LEG IF DRILLED. DUE TO THE DISCREPANCY EFFECTING THE PTF MOD A REPAIR WAS ACCOMPLISHED ON MAE MOD W/C 118350452CZ2R01, MAE EA 757-5341-16-F2256, REV-, AT STA 1150-118SDR SWAA095639Door Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME CRACKED. REMOVED AND REPLACED FRAME PER ACO.SDR FDEA200908313170Door Frame · corrodedINSPECTED UPPER CARGO DOOR JAMB STRUCTURE CORROSION ON UPPER DOOR JAMB. ACCOMPLISHED EA NR 8-5310-129649.SDR SWAA095595Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 727D TO BS 727E, STR 17L. REPAIRED WEB PER BAC DWG.SDR FDEA200908283115Bracket · misalignedTV MONITOR BRACKETS INTERFERES WITH PROVISIONS INSTALLATION FROM FS-377 TO FS-1640, STR 3L TO STR 3R. AT BS-760-800, 980-1020, 1100-1140, 1320-1360, AND 1440-1460, B/T STR 3L-3R, FRAME REPAIR WAS ACCOMPLISHED, DUE TO DISCREPANCY EFFECTING THE PTF CONVERSION, OSDR ZZDA2009246Door Frame · corrodedFWD CARGO COMPARTMENT DOOR CUTOUT CORRODED. CUT OUT DAMAGED LOWER SECTION AND INSTALLED LOWER SECTION AND SPLICE REPAIR PER REF B717 SRM 53-20-15 REPAIR 6 FIG 201.SDR SWAA095574Door Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FORWARD CARGO DOOR CUTOUT AFT FRAME CRACKED. REMOVED AND REPLACED FRAME PER ACO.SDR SWAA095504Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 420 TO BS 440, STR 17R. REPAIRED WEB PER SRM.SDR AALA20090902TUL14Door Frame · corrodedMID CARGO DOOR BEAM CORRODED ON VERTICAL LEG. REMOVED CORROSION AND INSTALLED DOUBLER IAW AARD 53-10-00-3.SDR 2009F00062Spacer · misinstalledINVESTIGATED FLIGHT CREW REPORT OF HUMMING/WHISTLING NOISES COMING FROM AFT CABIN CEILING AREA. FOUND SIGNIFICANT LEAKAGE FROM BETWEEN ADF ANTENNA ASSY AND FUSELAGE SKIN. UPON ADF ANTENNA REMOVAL NOTED AFT SPACER INSTALLED INCORRECTLY AND GASKET CUT TO FIT INSDR USAA2009092892653Door Frame · crackedSAL - C23 - MAJOR REPAIR - CRACK ON WEB FRAME AT FORWARD ENTRY DOOR LOWER STOP FITTING AT BS 303.9, S16L. REPAIRED WEB FRAME AT FORWARD ENTRY DOOR LOWER STOP FITTING AT BS 303.9, S16L IAW ENGINEERING JOB CARD M1L53001.SDR FDEA200908193054Crease Beam · corrodedRT CREASE BEAM INBD CHORD UPPER SURFACE CORR, STA 1340-1360. REMOVED CREASE BEAM, RECEIVED NEW CREASE BEAM PN 146N8326-2, INSTALLED CREASE BEAM RT AT STA 1300-1400, IAW SRM 51-40-02, CATEGORY "A", MAJOR REPAIR.SDR SWAA095357Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM WEB CRACKED BETWEEN BS 188 TO BS 196.5, STR 17L. REMOVED AND REPLACED WEB PER SRM.
Back to JASC 5310