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 FDEA201109284184Crossbeam · corrodedAFT CARGO BAY CROSSBEAM AT FR62 FOUND CORRODED AFT CARGO CROSSBEAM AT FR 62 REPLACED IAW SRM 51-40-21, MAJOR REPAIR.SDR HNAA2011101300336Structure · corrodedLIGHT CORROSION AT STA X202 STR 31P. POLISHED AREA, INSPECTED AND FOUND NO CORROSION. ALODINED AND PRIMED IAW AMM 20-34-08.SDR FDEA201109274162Floorbeam · corrodedSTA 324, UPPER FLOORBEAM TEE CORRODED LBL 10 TO RBL 45. REMOVED CORROSION IAW SRM 51-10-02. AREA OUT OF LIMITS IAW SRM 53-00-51 FIG 101. REMOVED DAMAGED TEE IAW SRM 51-40-02. RECIEVED NEW TEE AND INSTALLED IAW SRM 51-40-02. MAJOR REPAIR.SDR SWAA116780Crease Beam · corrodedDURING SCHEDULED 24Y CHECK, FOUND RT CREASE BEAM WEB CORRODED BETWEEN BS 500A TO BS 500B. REPAIRED WEB IAW SRM AND DWG.SDR IPXA11569785Structure · corrodedINSPECTION TYPE:C-CK, PASSENGER CABIN FLOOR STRUCTURE BS 1720 AND LBL 59 TO RBL 59, EVIDENCE OF CORROSION UNDER ANGLE FORWARD OF DRAIN GUTTER, MARKED BLENDED AREAS OF CORROSION AND REPAIRED IAW EA 111312 IR AND EO B757-5 310-44716-A.SDR FDEA201109224020Web · damagedAFT AIRSTAIRS AREA RT SIDE FUSELAGE TORQUE BOX INBD VERTICAL WEB HAS DAMAGED AREA AT BS 1254. REMOVED DAMAGED VERTICAL WEB AT RT TORQUE BOX, RBL 20.5 STA 1253 TO 1283, FABRICATED NEW, AND INSTALLED NEW WEB AT RT TORQUE BOX IAW DWG 65C13874, REV B.SDR SWAA116754Crease Beam · damagedDURING SCHEDULED RON CHECK, FOUND RT CREASE BEAM WEB HEAT DAMAGED AT BS 277, STR 17R. REMOVED AND REPLACED WEB IAW EA AND AAR EA.SDR SWAA116750Crease Beam · damagedDURING SCHEDULED RON CHECK, FOUND CREASE BEAM WEB HEAT DAMAGED BETWEEN BS 259 TO BS 277, STR 17R. REMOVED AND REPLACED WEB IAW EA AND EA.SDR SWAA116749Crease Beam · damagedDURING SCHEDULED RON CHECK, FOUND CREASE BEAM OUTER CHORD HEAT DAMAGED BETWEEN BS 259 TO BS 277, STR 17R. REMOVED AND REPLACED SECTION OF CHORD IAW EA AND EA.SDR DALA1154873713Crease Beam · corrodedR1 CREASE BEAM CHORD CORRODED STA 326. REMOVED AND REPLACED CHORD IAW SRM 51-40 BOEING DWNG141A8310.SDR 7AHR2011092003Structure · corrodedCORROSION UNDER FLOORBOARD SPLICE AT STA 464 BETWEEN STRINGER 27R AND 26R IN FORWARD PIT.SDR SWAA116703Crease Beam · corrodedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 420 TO BS 440, LBL 67. REMOVED AND REPLACED WEB IAW SRM.SDR GLBA20110921JDoor Frame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUTINE INSPECTION FOUND A CRACK IN THE CARGO DOOR FRAME, FWD SIDE, FS 456, BETWEEN STRINGER 3L AND 4L, .7" IN LENGTH. MX REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS IAW EO 11-1900-53-056. MATERIALSSDR FDEA201109203970Failsafe · damagedBS 640 BETWEEN STR 24-25 HAS ELONGATED HOLES IN THE FAILSAFE. REMOVED AND REPLACED IAW SRM 51-40-02 REV.103. REPAIR IS CLASSIFIED AS MAJOR.SDR SWAA116735Crease Beam · corrodedDURING SCHEDULED 24Y CHECK, FOUND LT CREASE BEAM WEB CORRODED BETWEEN BS 787 TO BS 807. REPAIRED BEAM IAW SRM, MM AND DWG.SDR DALA1157506310Door Frame · crackedRT NR 4 DOOR FWD FRAME LOWER CORNER CRACK BS 1680. S-25R. L=0.8 PERFORMED THE FRAME-WEB REPAIR PER B747-400 SRM 52-10-02 REPAIR 2 P201. INSPECTION THRESHOLD 15000 DOOR FLIGHT CYCLES, INTERVAL 3000 DOOR FLIGHT CYCLES, METHOD INTERNAL AND EXTERNAL DVI.SDR IPXA1M69597Door Frame · damagedINSPECTION TYPE:3C, CTR CARGO DOOR AFT JAMB GOUGED & CRACKED AT EXTERNAL REPAIR DOUBLER ADJACENT TO L41-42R STA 1781. DVI AND NDT VERIFIED NO CRACKS PRESENT AT DAMAGE SITE. REPAIRED CTR CARGO DOOR AFT JAMB, GOUGE DAMAGE STA 1781 IAW STA SA EA 011-5330-01- A3SDR SWAA116640Crease Beam · corrodedDURING SCHEDULED 24Y CHECK, FOUND LT CREASE BEAM WEB CORRODED BETWEEN BS 867 TO BS 887. REPAIRED WEB IAW DWG.SDR ZZDA2011774Door Frame · corrodedFORWARD CARGO DOOR CUTOUT, CORROSION. ACCOMPLISHED SPLICE REPAIR PER B717 SRM 51-32-01 AND 53-20-15.SDR SWAA116580Crease Beam · corrodedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 400 TO BS 420, RBL 67. REMOVED AND REPLACED WEB PER SRM.SDR SWAA116579Crease Beam · corrodedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 460 TO BS 480, LBL 67. REMOVED AND REPLACED WEB PER SRM.SDR ZZDA2011772Door Frame · crackedRIGHT MLG WHEEL WELL DOOR FORWARD CUTOUT FRAME, CRACKED. ACCOMPLISHED FRAME CHANNEL REPAIR PER B717 SRM 53-20-02 AND 51-32-01.SDR DALA1154149013Beam · corrodedDURING HMV CORROSION WAS FOUND ON LOWER BEAM OF MID CARGO COMPARTMENT DOOR JAMB FROM STA Y=636 TO Y=693 BEAM. REPAIRED IAW MD80 SRM 53-05D FIG 123.SDR QMLA20110916002Door · corrodedCORROSION FOUND COMING FROM UNDER PROTECTIVE PLATE ON EXTERIOR OF PANEL ASSY. (RT ENGINE DOOR) PANEL WAS REMOVED AND SENT TO VENDOR FOR REPAIR.SDR QMLA20110916001Door · corrodedCORROSION FOUND COMING FROM UNDER PROTECTOR PLATE ON EXTERIOR OF PANEL ASSY. (LT ENGINE DOOR) PANEL WAS REMOVED AND SENT TO VENDOR FOR REPAIR.SDR UALA2011091605012Crease Beam · corrodedCORROSION ON CREASE BEAM AT BS 1020-1040 RT SIDE (N-R 3175N00447). MAJOR REPAIR ACCOMPLISHED. REMOVED CORROSION ON EXISTING PRODUCTION DOUBLER ON CREASEBEAM WEB AT BS 1035. THE MATERIAL LOSS WAS OUT OF LIMITS OF SRM. FABRICATED & INSTALLED NEW WEB DOUBLER SDR 29GA94353091611ADoor Frame · crackedDURING SCHEDULED ROUTINE INSPECTION DISCOVERED AVIONICS DOOR FUSELAGE FRAME RIGHT CHANNEL HAS .6 INCH CRACK AT AFT LOWER CORNER RADIUS. CUT OUT CRACK AND INSTALLED REPAIR STRAP.SDR ZZDA2011769Door Frame · crackedL1 DOOR FRAME, STA 207, LONG L16, CRACKED. ACCOMPLISHED DOOR FRAME DOUBLER REPAIR PER B717 SRM 51-70-10.SDR ZZDA2011744Door Frame · crackedMAIN CABIN DOOR AFT ENTRY DOOR JAMB, STA 208, LONG S15L, CRACKED. ACCOMPLISHED AFT ENTRY DOOR JAMB DOUBLER REPAIR PER B717 SRM 51-70-10.SDR SWIA201128206Structure · crackedCRACK AT FS 202 AT THE PARKING BRAKE CABLE PATH. (C-CHECK) REPAIRED PER REO.SDR FDEA201109143875Structure · corrodedCORROSION AT STA 425 STR 30 AT TOILET DUMP VALVE, INSIDE E/E BAY. DOT # 82149.SDR ASOA201101742Post · crackedFOUND FS 409.0+128 VERT POST LBL 18.0 INBD AND OTBD SIDE HAVE INDICATIONS NOTED APPROX .3" IN LENGTH 50 PERCENT FSH. BOTH FAILED NDT INSP AT WL 69.0 AFT FLANGE RADIUS. APPLIED DINOTROL IAW SRM 51-21-11. EC/TC REQUIRED FOR REO 601R-53-41-889 REV A. COMPLIESDR ZZDA2011760Splice · corrodedAFT CARGO DOOR CUT OUT LOWER JAMB FWD AND AFT SPLICES, CORROSION. ACCOMPLISHED LOWER JAMB FWD AND AFT SPLICES SPLICE REPAIR PER B717 SRM 51-10-04, 53-20-15 AND 51-41-02.SDR ASOA201101722Beam · corrodedFLOOR SUPPORT STRUCTURE TRANSVERSE BEAM AT FS 349 IS CORRODED BETWEEN RBL 36 & RBL 45. LOCATED & DRILLED NEW TRANSVERSE BEAM IAW SRM 51-40-06 & SRM 51-40-11. INSTALLED TRANSVERSE BEAM IAW SRM 51-42-06 & 51-42-21.SDR ASOA201101719Beam · corrodedFLOOR SUPPORT STRUCTURE TRANSVERSE BEAM AT FS 349 IS CORRODED AT LBL 45. REMOVED CORROSION ON BEAM AND FOUND TO BE WITHIN ALLOWABLE LIMTS IAW SRM 51-21-06. MAX MATERIAL REMOVED .005". ALODINED AREA IAW SRM 51-21-11. POINTED PREP IAW SRM 51-25-16.SDR SWAA116544Crease Beam · corrodedDURING SCHEDULED 24Y CHECK FOUND, CREASE BEAM WEB CORRODED BETWEEN BS 400 TO BS 420, LBL 67. REPAIRED WEB IAW SRM.SDR FDEA201109133855Crease Beam · corrodedBS 1420 TO STA 1440 CREASE BEAM WEB HAS CORROSION. REMOVED AND REPLACED IAW SRM 51-40-02 REV. 103. REPAIR IS CLASSIFIED AS MAJOR.SDR FDEA201109133863Door Frame · gougedPASENGER DOOR 1 L FWD DOOR FRAME AT BS 337.5, ADJACENT TO S8L GOUGED. BLENDED GOUGE IAW 51-10-02 CHECKED LIMITS, ORIGINAL MAT .063" AFTER REWORKED .038" FOUND TO OUT LIMITS IAW SRM 53-10-15, FIG 101 DETAIL IV. REMOVED FRAME IAW SRM 51-40-02, FABRICATED, LOCASDR A6WA201140885Post · crackedLBL 18 OTBD SIDE OF POST AT FS 409.0 +128 CRACKED IN LOWER RADIUS. REPAIRED CRACK IAW REO 601R-53-41-056.SDR HALA2011091200417Door Frame · corrodedAFT CARGO COMP DOOR JAMB LWR SIDE HAS SEVERAL SPOTS OF CORROSION. REMOVED CORROSION AT AFT CARGO COMP DOOR JAMB LWR SIDE(PAN). AFTER CORROSION REMOVAL FOUND AREA LWR DOOR JAMB (PAN) OUT OF LIMITS IN REF WITH SRM 53-00-00. ACCOMPLISHED REPAIR FOR DOOR JAMB PASDR 29GA94653091211ADoor Frame · crackedDURING SCHEDULED ROUTINE STRUCTURAL INSPECTION DISCOVERED AFT CARGO DOOR FRAME AT FS 510 APPROXIMATELY LEFT STRINGER 4 CRACKED APPROXIMATELY 2.0 INCHES. REMOVED DAMAGED SECTION OF FRAME AND INSTALLED 45 INCH SECTION OF FRAME SPLICE REPAIR.SDR FDEA201109093812Support Fitting · crackedMAIN CARGO DOOR FRAME, CENTERING GUIDE, LOWER AFT SUPPORT FITTING CRACKED. FABRICATED & INSTALLED SUPPORT FITTING.SDR USAA2011091500009Crease Beam · corrodedC3 CHECK - CORROSION ON UPPER CHORD OF CREASE BEAM AT BS 640, LBL 64.4. REPLACED UPPER CHORD OF CREASE BEAM AT BS 640, LBL 64.4 IAW B757 53-30-13 DETAIL VIII, 51-40-02 FIG 12.SDR FDEA201109083750Stop Fitting · wornAFT CARGO COMPT DOOR CUT- OUT LOCKING FITTING NR7 STOP FITTINGS HAVE WEAR MARKS. REMOVED AFT CARGO DOOR LOCKING FITTING, VERIFIED PN F5347512020000 ORDERED AND RECEIVED NEW FITTING FROM MFG. INSTALLED NEW FITTING IAW SRM 51-72-10 APPLIED CORROSION INHIBITSDR DALA1151939014Window Frame · damagedLIGHTNING STRIKE ON FWD/AFT SECTION OF WINDOW FRAME NR 32 BETWEEN STA Y=503 TO 522 AT FUSELAGE EXTERNAL SKIN. REWORKED PER ERA 495214-14 REV ORG.SDR DALA1151919014Window Frame · damagedSCRIBE LINES AROUND WINDOW FRAME NR 64 BETWEEN STA Y=807-826 AT FUSELAGE SKIN. REWORKED PER ERA 495214-14 REV ORG.SDR FDEA201109073741Door Frame · corrodedSTA 1380 NR 2 CARGO DOOR STR 22 CORRODED ON DOOR FRAME.SDR IPXA11569454Beam · corrodedINSPECTION TYPE: C1, CORROSION ON MAIN CARGO STUB BEAM UPPER SURFACE AT NUTPLATE LOCATIONS, BS 900, RBL 48-54, WL 208. REPLACED IAW DWG 144N1079, AND FABRICATED IAW DWG 144N1074. INSTALLED IAW SRM 51-40-02, SRN 51-40-05, AND SRM 51-40-08.SDR IPXA11569453Beam · corrodedINSPECTION TYPE: C1, CORROSION ON MAIN CARGO STUB BEAM UPPER SURFACE AT NUTPLATE LOCATIONS BS 900, LBL 48-54, WL 208. REPLACED IAW DWG 144N1079 AND FABRICATED IAW DWG 144N1074. INSTALLED IAW SRM 51-40-02, SRN 51-40-05, AND SRM 51-0-08.SDR KCSA111206Door Frame · crackedL-4 MAIN ENTRY DOOR FWD LOWER CORNER FRAME CRACKED, BS 1675, WL 201.
Back to JASC 5310