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 2008UALA03900Beam · corrodedFOUND BEAM 210 CORRODED REF EQ3700. *S/D* ACCOMPLISHED MAJOR REPAIR AT DEN. REMOVED BEAM, PREPPED AND RE-INSTALLED.SDR 2008UALA03899Beam · corrodedFOUND BEAM NR 175 CORRODED REF EQ3700 B. *S/D* ACCOMPLISHED MAJOR REPAIR AT DEN. REMOVED BEAM, PREPPED AND RE-INSTALLED.SDR 2008UALA03898Beam · corrodedFOUND BEAM 205 CORRODED REF EQ3700. *S/D* ACCOMPLISHED MAJOR REPAIR AT DEN. REMOVED BEAM, PREPPED AND RE-INSTALLED.SDR 2008UALA03897Beam · corrodedFOUND BEAM NR 200 CORRODED REF EQ3700. *S/D* ACCOMPLISHED MAJOR REPAIR AT DEN. REMOVED BEAM, PREPPED AND RE-INSTALLED.SDR SWAA083999Crease Beam · corrodedDURING SCHEDULED BRDG CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 434, STR 17L. REPAIRED CREASE BEAM PER SRM.SDR TRAX200800913Beam · crackedBOTTOM ATTACH ANGLE FOR BAGGAGE DOOR LINTEL BEAM MEMBER IS CRACKED IN AREA OF OUTBOARD FASTENER APPROX .50" LONG. REMOVED CRACKED BOTTOM ATTACH ANGLE FOR BAGGAGE DOOR LINTEL BEAM. LOCATED, DRILLED AND INSTALLED A NEW SERVICEABLE ANGLE IAW CRJ200 SRM 51-40-11SDR 08FDEA02911Stringer · corrodedFOUND CORROSION ON STRINGER P 56 LT, C59-62 STRINGER REPAIR PERFORMED IAW. SRM 53-10-14 FIG. 201A.SDR KCS2008F00005Window Frame · crackedCENTER WINDSHIELD FRAME WAS FOUND CRACKED DURING INSPECTION REQUIRED BY FALCON JET. THE WINDOW FRAME WILL BE REPLACED USING FALCON JET APPROVED PROCEDURES, DRAWINGS AND NEW WINDOW FRAME. NOTE, COMPLETE PART NUMBER ON FRAME IS NOT LEGIBLE. (A)SDR KCS2008F00002Frame · crackedCENTER WINDSHIELD FRAME WAS FOUND CRACKED DURING INSPECTION. THE WINDOW FRAME WILL BE REPLACED USING APPROVED PROCEDURES, DRAWINGS, AND NEW WINDOW FRAME. NOTE, COMPLETE PART NUMBER ON FRAME IS NOT LEGIBLE. (S)SDR F3LA200800488Door Frame · corrodedDURING C-CHECK INSP NOTED CORROSION ON TOP LEG OF FRAME C55A AT FWD EDGE OF C2 DOOR. MAINT REPAIRED DAMAGE ON TOP LEG OF FRAME C55A IAW EA NR A9-53R-30442. UPON COMPLETION OF THE REPAIR IT WAS INSPECTED AND FOUND ACCEPTABLE. (B)SDR 08FDEA02874Crease Beam · corrodedMAIN CABIN CREASE BEAM CHORD BS 680 -740, RBL 66 HAS CORROSION. REMOVED CORROSION AND FOUND OUT OF LIMITS. REMOVED CREASE BEAM, RECEIVED NEW PART NR 143N8328U54 IAW SRM 53-30-13. INSTALLED NEW CREASE BEAM PART IAW SRM 51-40-02, AND 51-10-02, FS 680-740, RSDR SWAA083824Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 847 TO BS 867, LBL 70. REPAIRED WEB PER SRM AND BOEING DRAWING.SDR SWAA083858Door Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FWD SERVICE DOOR CUOUT FWD FRAME CRACKED AT BS 294.5, STR 7R. REPAIRED FRAME PER SRM.SDR UPS08852736Frame · crackedPITS 32 AND 34 CARGO DOOR INNER CRACKS. ISSUED DEFERRAL D380080 IAW EO DC8-5230-29933-A. DAMAGE CONSISTS OF 2.0" LONG CRACK LOCATED ON THE INSIDE RADIUS OF FRAME. VERIFIED ENDS OF CRACK IAW NDT MANUAL 06-10-01 MARKED ENDS. MEASURED CRACK TO BE 2.0" LONG. SDR USAA920081375Door Frame · crackedCLT-Q3 CHECK -MAJOR REPAIR- CRACK IN FRAME AT RIGHT FORWARD SERVICE DOOR CUTOUT AT FORWARD LOWER CORNER BS 294.5. REPLACED FRAME AT RIGHT HAND FORWARD SERVICE DOOR CUTOUT AT FORWARD LOWER CORNER BS 294.5 IAW B737 SRM 51-10-02 AND BOEING DRAWING 65-45807. (B)SDR KSCA081317Door Frame · crackedR-5 DOOR FRAME HAS A CRACK 1.250 INCH AT STA-2231 BETWEEN STR-16R AND 17R. (A)SDR USAA920081333Door Frame · crackedPIT- RON MAJOR REPAIR LOG PAGE NR 4353032- WHILE ACCOMPLISHING THE REPETITIVE INSPECTIVE OF FORWARD CARGO DOOR OPENING, TWO CRACKS WERE FOUND AT S24R BS 492.4 REF US AIRWAYS EA 111238. REPAIRED FORWARD CARGO DOOR OPENING AT S24R BS 492.4 IAW US AIRWAYS EA 111SDR 08FDEA02779Crease Beam · crackedFUSELAGE OUTER CREASE BEAM CHORD (STR 17L) CRACKED REMOVED CREASE BEAM CHORD, STR 17L, FROM STE 620 TO STA 663. VERIFIED MATERIAL TO BE BAC1506-1133 7075-T-6, ATAG NR A00531. LOCATED AND DRILLED FASTENER HOLES IN NEW CHORD. TREATED AND PRIMED NEW CHORD. INSDR UPS08M52687Door Frame · damagedAFT LWR CARGO DOOR FRAME DAMAGED.SDR 08FDEA02733Window Frame · corrodedFOUND CORROSION IN 7 FASTENER HOLES OF WINDSHIELD FRAME LT/RT. REPAIR PERFORMED BY OVERSIZING OF HOLES, NDT FOR CRACK FREE CONDITION AND INSTALLING NEW FASTENER IAW RAS 70507106/2008 ISS A, APPROVED BY EA 6-5311-120048.SDR 08FDEA02731Crossbeam · corrodedFOUND CORROSION ON AFT FACE OF CROSS STRUT C87 RT REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR C2XA08CL082Screw · looseDURING ROUTINE MAINTENANCE THE LT EMERGENCY EXIT HATCH WOULDN’T OPEN. MAINTENANCE INSPECTED AND FOUND SCREW LOOSE ON SIDE OF DOOR FRAME. THE SCREW WAS TIGHTENED AND OPERATIONAL CHECKS OF THE DOOR WAS GOOD. (A)SDR KCSA081311Door Frame · crackedRT SIDE FUSELAGE CLOSURE FRAME IS CRACKED 3" AT LOWER FORWARD CORNER OF THE R5 DOOR CUTOUT AT BS 2236, WL 208 (B)SDR 2008UALA03723Crease Beam · corrodedCREASE BEAM AREA BETWEEN STA 940 TO 960, STR 17L HAS CORROSION. *S/D* ACCOMPLISHED MAJOR REPAIR AT GSO. REMOVED WEB, FAB NEW WEB REF BOA DWG 144N5150 REC AND 144N5140. INSTALLED PER SRM 51-4-02.SDR F3LA200800412Shear Plate · corrodedDURING C-CHECK INSP, NOTED LT INTERCOSTGAL WEB UNDER LATERAL SHEAR PLATE AT STRINGER 23 LT FROM FRAME 69 TO FRAME 70 HAS CORROSION ON TOP AND BOTTOM SIDES. MAINT REMOVED CORRODED WEB, DRILLED, TREATED AND PRIMED HOLES AND INSTALLED NEW WEB IAW SRM 51-72-11. UPSDR TRAX200800888Structure · corrodedMINOR CORROSION AROUND FASTENERS BELOW LAV SERVICING POINT FS 559+80 - 559+112 STR 23R. REMOVED FASTENERS BELOW LAV SERVICING POINT. REMOVED CORROSION & REINSTALLED FASTENERS IAW SRM 51-42-06 & SRM 51-21-06. PRESSURIZATION CHECK DUE. PRESSURIZATION CHECK GSDR 08FDEA02631Crease Beam · crackedMID CABIN CREASE BEAM WEB CRACKED AT STA 945, LBL 47, WL 208. REPLACED WEB REF SRM 51-30-02 PG 6, DRAWING NR 65-21905. THIS IS CLASSIFIED AS A MINOR REPAIR.SDR ASAA0843225Channel · corrodedL 1 DOOR LOWER CUTOUT U CHANNEL IS CORRODED. REPLACED CHANNEL IAW SRM 51 40 02.SDR TRAX200800864Support Beam · crackedCARGO DOOR SUPPORT BEAM LOWER ANGLE IS CRACKED APPROX 1.5". REMOVED SUPPORT BEAM LOWER AFT BRACKET AND INSTALLED NEW SERVICEABLE BRACKET IAW SRM 51-42-21. LEAK CHECK DUE. PRESSURIZED ACFT IAW AMM 21-32-00-863-801. LEAK CHECK GOOD. (S)SDR UPS08852730Torque Box · damagedINSPECTION TYPE-C2, MAIN CABIN, RT AFT SERVICE DOOR FRAME (TORQUE BOX) WEB HAS DOUBLE DRILLED AND EXTRA HOLES STA 1660 L-19R. FABRICATED AND INSTALLED REPAIR DOUBLER IAW SRM 53-02-00-0 FIG 001D, 5 1-01-21.SDR 08FDEA02617Window Frame · damagedLOUD NOISE THAT APPEARED TO COME FROM THE CAPT'S SLIDING WINDOW AREA. A VIBRATION COULD BE FELT ON THE POST IN THE WINDOW ARM. BUT COMMUNICATION WAS NEARLY IMPOSSIBLE WITH ATC. EVENTUALLY AN EMERGENCY WAS DECLARED. LOWER ALTITUDE AND LOWER AIRSPEED HELPED.SDR 2008UALA03663Crease Beam · corrodedMAIN CABIN RT SIDE CREASE BEAM WEB UPPER SURFACE CORRODED FROM STA 1380 TO STA 1400, RBL 71. *S/D* ACCOMPLISHED MAJOR REPAIR AT GSO. REPLACED WEB PER BAC DWG 1 46N5590 REV BN, MM51-21-00 AND SRM 51-40-02.SDR SWAA083645Crease Beam · corrodedDURING SCHEDULED 8Y CHECK, FOUND CREASE BEAM CORRODED AT BS 312, STR 17R. REMOVED AND REPLACED CREASE BEAM PER SRM.SDR 08FDEA02605Beam · dentedFOUND NICKS AND OLD REWORKS ON BEAM SECTION, C 67-69, P 45 RT REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR 08FDEA02604Beam · corrodedFOUND CORROSION ON BEAM 10, C 67-69, P 45 RT REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR USAA920081406Door Frame · crackedCLT-Q3- MAJOR REPAIR - EXTERIOR FRAME CRACKED ON AFT SIDE AT NR 7 STOP PIN ACCESS HOLE. REPAIRED EXTERIOR FRAME AT NR 7 STOP PIN ACCESS HOLE IAW US AIRWAYS EA 100547. (A)SDR UPS08852893Doubler · crackedINSPECTION TYPE-C2, POSSIBLE CRACK IN RADIUS OF REPAIR DOUBLER ON BOTTOM OF J-BEAM, APB, 60 COMPT. STA 1766 BL0. REMOVED CRACKED DOUBLER,FABBED AND INSTALLED REPAIR DOUBLER IAW, SRM. 51-1-8, 53-2-5, 51-1-24, 51-1-20D, 51-3-1.SDR 08FDEA02570Crease Beam · crackedFUSELAGE CREASE BEAM WEB CRACKED, STR17L, BS-640-660 FABRICATED NEW CREASE BEAM WEB PER SAMPLE AND BOEING DWG NR 65-58536. TRANSFERED NEW FASTENER HOLES REF, SRM 51-30-2, PG 1-10. TREATED AND PRIMED WEB, REF: SRM 51-10-2, PG 1-2. WEB BE INSTALLED ON NR N007SDR SWAA083615Door Frame · crackedDURING SCHEDULED 8Y CHECK, FOUND R1 DOOR FRAME CUTOUT FWD FRAME CRACKED AT LOWER END. REPAIRED FRAME PER SRM.SDR SWAA083597Crease Beam · corrodedDURING SCHEDULED 8Y CHECK, FOUND CREASE BEAM CORRODED BETWEEN BS 947 AND BS 986.5, RBL 65. REPAIRED BEAM PER SRM.SDR SWAA083593Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 827 AND BS 847, LBL 70. REMOVED AND REPLACED WEB PER SRM.SDR SWAA083612Crease Beam · corrodedDURING SCHEDULED BRDG CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 907 TO BS 927, LBL 65. REPAIRED WEB PER SRM.SDR KCSA081301Torque Box · dentedAFT BILGE UPPER TORQUE BOX WEB HAS SEVERAL DENTS AT STA. 1840 TO 1860, LBL 46 TO LBL 62 (B)SDR 08FDEA02542Floor Panel · damagedMAIN CARGO DECK FLOOR PANEL 242 UJ IS CRACKED & CRUSHED. FABBED A NEW FLOOR PANEL; POTTED EDGES; CURED; SANDED; POTTED INSERTS; APPLIED NON-SKID & PART MARKED IAW DWG SRZ 25-005; REV F.SDR USAA920081284Door Frame · crackedPIT - PYLON SHIM - MAJOR REPAIR - FORWARD CARGO DOOR SURROUND STRUCTURE - FWD FRAME WEB CRACKED AT BS 560 S23R. REPAIRED FORWARD CARGO DOOR SURROUND STRUCTURE - FWD FRAME WEB AT BS 560 S23R IAW EA111264. (S)SDR SWAA083551Crease Beam · corrodedDURING SCHEDULED BRDG CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 950 TO BS 955, RBL 50. REMOVED AND REPLACED WEB PER SRM.SDR USAA920081273Door Frame · crackedPIT - FORWARD PRESSURE BULKHEAD - MAJOR REPAIR - FWD CARGO DOOR CUTOUT AFT FRAME CRACKED AT LOWER DOOR STOP. ST 492, S-24R, CRACK MEASURES .5 INCH, FOUND WITH HPEC MARKED ENDS. REPAIRED FWD CARGO DOOR CUTOUT AFT FRAME AT LOWER DOOR STOP ST 492, S-24R IAW EA SDR TRAX200800833Support Beam · crackedCARGO DOOR SUPPORT BEAM LOWER ANGLE IS CRACKED APPROX 1.5" IN LENGTH. REMOVED AND REPLACED CARGO DOOR SUPPORT BEAM LOWER ANGLE WITH NEW PART IAW SRM 51-42-21 AND 51-40-11. (B)SDR 08FDEA02422Door Frame · corrodedAFT PIT DOOR OPENING AFT FRAME STA 990 IS CORRODED ON LOWER SURFACE OF FRAME, UPPER ANGLE BETWEEN STR 26R AND STR 27R REMOVED CORROSION, FORMED REPAIR ANGLE, HEAT TREATED AND CAD PLATED REPAIR ANGLE. INSTALLED REPAIR ANGLE. REFERENCE EA NR 75310-113992.SDR 08FDEA02386Strut · corrodedAFT CARGO COMPT TUNNEL AREA FOUND MODERATE CORROSION ON STRUT.
Back to JASC 5310